Ability to interpret Hashed IDs on User Experience Analytics Dashboard or Other Table

[Bridgette Weiri]

Hello, 

I am reaching out to see if anyone has a solution for a report requested from my team. We need a report showing a specific manager's direct reports with their associated ServiceNow logins and durations of the time logged in. The closest solution I've found was the User Experience Dashboard, but the users names are not listed, only their hashed IDs. I was able to pull the data into Excel and use VLOOKUP to match the user names with hashed IDs. Do you have any alternative ways I can do this without having to pull into Excel? Is the User Experience Dashboard data recorded in a table where I can create my own report from? 

Thanks for your help, 

Bridgette Weirich

[Bill Claman]

we were just told to do something very similar for CSM. The SN team that was helping create our initial install & setup suggested we do that as well by running a filter on the sys_user table list with the copied hashed IDs. We have a support ticket raised with SN about it but I suspect the answer will be the same.

[Nirnay]

What field on the sys_user table do you search the hashID against ?

[Bill Claman]

Hashed User ID    <== BUT when using the gear to add the column, it will show up out of alpha order. On ours it shows after HRBP.  Or you can just use the funnel filter and start typing it

[Nirnay]

Optionally, can we add more fields to the user session list ? Like the name/email of the user ? and can we filter it to specific set of users ?