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.
You could try something like this in an Advanced SQL report.
SELECT Nodes.Caption AS NodeName, Nodes.LastBoot AS Last_Boot
CONVERT(VARCHAR(10),Nodes.LastBoot,101) <> CONVERT(VARCHAR(10),getdate(),101)
That should be a good starting point.