Making report for when a user access the employee center

[Rain Vaine]

Hello experts,

Did anyone of you tried to implement a solution on reporting when a user login and accessed the employee center?

I understand that there is information on transaction logs specifically on the url column when a user tried to access the employee center but building a query or report on transaction logs is not recommended by ServiceNow due to performance impact of querying the transaction log.

Is there other possible place to check for logs when a user tried to access the employee center?
For login i believe that the sys_user_login_history table cna be utilize, but for determining if a user access the employee center, I am not sure what table to use. Does anyone of you have any possible idea?

P.S. We want to get a report on user login and access to employee center if possible without compromising the performance of the instance.
Regards,
Vaine

[Ankur Bawiskar]

@Rain Vaine 

you can explore User experience analytics but it won't give you “per‑user login + portal access” details

check below

User Experience Analytics for Service Portal 

OR

You can use "sp_log", "sys_user_login_history" and "sysevent" but it will lead to performance issue

OR

Use custom table to store these details and then have report on that custom table

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

[Ankur Bawiskar]

@Rain Vaine 

I believe you will have to take a custom table approach here.

[Ankur Bawiskar]

@Rain Vaine 

I could see the thread is closed by marking response as correct

But I believe you will require a custom table approach to handle this as you can't use User experience analytics won't help here