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 · Accepted solution]

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

[Trish Mac]

Thank you, Dr. Atul G.  I didn't realize that dot-walking was available in the query.  Much to learn.  I got the exact result I needed with your advice.  Many thanks.

Trish

[Dr Atul G- LNG]

No worries mate, we all learning from each other 

[Ankur Bawiskar]

@Trish Mac 

this is an easy requirement.

would like to know what did you configure and what's not working?

screenshots please