I want to know when alarms were suspended and for how long.
The old legacy uptime report shows when alarms were suspended. I think you can also see suspensions under configuration changes (agent logs) but I'm not sure if it tells you how long. Legacy uptime report would be your best bet.
select * from vuptimehistory
This will show you the history
You'll just need to work out which "type" represents the suspended time
I needed this today and found the Types documented in the help file.
1 – Agent on but cannot connect to Kaseya Server
2 – Agent on and connected to Kaseya Server
3 – Agent off normally
4 – Abnormal agent termination
5 – Agent alarms suspended (do not count supended time when computing total uptime (function getMachUptime)
6 – Suspend ended
Came across this while trying to find the same thing, I tried doing a sql query but the information returned is difficult to read from.
Here is a query I used for example:
WHERE type = '5' or type = '6'
Trying to see when monitor > suspend alarms - starts and ends. Anyone have a better way to do this? Below is a sample of data I get back (names changed),
Machine_GroupID machName eventTime duration type loginName
server1 group1 35:53.5 83 6 *System*
server1 group1 10:36.0 4 6 me
server1 group1 20:44.4 398 5 *System*
server1 group1 20:11.3 721 5 me