Systems Management Question
K1000 reporting: custom 'uptime since last reboot' report?
06/12/2015 5202 views
Hello. I've created a report from the reporting wizard which shows a list of all specified systems and their uptime since last reboot. This works great (except for the fact that uptime's read as text and sorted thusly). Looking for some uptime guidance if anybody has any. Questions:
- Does anybody have a SQL query report for uptime reported 15 days or greater? If so how does it calculate the uptime if Kace stores this value as text?
- Is it at all possible to send automated individual e-mails to each of these listed end users as a variable through reporting or service desk?
- Doing a smart label search for uptime since last reboot by 15 days (or some combination) doesn't work at all because of Kace seeing this listed time as text. Anybody found a way to create a simple smart label this way?
Answer Chosen by the Author
Please log in to answer
To create a smart label you need to modify the SQL a little bit.
Create the smart label as normal and save it.
Browse to Home, Label Management, Smart Labels
Click the smart label you just created
Click the Edit SQL button
Delete everything after the word WHERE
Replace it with the following:
left(UPTIME, locate(',', UPTIME) -1) > 15
Save the smart label
Notifying users is more difficult. I would probably opt to use a script that targets this smart label and prompts the user to restart their computer. Depending on how aggressive you want to be you could schedule it to run daily or hourly and give the user to snooze or cancel. You could possibly have the script even restart the computer if no one is logged into the computer.
Answered 06/15/2015 by: chucksteel