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

[Ankur Bawiskar · Accepted solution]

@Balakrishna_ABK 

check this

Finding the users logged in to the instance 

this table holds history "sys_user_login_history"

💡 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 ,

Thanks for the quick reply but how to differentiate user who made login in backend (native UI) and frontend (portal) ?

[Sarthak Kashyap]

Hi @Balakrishna_ABK ,

To differentiate between native UI and portal check below links

https://www.servicenow.com/community/servicenow-ai-platform-forum/detect-user-working-in-ui-or-servi...

https://www.servicenow.com/community/developer-forum/detect-if-user-has-ever-logging-into-the-native...

https://www.servicenow.com/community/developer-forum/how-to-detect-user-working-on-ui-or-portal/m-p/...

Please mark my answer correct and helpful if this works for you

Thanks and Regards,

Sarthak

[Ankur Bawiskar]

@Balakrishna_ABK 

this article from Maik should help you but remember you need to add some customization to get that

It's not available OOTB

Reporting on which users logged in where and when 

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