How to add columns with user's manager cn and employeeID attributes to AD Users report

Summary: This article contains step-by-step instructions on how to add columns with user's manager cn and manager's employeeID attributes to the AD Users report.

Applies to: Cayosoft Administrator 7.x and later

Configuration

1. In the Cayosoft Administrator Console, click +New and create a new AD Users rule.

2. Specify Limit scope to this Domain or OU - select domain or OU.

3. In the Properties to display, add the expressions below. They should be comma-separated.

   For user's manager cn:

   Copy

   Manager~Manager~(ExtractNameFromDN `$_.Manager)

   For user's manager EmployeeID:

   Copy

   ManagerEmpld~Manager EmployeeID~if(-not [string]::IsNullOrWhiteSpace(`$_.Manager)){ "`$((Get-ADUser -Identity `$_.Manager -Properties employeeID).employeeID)"}

4. Save changes.

5. Run the AD Users rule to get the report with the user's manager cn and employeeID columns.

NOTE: If you're using an expression based only on the manager's employeeID, the Manager attribute must be included in either the Properties to display or System properties settings of the AD Users rule. Alternatively, using an expression that references the manager’s CN also counts as including the Manager attribute in Properties to display.