Reboot Report Help

shawnwaldman

I was wondering if someone can help me with a SQL report. I'm trying to write a report that shows Pc's that Didn't reboot the previous night. I can get the report to show what PC's that didn't reboot using a specific date, I'd like to use the expression 'current date' so I can have the report automatically email our help desk folks.

 Shawn Waldman

lasher

You could try something like this in an Advanced SQL report.

SELECT  Nodes.Caption AS NodeName, Nodes.LastBoot AS Last_Boot
FROM
Nodes
WHERE
CONVERT(VARCHAR(10),Nodes.LastBoot,101) <> CONVERT(VARCHAR(10),getdate(),101)

 

That should be a good starting point.