Pulse Explorer - User activity by object and Server

[vbhatia]

Hi everyone,

I’m working on building a dashboard to track user activity by object type, including PAfE (reports), workspace, PowerConnect, TI processes, and chores, with filtering by server and user.

Additionally, part of this effort is to track completion time and waiting time for other users.

Which table(s) would I be able to find this data in on OpenSearch?

Vikas

[Vincent]

Hi @vbhatia ,

If you want to know which tool your users are using to connect to TM1 then this is easy, you can look at the Context field in Pulse as it is explained here:

How to Track ARC usage

Hi Nicola, Even though it is not possible from Arc to see who is using Arc. You can use Pulse to see all users who used Arc to connect to TM1. From the Pulse Live Monitor, there is a Context column showing you with which tool (Arc, TM1Web, Architect, Workspace…) the users are accessing TM1: [image] All this information is stored in the Pulse database. You can use the default H2 console to query the Session table as below: Select DISTINCT UserName From Session Where Context = 'Arc' [imag…

Then if you want to see at the object level, which view, subset or process is used then this will be only possible for customers using Arc and Slice with Pulse.

As explained in the following article, when ** pulse tracking** is set to true, each time an object is opened in Arc and Slice, Arc and Slice will send the information into Pulse.

Connecting Arc to Pulse

In order to track which object is used, the tool needs to send the information to Pulse. As we can’t tell PAfE or PAW to send this information, object usage tracking will only work if your users are only using Arc and Slice.

I hope this help,

Cheers,

Vincent

[vbhatia]

Hi Vincent,

My request is more on the Pulse Explorer end to track user movements and wait time.
Combining sections of the Live Monitor and process/chore runs with the user activity should provide what I would be looking for at the moment.

Also, as part of the enhancement request, are we able to get the user session metrics into Pulse Explorer? This would add more definition to performance tracking.

Vikas

[Vincent]

Hi @vbhatia ,

I think you are talking about the Waiting% or Running% from the Pulse User Sessions page:

@ecarmona ,

Do you think having these metrics in the Pulse Explorer dashboard is possible?

Cheers,

Vincent

[ecarmona]

Hi Vincent,

This could possible by creating an index with these stats. This could be an enhancement, as we have had some other request to provide similar calculations with other Pulse data.

Regards,

Erik

[vbhatia]

Thank you Erik. Did you need me to create the ticket for enhancement? There may be a couple other metrics that would help as your thinking through the data push into Open Search.

[ecarmona]

Hi @vbhatia,

Yes creating a ticket would be the best for us to follow up the enhancement.

Regards,

Erik