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…
I created a report that would graph the utilization for the last 7 days for each firewall in our organization. Issue is when the scheduled report does not run or has an issue I have to manually go into each firewall content and change the custom time frame to the dates for the last week. Can the "custom Period" be defined…
Hello all, I'm looking to create a Custom SWQL Query that pulls in interface bps data and sorts the bps column as a number rather then a string. I'm wondering if there is a magic [_ItemFor_ColumnName] like [_LinkFor_Node] or [_IconFor_Node] does. Currently using CONCAT causes the column to be sorted as a string and that's…
It looks like you're new here. Sign in or register to get started.