zenAMC

Thanks John its working, But somehow its not taking all the down event against a device. Eg. there is a device for which I can see 3 down/up event in web console events tab for last month but SQL output shows only first two down/up even pair. I am not sure why this behavior, please suggest. 

Hi, I am getting error on line number 18 where its saying invalid column name node, custom property I have already removed

Yes I tried yours and its working, but failing to validate the out put of query to actual events on the nodes. I am finding that there is different in actual down event on the device when I see it from the console. Still validating 

Before using i have removed any custom property, actually I am trying to convert this script as SQL one. As that the requirement.

It didnt work, same error.

The one which sten has posted.

Thanks John, I am using the above mentioned SWQL script to generate report. But its giving me an error Invalid column name 'Nodes'. at StartTime.Nodes.NodeID line in the script. Am I missing anything here?

Hi, I am trying to use above sql query but its giving me an error as Invalid column name 'Nodes'. at StartTime.Nodes.NodeID Please suggest