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 AD Users report.

Applies to: 7.x and later

ID: KB20210205-1

---

Configuration:

1. In Admin 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 Properties to display add the expressions below. They should be comma-separated.
   1. For user's manager cn:

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

   2. For user's manager EmployeeID:

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

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