Trouble trying to create a Report for Servers with an Uptime over 100 days
I am trying to create a report for any of our servers with an uptime over 100 days. I have looked at many of the similar questions I have seen posted here but I have been unable to make any of them work for me. I am looking for help writing the report that displays the server name OS then the current uptime if the server is up over 100 days. There are multiple items to use for the report but I can't make any of them work. Has anyone built a report like this? I have tried using uptime, uptime in hours, last reboot, and
Thanks!
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
SELECT NAME, SYSTEM_DESCRIPTION, IP, SUBSTRING_INDEX(UPTIME, ',', 1) as UPTIME_DAYS FROM MACHINE MACHINE WHERE SUBSTRING_INDEX(UPTIME,',',1) >100 ORDER BY UPTIME_DAYS
SELECT NAME, SYSTEM_DESCRIPTION, IP, SUBSTRING_INDEX(UPTIME, ',', 1) as UPTIME_DAYS FROM MACHINE MACHINE WHERE SUBSTRING_INDEX(UPTIME,',',1) >100 ORDER BY UPTIME_DAYS
Please log in to answer
Posted by:
SMal.tmcc
9 years ago
flip1001 has one for seven days in this answer you should be able to modify to do what you want.
http://www.itninja.com/blog/view/how-to-use-custom-inventory-fields-to-check-last-reboot-and-smart-label-to-report-the-machines-without-reboot-over-10-days
http://www.itninja.com/blog/view/how-to-use-custom-inventory-fields-to-check-last-reboot-and-smart-label-to-report-the-machines-without-reboot-over-10-days
Posted by:
mkiessling
9 years ago
I was able to get our SQL Admin for a minute and she did a great job and made this very easy....
SELECT NAME, SYSTEM_DESCRIPTION, IP, SUBSTRING_INDEX(UPTIME, ',', 1) as UPTIME_DAYS FROM MACHINE MACHINE WHERE SUBSTRING_INDEX(UPTIME,',',1) >100 ORDER BY UPTIME_DAYS
The report is fairly clean and does what I need. I have it scheduled to run every Monday Morning and deliver my team a fresh copy. Sorry I answered my own question but it took my account forever to post the question once I signed up.
SELECT NAME, SYSTEM_DESCRIPTION, IP, SUBSTRING_INDEX(UPTIME, ',', 1) as UPTIME_DAYS FROM MACHINE MACHINE WHERE SUBSTRING_INDEX(UPTIME,',',1) >100 ORDER BY UPTIME_DAYS
The report is fairly clean and does what I need. I have it scheduled to run every Monday Morning and deliver my team a fresh copy. Sorry I answered my own question but it took my account forever to post the question once I signed up.