CRM export Tables

Hi Everyone,


I'm trying to find a way to directly match a export_[GUID] table to the specific job that created it. The below Query shows all the processes but I don't see the [GUID] of the table referenced anywhere?


Anyone know why I can find this in CRM ?


Thanks in advance,

Rob


select top 100 *

from EXPORTPROCESS

left join dbo.ADHOCQUERY on EXPORTPROCESS.ADHOCQUERYID = ADHOCQUERY.ID

left join dbo.SMARTQUERYINSTANCE on EXPORTPROCESS.SMARTQUERYINSTANCEID = SMARTQUERYINSTANCE.ID

left join dbo.EXPORTDEFINITION on EXPORTPROCESS.EXPORTDEFINITIONID = EXPORTDEFINITION.ID

Comments

Categories