Include downtime in current node down report

FormerMember

I have a report that I have included on our main summary page that list the current down devices and other information, It looks like:

Current Down Devices and Status   
 
  Device       Last Change       Users       Notes 
  APBeans   11-Jan-08 15:33  Accounting  Job 154993 
  SWMickey 12-Mar-08 13:21  Facilites   161118 
  SWGoofy   12-Mar-08 10:21  Facilites   161079 
  SWBeta     13-Mar-08 07:26  Facilites   
  SWAlfa       27-Feb-08 12:56  Maint       Job 159695 

What I want to do is also add the amount of downtime. So if a device has been down since 11-Jan-08 15:33 it work show

  Device       Last Change       Duration               Users       Notes 
  APBeans   11-Jan-08 15:33   1462 hr: 55 min   Accounting  Job 154993 

Can someone help in the SQL logic?

Thanks

FormerMember

Solved my own question.

 The whole query for the report now includes the downtime duration:

SELECT
N.StatusLED as Status,N.Caption AS Device,MAX(E.EventTime) AS DownTime,
Cast(DateDiff(day,MAX(E.EventTime),getdate()) as varchar) + ' Day(s) ' + convert(char(8),dateadd(second,DateDiff(second,MAX(E.EventTime),getdate()),0),14) as Duration,
N.Department AS Users,N.Status_Info
FROM
Nodes N
INNER JOIN Events E ON E.NetworkNode = N.NodeID
where N.status = 2 and eventtype = 1
GROUP BY
N.StatusLED,
N.Caption,
N.Department,
N.Status_Info