Service Portal visitors - unique user as well as session

Kari6
Tera Contributor

‎03-11-2024 11:24 AM

Hello~

I need to report on the daily total # of users who've accessed the Service Portal, as well as the total # of user sessions (Vancouver).
I keep attempting to pull this information from the sp_log, but it only is showing the user session count - I do not see a user field as an option to report on. 
Any help is appreciated. Thank you!

Labels:
0 Helpfuls
  • 657 Views
1 REPLY 1

Mohan Mallapu
Kilo Sage

‎06-20-2024 02:16 AM

Hi  @Kari6 

You are unable to see the user field in the report or in the sp_log list because there are two read ACLs (Access Control Lists) that restrict access for everyone.

Please check the following ACLs:

  1. https://instanceid.service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=95601d865330111066c1ddee...
  2. https://instanceId.service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=ae1f49465330111066c1ddee...

In these ACLs, remove the role "nobody" and add the roles "admin" or "ITIL" to enable access for your reporting purposes. Once the changes are made, you should be able to see the user field in the reporting.

Thank you.

Please accept my solution if it works for you and thumps up.


0 Helpfuls