
Announcements
Hi.
I'm trying to determine who created a specific Column in a Table, and when it was done. We're using Dataverse (with a M365 subscription).
I found an old thread that asks something similar, about a Table instead of a Column.
Do you think I could use the same tools suggested in the above thread? I've used XrmToolbox in the past, to do translations in a model-driven app, so I have a little bit of experience with that. I have never used FetchXml or FetchXml Builder though.
Hi
A possible way to find out who created a column in a Dataverse table is to query the creator of the views that are generated when creating a table. You can use FetchXml with the FetchXml Builder tool of the XrmToolBox to do this. Here is an example of the FetchXml code:
You need to replace the with the actual code of the table you want to check. <entity type code>
You must use the XRM ToolBox and the Fetch Builder tool.
The table is savedquery
<fetch top="50">
<entity name="savedquery">
<attribute name="createdby" />
<filter>
<condition attribute="returnedtypecode" operator="eq" value="entity type code" />
</filter>
<link-entity name="systemuser" from="systemuserid" to="createdby" alias="Propietario">
<attribute name="fullname" />
</link-entity>
</entity>
</fetch>
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution