You’re offline. This is a read only version of the page.
Someone created a custom table in our default personal productivity environment. We are attempting to determine who and when this table was created. I haven't been able to determine where this information is stored, using the modern and legacy web GUI interfaces. In our TEST environment I have direct access to that environment with SSMS (SQL Server Management Studio). I am able to get some details from the sys.tables, however I don't have that access setup in PROD. Does anyone know how where I might find the creator & & created data using the web GUI interface?
Hi @robcaretta, unfortunately there's no easy way to determine who created a column. The common practice is to save the solution/configuration into a repo (eg Git) so then we have the full history of the changes included who and when changes were done. Cheers!
Hi @EricRegnier
I have a very similar situation to @robcaretta .
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).
Do you think I could use the same tools you suggested before? I've used XrmToolbox in the past, to do translations in a model-driven app, so I have a little bit of experience. I have never used FetchXml or FetchXml Builder.
Can you help adjusting the code you offered, to be able to be used with a specific column, instead of a table ?
Hi @robcaretta,
I assume you're using Dataverse/D365 online/cloud right? You might not be able to use SSMS in the other environment because the TDS endpoint is not enable. You can enable it in the Feature Settings in Power Platform Admin Center (aka.ms/ppac) https://docs.microsoft.com/power-platform/admin/settings-features
A trick to check the creator of the table is to query the creator of the views that are generated when creating a table. I use FetchXml with the FetchXml Builder tool of the XrmToolBox to facilitate this. Here's the FetchXml, set the right entity type code which you can select in the tool.
Share
Report
75
All responses (
Answers (
<fetch>
<entity name="savedquery" >
<attribute name="createdby" />
<filter>
<condition attribute="returnedtypecode" operator="eq" value="<entity type code>" />
</filter>
</entity>
</fetch>
Hope this helps!
Hello @robcaretta,
I think we cannot find the Owner who created table. Lets wait for others comments too
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
