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

Report Lab

Recent Discussions

Interface Status Icon for Interface Report
I'm trying to make a report that shows the current status of various interfaces, but I'm having a hard time finding the StatusIcon/StatusLED column on interfaces like I can on nodes. Does anyone know how to show the status icon in reports for interfaces?
Query view date created template SAM
Hi, I write one query for view the date created templated in SAM SET NOCOUNT OFF SET ROWCOUNT 0 DECLARE @StartDate DateTime DECLARE @EndDate DateTime DECLARE @Rango DateTime DECLARE @ResultVar real SET @StartDate = DATEADD(DD,-30,DATEADD(DD,DATEDIFF(DD,0,GETDATE()),0)) SET @EndDate =…
Create a report
Can the added alerts be made into reports, and each type of alarms can be made into a separate report?
95:5 Percentil Report Orion
Hello There! I'm searching for an 95:5 Percentil Report for Orion for Version 2020.2.65100.50179. Has anybody an idea, how I can do it? The older sql reports doesn't get an answer and the prefabricated reports are using the average value. Thank you for your time! Best regards
Downtime reports (unplanned)
I'm trying to recreate our Unplanned Downtime Report. It was originally created in the Report Writer tool, but it's not compatible with the current Web Reports on the Orion Platform 2020.2.6. This is what I have in the legacy tool: SELECT StartTime.EventTime, (SELECT TOP 1 EventTime FROM Events AS Endtime WHERE…
Node down report - with a specified time and date range
Node down report - with a specified time and date range Need some advice if possible with regard to creating a report for nodes that have been down over a specified time and date range i.e what nodes were down on 01/03/22 @07:00 to 31/03/22 @19:00thanks in advance
Importing .csv to get information on 1000 nodes.
I have been tasked with getting information on about 1000 nodes, I need to get the following information: - Is it in solarwinds - Is it up -What is the polling method. Is there a way I can import a list of nodes and get it to return the above information? Thank you!
Muted Nodes Widget
I use the below SWQL query to return all muted nodes in the environment. Includes the username of the person that muted the node. SELECT n.Caption AS [Node] ,n.DetailsURL AS [_LinkFor_Node] ,'/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node] ,tostring(tolocal(SuppressFrom)) as [From] ,case when…
SQL Report classify per users by Groups
Hi, I found this query on Thwack but there is a problem I need to classify per group that group have a customer name with a user =========SQL========= SELECT DISTINCT ahv.Name 'Alert Name' ,ahv.RelatedNodeCaption 'Parent Device' ,ahv.EntityCaption 'Alert Object' ,ISNULL(lastOne.Qty,0) 'Last 1 Day' ,ISNULL(lastSeven.Qty,0)…
Looking for report that shows Orion Servers Elements, CPU & Memory usage.
Would like to graph this and possible plot on dashboard. I have one for CPU/Memory and have non graph for Elements, but looking to have them on same graph. Save me some time if someone already has this. Zak