The most recent content from our members.
The current resource for generating a report in a view only allows you to select reports that have been created using the Report Writer on the server, it would be really neat if you could also choose from reports that have been generated using the Web Console. This would allow you to include reports in the rotating NOC…
Hi, I have the following issue with NPM 10.7 and VRF awareness. Having this new feature is great, we have been asking for it for a while. However the resources to display the information cannot be changed / customized. It is based on the ROUTE DISTINGUISHER and should really allow you to sort the info based on VRF NAME or…
Hey everyone, I'm a Solarwinds and Database newbie so please bear with me. My team has been using the Report Writer custom SQL query to create a report showing devices down dependent on certain custom fields conditions. Part of this report shows notes from our NOC on the current status of that node. We put all the notes…
Hi All, I have a sql report in report writer that I would like to GROUP devices by a specific custom property, however, it does not seem to be working for me. Here is my sql. select T1.NodeId, Caption, Vendor, IP_Address, MachineType, t2.Model, servicetag, XX_Serial_Number, XX_Location, XX_Rack from Nodes t1 inner join…
Hello, I've recently created a report that would show our branches that experienced high utilization. This report is put into a 24 hour format( so essentially i get to see the max utilization for every hour of every day) and is set to the last 30 days. I do have filters that are specify which nodes and whether their…
I'm trying to create a report for our asset manager that reports various pieces of information. However I seem to be having trouble retrieving the chassis-id as set via SNMP on Cisco switches (snmp-server chassis-id 12345abc) Am I just being blind and its not listed on the drop downs (even though contact and location are)…
I am trying to add some custom properties on our Historical - IP SLA Report. So what I did is I created 2 reports then get the SQL code. Report A - it will generate the Average of MOS and Jitter for the Last 30 days. Report B - it will generate the current statistics of MOS and Jitter with its custom properties (ex.…
Is there a way I can get a report that shows all 30 days of last month, and shows me the peak and average bandwidth for each day? I'm not good with SQL so I have no clue how to pull that information directly from the database. I found this thread (How to create a custom report for Historical Traffic Reports for Average and…
Hi, We need a report that would help us identify high utilization for interface, cpu and memory. The objective is to identify those instances where the high utilization is sustained for 30 minutes or more. And then count the occurrence of this instance. Interfaceno. of occurrences above 75% usage sustained in 30minno. of…
We have a customer requesting the following two reports (for both Monthly and Weekly time periods): Top 20 Location Report ------------------------------- Report contains a table with the following columns - Location Node ID Average transmit (bps) Average transmit (% util) Average receive (bps) Average receive (% util)…
It looks like you're new here. Sign in or register to get started.