nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CRM export Tables

Rob Mendes

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

Find more posts tagged with

Comments

Christine Griffin

EXPORTPROCESSSTATUS.ID

Rich White

Check out the BUSINESSPROCESSOUTPUT table. The TABLENAME field has EXPORT_<GUID> entries and the BUSINESSPROCESSSTATUSID shows the related GUID values.

Rajesh Shirsagar

exportprocessstatus.id

Rob Mendes

Thanks Rajesh. This is exactly what i was looking for.

Rob

Rob Mendes

Thanks this is very useful too.

Rob