Query to show which Accounts were last sync’d (MSSQL & PGSQL)

Query to show which Accounts were last sync’d (MSSQL & PGSQL)

Tested in Build PGSQL (14300) or MSSQL (14306)


Please go to Reports- New Query Report and execute this query.

select org_id,
org_name as "Account",
case when org_id in
    (select distinct ADef.org_id FROM ADOrganizationalUnits ADOU LEFT JOIN ADOUsRelationInfo ADRI ON ADOU.OUID=ADRI.OUID
    LEFT JOIN SharedDomainOUmapping sdom on adou.ouid=sdom.ouid
    LEFT JOIN SharedDomainaccmapping sdam on sdam.mappingid=sdom.oumappingid
    LEFT JOIN AccountDefinition ADef on sdam.accountid=ADef.org_id
    WHERE ADOU.ISUSERSIMPORTED = 'true') then 'YES' else '' end as "Sync'd"
from AccountDefinition
order by org_name