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 am trying to run a report based on the output of a CMP. Anyone have any examples ? I seem to be having a hard time trying to find out how to get the data into a report. Running the latest ver. Pretty basic output would be Node Name - Location - Custom Poller Output. Any help would be appreciated. Thanks

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...

Is anyone aware of a way to integrate NetFlow data about top receivers into an Orion alert? I'm currently receiving a basic alert from Orion on any interface once traffic goes higher than 80%. Management is hoping to police the network whenever we receive said alert, but this requires me to dig into...

Hello: One solution we use it to take the URLs for the reports and post them in Microsoft SharePoint. A URL like this monster: http://<orion web srvr>/NetPerfMon/Report.asp?Report=Available+Space+on+each+Volume&Printable=TRUE Creates a nicely formatted report in SharePoint but only on demand...

This is an excellent "hack" to get a header logo on your reports. However I seem to be getting the image on the header and the footer. Is there a way to turn off the footer image? I noticed the height is limited to 150px but the width can be whatever you can fit on one page. Is this correct...

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...

I have written a report for the past 30 days and the desire is to have historic copies available on the web. What I am looking for is a way to save the report with a date or month name in the report title. All that I can do now is show the custom rteport for the last 30 days and overlay the existing...

Is there any way to change the order of the columns? I notice that you can change them by drag and drop, but the next time you open the custom property editor the defaults (order in which added) are again applied.