Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Device Uptime

I'm trying to write a custom report listing all my devices and how long they have been up. I know Orion polls for last boot but I'd like to equat that to uptime.

Any ideas on how to write the report?

Find more posts tagged with

Accepted answers

All comments

DonYonce

The following query will show the Up Time in days for each Node.

SELECT NodeID, VendorIcon, Caption,MachineType,
DateDiff(Day,Nodes.LastBoot,GetDate()) AS DaysUp
FROM Nodes
ORDER BY 5 DESC

Run "Report Writer"
Select "File->New Report"
Select "Advanced SQL" as the report type.
Then paste the previous SQL query into the SQL tab.

Here's the same thing, but showing the number of Hours up

SELECT NodeID, VendorIcon, Caption,MachineType,
DateDiff(hour,Nodes.LastBoot,GetDate()) AS HoursUp
FROM Nodes
ORDER BY 5 DESC

DonYonce

You could also implement this as a Resource in the Web Site with the following :




<table width="100%" border="0" cellpadding="8" cellspacing="0">
<tr class="ViewHeader">
<td align="left" nowrap ><B>Up Time</b><td>
<% If Node Is Nothing Then %>
<td><font color="red" sizez="2"><b>A Network Node was not Selected</b></font></td>
<% Else %>
<td><%=Node.GetProperty("LastBoot as UpTime")%></td>
<% End If %>
</tr>
</table>
<br>

Place the previous code in a file called "00-NodeUpTime.Resource" in your C:/InetPub/SolarWinds/NetPerfMon/Resources/2-1-NodeDetails directory. Then add this new "Up Time" resource to a Node Details view. It will display the device Up Time like this :

Up Time 3 days, 17 hours, 21 minutes, 26 seconds

BryanBecker

Don..thanks for the input...both work great. The report writer I'm getting the follwoing when I try to run the report via the web site :

Line 1: Incorrect syntax near 'SELECT'.

Here is how I have the SQL set up :

SELECT Caption, VendorIcon, MachineType, IOSVersion,
DateDiff(Day,Nodes.LastBoot,GetDate()) AS DaysUp
FROM Nodes
ORDER BY 5 DESC

It previews just fine within report writer...so I'm not sure what the issue is. Thanks.

BryanBecker

Disregard my last post. I saw your other response in the Advanced SQL post. I'll wait to V7.1

Thanks again!

StephenT

Anyone know of the new features in the forthcoming V7.1? I notice Don mentioned in the SQL post that it is due to be released early March...

** gets down on knees to pray for Custom MIBs

**

Cheers

simon

Don, is there a way to run this info as a monthly report showing it as an availability for the previous month? It is good to be able to see the device uptime, but I would also like to see this as a percentage availability expression for a month. Can it be done?
This is the old issue of reachability versus availability. SolarWinds shows reachability very well, but I do not know how to show the actual availability.

Thanks

Network_Guru

Simon,

These availability reports are included in Report Writer V7.
I have created %availablity reports based on last month, this month, Year to date, last 12 months, etc.

Here's a report showing the average availability of each node last month:

SELECT CONVERT(datetime,
LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)),
101) AS Month,
Nodes.SysName AS System_Name,
Nodes.IP_Address AS IP_Address,
Nodes.VendorIcon AS VendorIcon,
AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE
( DateTime BETWEEN 37651 AND 37677 )

GROUP BY CONVERT(datetime, LTRIM(MONTH(DateTime)) + '/01/' + LTRIM(YEAR(DateTime)), 101),
Nodes.SysName, Nodes.IP_Address, Nodes.VendorIcon

ORDER BY Month ASC

Here is a report showing the average availability of all nodes combined for the last month(excluding Windows nodes:

SELECT AVG(ResponseTime.Availability) AS AVERAGE_of_Availability

FROM
Nodes INNER JOIN ResponseTime ON (Nodes.NodeID = ResponseTime.NodeID)

WHERE
( DateTime BETWEEN 38016 AND 38043 )
AND
(
(Nodes.Vendor <> 'Windows')
)

(Note, this most likely won't display on the web site - you need to use the pre-built reports, or wait for V7.1).

-=Cheers=-
NG

DonYonce

Simon,
I'm not exactly sure if you are asking for a Report or a Web Resource.

There is a resource called "81-AvailabilityStats.Resource" that can display the Availability as a percentage for "Today","Yesterday","Last 7 Days", etc. You could add "LAst Month" to it.

There are also a few example Availability reports in the Report Writer.

McGregorKLB

This method is checking if the SNMP service is running and since when.

We have frequent errors on the SNMP-Service in Windows, so when you start the service after an error, NPM sees it as the node is rebooted, so the uptime is no longer correct. it shows 0 hours, and the server is up for 66days.

There must be a counter in windows that counts uptime, in ticks, seconds, or another value, if you could use that reference for uptime instead of monitoring the SNMP-service it self would be great.

It's strange that there is no correct answer on this forum although this is pretty important information of your servers.

If anyone have suggestions, I would like to hear it!
Thanks.

justty

You are correct, Orion queries SNMP start values to determine uptime, which is faulty.

Do a search for a utility called UPTIME. You can put it in a batch file and write the resuluts to a test file. Or you could invest more time to dump the results to SQL.

This may provide you a more accure UPTIME result than ORION.

We marked this UPTIME issue as a flaw with ORION, but got back, that it is "function properly because we are pulling data from SNMP".

McGregorKLB

Hi Jussty,

Thank you for your answer, I will test this, because uptime is important for us and strangely on a few servers SNMP keeps crashing.

The most servers we are running are Dell servers, so I searched Dell in combination whit SNMP, and found someone that told me that "Dell Open Manage" is cousin this problem.. but we have a few HP servers as well, and thought that I had an error before whit a HP server.. So thats strange.

So my thought on this is, that Orion is using SNMP at the same time as a different service, and that way this will generate an error. If the SNMP-service stays running, the uptime will be accurate enough. So knowing this my next question is..
Is there a way to control the exact polling time. So you can spread the load of the SNMP serice. Just a thought.. but hopefully it makes sense.. Thanks!