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!

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
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
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
Answered 09/30/2014 by: SMal.tmcc
Red Belt

Please log in to comment
0
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.
Answered 09/30/2014 by: mkiessling
Senior White Belt

Please log in to comment
Answer this question or Comment on this question for clarity