ServiceDesk Plus | Active Directory/LDAP

Active Directory/LDAP
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 ...
Query to find out the users who are updated through LDAP import (MSSQL & PGSQL)
This should be handy during Audit. Execute the queries under Reports->New Query Report select ch.ciid "CI ID", ci.ciname "CI Name", chd.attribute "Attribute", chd.newvalue "New Value", chd.oldvalue "Old Value", ch.editmode "Edit Mode", ...

ServiceDesk Plus | Active Directory/LDAP | Knowledge Base