How to update manually the 'Organizational Summary' after an AD Import

book

Article ID: 171618

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Use Case:

Customer mentioned that his 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 he has it running every 2 hours, that is why he can't see rightaway those changes reflected after the AD Import.
There is not an issue here, just a misunderstanding on the process involved with the "Organizational Summary".

Environment

ITMS 7.6, 8.0

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).