Create Servicenow report with list of users who has itil role but not a member of any groupCreate Se

[Uttam Sai]

Create Servicenow report with list of users who has itil role but not a member of any group . I am looking for filter conditions . Please confirm if this can be done without background script

[Dr Atul G- LNG]

https://www.servicenow.com/community/itsm-forum/report-on-users-that-have-the-itil-role-but-are-not-...

[Tanushree Maiti]

Hi @Uttam Sai 

1. 

Write a script include with your logic . Call that script include from sys_user_grmember table report.

Check this :

https://www.servicenow.com/community/itsm-forum/want-to-know-how-can-i-know-the-users-who-is-not-a-m...

[Ankur Bawiskar]

@Uttam Sai 

not possible without scripted filter condition in report

check below link

Find users who has roles but not in any groups

Approach 

-> Create client callable classless script include and call it from Report filter condition

-> create Report -> sys_user

Condition

SysID [IS ONE OF] javascript: getMyUsers()

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Uttam Sai 

Thank you for marking my response as helpful.

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏