The most recent content from our members.
Has anyone created a report for the sfp connected to their network gear? Cisco has a few commands that I can run manually but I want a report to get a full inventory. Any help is appreciated in advanced
Is there a way to use Common Table expressions in my custom SQL reports? It does not appear so, but maybe I'm missing something. I'm trying something like this, which works in SQL management studio, but not when adding the query to the report. WITH Counts ( C ) AS ( SELECT COUNT(*) C FROM ( ( ( Nodes INNER JOIN Interfaces…
Hi all, I have a question on the custom queries. Seems like the custom queries are not working normally after the IPAM upgrade. Did anyone encounter similar issue? I have attached the screenshots on the issue. The custom queries will time out and not show the results. Capture1 show that the queries are not working,…
I need to generate availability report for a bank: Now, daily availability report say for branch connectivity is easily gotten from the report writer: By filtering availability average between 8 am and 5 pm ( see history for the last 9 hours, and report is scheduled at 5 PM). What I need now is aggregated report for…
SolarWinds Orion is great at collecting information but kinda not so great at presenting that data in a cohesive way; however, it stores all of that data in SQL. This is GREAT! We can leverage that to create powerful reports. I thought I would share a SQL Query to present this data well. The attached example shows the…
Hi, I saw a post a few years back that was a report that could be run to find servers that weren't rebooted or had patches downloaded and not installed. Does anyone have an idea to do this on version 12?
I am working on some analytical reports to fetch information about the Alerts that are ticketed in the Solarwinds Help Desk using SQL Server Management Studio. However, I noticed that we don't get the severity for Orion alerts ticketed in the database form the SQL Server Management Studio, this is with regards to the…
Hello, One of my customer's DBA team had a requirement for weekly Database reports. Most of them were running with 2 nodes and have SQL App insight enabled. They would like to see the node utilization reports along with some stats from App insight. Please download and import the report and make the necessary changes, I…
It looks like you're new here. Sign in or register to get started.