Manually update the 'Organizational Summary' after an AD Import

Products

• IT Management Suite

Issue/Introduction

Use Case:

Your issue resides on having certain OUs that are not populating their AD structure reference under "Resource Manager>Summaries>Organizational Summary".
AD Import is working just fine since the "Inv_OU_Membership" dataclass is populated with the proper references.
"Organizational Summary" is actually populated after a Delta Membership update and since you have it running every 2 hours, that is why you can't see right away those changes reflected after the AD Import.

Environment

ITMS 7.x, 8.x

Cause

There is not an issue here, just a misunderstanding on the process involved with the "Organizational Summary".

Resolution

1. Create a Task (a 'Run SQL Query on Server' type). Then add the following query on it:
   
   --OU Group 1 to refresh
EXEC spResourceTypeSystemScopeCollectionUpdate 
'GUID HERE',  --Organizational Group to Update
'493435F7-3B17-4C4C-B07F-C23E7AB7781F',  --Computer Resource <Do not change>
1  --1 means Run recursively <Do not change>

--OU Group 2 to refresh
EXEC spResourceTypeSystemScopeCollectionUpdate 
'GUID HERE',  --Organizational Group to Update
'493435F7-3B17-4C4C-B07F-C23E7AB7781F',  --Computer Resource <Do not change>
1  --1 means Run recursively <Do not change>
    
2. Repeat the query as many times as OU Groups you want to add. Just replace the GUID for the OU (you can find it under 'Manage>Organizational Views and Groups>Active Directory Domains' and browse to the one(s) you want, then right-click>Properties and grab the GUID).
3. Add a schedule that repeats as often as you want (like after your AD Import Rules run).