Announcements
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?
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/UCnGNN3hdlKBOr6PXotskNLABlog : https://microsoftcrmtechie.blogspot.com
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-featuresA 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.
<fetch> <entity name="savedquery" > <attribute name="createdby" /> <filter> <condition attribute="returnedtypecode" operator="eq" value="<entity type code>" /> </filter> </entity> </fetch>
Hope this helps!
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, 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!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 519 Most Valuable Professional
11manish 489
Haque 327
