Last Boot / Report Writer

Question

I am creating a report with the last boot time of servers.  Would also like to add a column which shows that the time since the last boot.  It's a bit of redundancy here, but will make the customer happy.  One column shows a reboot of 31 Oct 08 at 08:00AM.  I'd like the next column to show how many days/hours since that last reboot.

SolarWinds says that this is an advanced SQL report that needs to be done.  I'm a network guy and not a DBA. Any guys out there with some possible help on this?

Here's what I currently have:

SELECT  TOP 10000 Nodes.IP_Address AS IP_Address,
Nodes.LastBoot AS Last_Boot

FROM
Nodes

WHERE 
(
  (Nodes.Vendor = 'Microsoft')
)

ORDER BY 1 ASC

Yann · Accepted Answer

What about:

SELECT  TOP 10000 Nodes.IP_Address AS IP_Address, Nodes.LastBoot AS Last_Boot, DATEDIFF(day, Nodes.LastBoot, getdate()) AS no_of_days

FROM Nodes

WHERE (  (Nodes.Vendor = 'Microsoft') )

ORDER BY 1 ASC

or:

SELECT  TOP 10000 Nodes.IP_Address AS IP_Address, Nodes.LastBoot AS Last_Boot, DATEDIFF(hour, Nodes.LastBoot, getdate()) AS no_of_hours

FROM Nodes

WHERE (  (Nodes.Vendor = 'Microsoft') )

ORDER BY 1 ASC

For more information about the DATEDIFF command:  doc.ddart.net/.../da-db_6.htm

HTH,

Yann