Is there a way to write a report to count the number of alerts captured when using the log analyzer. I am capturing and alerting on the alert. However I would like to create a simple report to show the count of how many times the alert has been triggered for a set week and/or month.
We monitor network infrastructure to include WAN circuits. We have a link on our interface details pages that allows to halt alerting or to resume alerting for that interface. We have some automatic processes that will pause an interface for certain issues. In many cases we require user interaction to resume the alerting…
I have a report that works but have now been requested to exclude certain nodes from it. The easiest approach that I can see, is that all the nodes bar one have DS0 in their name so my WHERE statement looks like: WHERE n.Interfaces.PhysicalInterface = 'Y' and ClientPrefix = '123ABC' AND NodeCaption LIKE '%DS0%' But I now…
How to get "Legacy Report Migration Tool" to migrate reports from deprecated Report Writer to Web based.
We are able to have either the nodes, interfaces or volumes details page URL appear in a SQL web based report, but is there a way to have more than one? For example, we would like to be have the node details page URL be selectable by clicking the node name and have a second column showing the interface name which can be…
When looking at Interface Traffic History in the report builder or the Orion.NPM.InterfaceTraffic table in SWQL studio, there are min, max, avg values for bps and packets. But for PercentUtil there is just one value...no min, max, or avg. What does this one PercentUtil value represent for each DateTime? And where can you…
We would like to add to our software inventory report on when the last time the software was launched on the node. This would be useful to discover if software is being used or not.
I'm trying to subtract the previous value from the current value to get a delta of change but I'm struggling on figuring out how to do this. I tried to start with a query to get the top two rows by DateTime DESC so I'd get both rows I'm interested in. Now I'm trying to figure out how to get access to the second row value…
Hello, I have created a perfstack graph about interface bandwidth and availability. Also I could put it into a report and set it to be sent each day in email to various recipients. My problem is that the report defaults itself to 7 days and that is how it is being sent in email, while I would like it to show the status of…
Would like to create a report and widget based on Cisco software version compile date. It would need to pull the compiled date from the "show version" command and then filter by years old from that date and add a letter grading between A-F based on the date.
It looks like you're new here. Sign in or register to get started.