topic How to group multiple machines and user session time into a readable chart in Getting Data In

How to group multiple machines and user session time into a readable chart

earonwilliams12 — Fri, 13 Mar 2020 13:52:41 GMT

Hi all!

I am currently working on a dashboard metrics project that involves me attempting to create a dashboard panel that outputs the total number of hours / time spent on a set number of machines. In short, I need to:

Group together a list of machines
Calculate the total number of hours users are spending on said machine.

Here is what I am currently able to do:

I have created a search function that properly calculates the usage of each machine via log on/log offs. The information is broken down via the machine name, user, time logged in, time logged out, and total duration of each user's session in a single machine.

I hit a mental block on how to convert the total duration / time of each session and machine into a single readable format.

Thank you all in advance!

Re: How to group multiple machines and user session time into a readable chart

jpalacian — Fri, 13 Mar 2020 15:08:19 GMT

Hi!

use tostring(X, "duration") in your own query:

| makeresults limit=1 | eval foo=303030 | eval duration=tostring(foo,"duration")

Re: How to group multiple machines and user session time into a readable chart

manjunathmeti — Fri, 13 Mar 2020 16:22:53 GMT

Can you provide some samples of total duration / time and expected output?