How to generate a report for users who logged in ServiceNow Backend ?

[Balakrishna_ABK]

I can see ServiceNow User Experience Analytics shows data, but it is not useful as it showing Hash user id instead of actual ServiceNow user id 

We need a report for list of users who logged in ServiceNow Backend for last 2 months

[Balakrishna_ABK]

Hi Ankur,

I am getting required info from sys_user_login_history table 

I have added itil condition for roles to segregate users.

The only thing is I am unable to create report on this table as following acl is blocking which is Readonly 

[Ankur Bawiskar]

@Balakrishna_ABK 

thanks for confirming the table I shared helped you.

in that report_view ACL add role itil if you want

but this is a sensitive system table, why your agents want to see that?

I won't recommended that.

that table should be only for admin role

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

[Balakrishna_ABK]

Hi @Ankur Bawiskar ,

It is ready only so I have created new acl and added ITIL role , even it is not working for admin

[Ankur Bawiskar]

@Balakrishna_ABK 

you are not able to select that table during report creation?

that's your issue?

[Balakrishna_ABK]

yes