Jump to content
Sign in to follow this  
automationGuy

Extracting Idle Time

Recommended Posts

Anyone know if an agent's idle time is stored in the database? If so, where?

Looking to see if I could do a bulk lookup against which agents have been idle for X amount of time.

Thanks

Share this post


Link to post
Share on other sites

Try this for a start:
I filtered out the servers , and all Idletime over 5 minutes.
LastContact  too make sure the device is online or has been turned off for a while.

SELECT Name ,
LastContact ,
(IF(IdleTime > 0, (IdleTime/60), IdleTime)) `IdleTimeInMinutes` 
FROM Computers
Where IdleTime/60 > 5 and computers.OS not like '%server%'

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...