Report on Users with Managers where Manager account is disabled

[Trish Mac]

Hello,

Because the sync has stopped working properly with ServiceNow User records and AD when updates are made to AD accounts, the Manager field is incorrect on many of our User accounts.  How can I build a report that shows User Accounts with a Manager with  an inactive / locked out User account?  We're on Zurich.

Thanks,

Trish

[Dr Atul G- LNG]

Hi @Trish Mac 

Open user table in list view

and condition like below

or open this link

https://devxxxxxx.service-now.com/now/nav/ui/classic/params/target/sys_user_list.do%3Fsysparm_query%3Dmanager.active%253Dfalse%255EORmanager.locked_out%253Dtrue%26sysparm_first_row%3D1%26sysparm_view%3D

--> manager.active=false^ORmanager.locked_out=true