Need help in creating a report to show router availability, need to include average availability, system up time, time device went offline (if applicable) and time device came back online - i have managed to get as far as - Average availability, Status description & system up time (days - which is displaying incorrect…
We have a couple of thousand reports that are going out to whoever wanted them when they were created. I am looking for a way to start auditing the Reports that have been created for about a decade now. Does anyone know a way to get a report that shows the Report name as-well-as the Action, Schedule and Recipient(s) it is…
Need to create new report to display all monitored nodes (Previous report is corrupt) for the life of me i cannot remember how to get it to report correctly all i am getting is a blank report when i am running the new created report thanks in advance
I've been trying to create a report to identify nodes in our environment which have internet access, used "Netflow By Conversation History" and few other Netflow reports but I'm unable to get result. is there a KB or has any one successfully done this by any chance?
OK so we have a requirement for "Last Week" instead of being Sunday to Saturday, the customers "Week" is Monday to Sunday. So I am doing the query for data via a a SQL Query. Here is my query (This is a MSSQL Query)... DECLARE @StartTime DATETIME DECLARE @EndTime DATETIME DECLARE @PMStartTime DATETIME DECLARE @PMEndTime…
We have a report that runs on the 1st of every month that shows the graph for Min/Max/Average bps over the last 30 days for each of our branch office routers. We recently swapped all that equipment out and we'd like to change this report to be a bit more "dynamic" and flexible to changes without having to go through and…
I am trying to create a report that would have the node name, port number, hostname of the device and the device ip address. There is a Connected MAC and IP Addresses report available, but I can't figure out how to add or search just by the hostnames that begin with SEP Any help would be appreciated.
I need a Report that shows which Alerts use a particular Custom Field for Nodes. I've gone over the canned Reports and come up empty. Can anyone help me put together a SQL or SWQL query that will hunt out which Alerts use a certain Custom Field?
I am trying to create few site wise proportional widget. but unable to create a filter so that i can get only the nodes from a particuilar site Using the following query, but this gives all nodes details I need only nodes from a specific site, is there any way i can add a filter to give me the node status for any node…
Hi, Im trying to display all the node status in Moderndashboard and i need to exclude the printers from the list, usually all the printers contains PRN in the name , mostly in between Is there any way we can exclude any nodes which contains PRN in the Name select count(1) as countnodes from orion.nodes where status <>1…
It looks like you're new here. Sign in or register to get started.