Need to Create report users having Admin role.

[RaviKumarV]

Hi All,

I need to create a report for those users who's having ITIL and Business stake holder role and they didn't logged in for at least 45 days. Any suggestion would be helpful.

Thank you in advance.👍

[Tsura Andreeva · Accepted solution]

take a look at sys_user_has_role

[RaviKumarV]

Thank you Andreeva. it is working. 👍 i have tried from my end its working as well. below is the screenshot.

[Tsura Andreeva]

Thank you for the feedback, glad I can help, just a suggestion, you might want to use "Or" statement for the roles because otherwise you might be picking up only users who have the two not one or the other.

You might say stakeholders dont have ITIL and ITIL users do not have the need for stakeholder but you never know what assignment group might be giving them the two at the same time 🙂