I wrote this report, which lists active advanced alerts, along with information about the host and such. Whenever I atttempt to view this through an account with a limitation applied, I get the following: Incorrect syntax near the keyword 'Where' select NODES.CAPTION, NODES.STATUSLED, NODES.PRIMARY_ROLE...

I’ve downloaded the “Outage Duration Last Month” custom report from the “Content Sharing Zone” on this web site. This report is listing the outages duration for all nodes for the last month. Actually it’s not that far away from what I need (I think J ), but I have to filter the nodes since I only need...

Can anyone help me with custom SQL reports? When I create custom reports, I usually start with one of the canned as a template and I have not been able to find/figure out the datetime (where between) stuff and get it working successfully. SELECT Convert(DateTime,Floor(Cast(DateTime as Float)),0) AS SummaryDate...

Hi there, I have a number of reports that use custom SQL to pull the value of some UnDP pollers. I've noticed a problem recently, where the results from the reports will vary widely -- from returning nothing, to returning only a handful of devices. It seems that I have to wait a few minutes for the...