Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Report Lab

Recent Discussions

Report for triggered alerts past 1 day for 2 specified alerts only
Hi All need help setting up a report for triggered alerts history for past 1 day but only on for the two alerts below Thanks in advance
Can you schedule a report that is emailed in excel format?
Can you schedule a report to be emailed in the excel format or do you have to manually export the report once it has run? thanks
Universal Device Poller History Report
We had set up a graphical report that showed the temperature of several probes we had throughout our environment. The report displayed the past 14 days. The user then requested the raw data so they could export it out to Excel. The graphical web based reports don't support the export function so we wrote up a simple SWQL…
Looking to create a report that shows Alerts that have not been acknowledged
My goal is to have a scheduled report that shows only Alerts that have not been acknowledged. The below SWQL will show me the Acknowledged Alerts but I am looking for the opposite. SELECT o.AlertConfigurations.Name AS [ALERT NAME] ,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS…
Node Availability report excluding maintenance.
Hi, I am finding something which gives me an option to exclude the time duration for pulling availability report of node. Example: I want an availability report on node (last 30 days) but having an option which excludes maintenance window (1 AM to 3 AM) for all 30 days. Because current availability report shows inaccurate…
Query to pull all config changes over the past day, past week, etc.
Looking to build a report something like the below (device_type is a custom property). What tables can help get me started? I found this out of the box widget, i am curious to know where the data is being pulled from exactly:
Report: All Nodes Sorted By Type
What is the best way to create a report with all nodes, sorted by node type? I don't just want a count. I want each device with the Hostname and IP Address.
Need monthly utilization report
DECLARE @StartDate DateTime DECLARE @EndDate DateTime -- dynamic time constraints SET @StartDate = CAST (DATEADD(day, DATEDIFF(day,0,GETDATE())-1, 0) as datetime) SET @EndDate = CAST (DATEADD(millisecond, -1, DATEADD(day, DATEDIFF(day,0,GETDATE()), 0)) as datetime) -- SQL query SELECT Nodes.Caption AS NodeName,…
Utilization report sql qeury
DECLARE @StartDate DateTime DECLARE @EndDate DateTime -- dynamic time constraints SET @StartDate = CAST (DATEADD(day, DATEDIFF(day,0,GETDATE())-1, 0) as datetime) SET @EndDate = CAST (DATEADD(millisecond, -1, DATEADD(day, DATEDIFF(day,0,GETDATE()), 0)) as datetime) -- SQL query SELECT Nodes.Caption AS NodeName,…
Simple Report Help
Hi, I'm trying to create a very simple report, So I'm embarrassed to ask (As I have very little SQL knowledge) if anyone can help with me with this simple query please. Looking at the Report tool I can't seem to find anything that does not require SQL/SWQL to get the information. I would like to put the following into a…