Track workspace user data

[Bill Claman]

I need some help identifying what table records workspace activity.  Specifically, we have a requirement to create a dashboard showing which users within certain groups have used the CSM/FSM workspace recently. From my searches looking for similar posts, I know that some information will show up in:  ua_app_usage   table.  However, that just shows some generic info per month and does not seem to show if anyone is actually doing anything in the workspace. I also checked the sp_log table just in case something was recorded there.

I do know that there is an OOTB dashboard showing some basics of usage but they are looking for who accessed, etc.

thanks

[Gonzalo_S]

Hey Bill,

You can check "User Experience Analytics" application.

"It provides dashboard views for monitoring usage analytics of your Next Experience web applications as well as Virtual Agent, ServiceNow mobile, and Service Portal applications".

I hope that helps!

Gonzalo.

[Bill Claman]

thanks but unfortunately they already use that however it does not let you see the user's name which is the main thing they want. I found out from SN that the data for UEA is in hidden tables and there is no way to customize UEA to add user name... you only get the hash ID and then have to export the list so you can use Excel to vlookup the name to hash ID.

We have been given a workaround by SN which appear at first glance to be only for portal data. They are suggesting we use information from these links to accomplish what we want:  https://docs.servicenow.com/bundle/vancouver-customer-service-management/page/product/customer-servi...     

https://docs.servicenow.com/bundle/vancouver-customer-service-management/page/product/customer-servi...