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

Node Summary Report with Interfaces, Volumes, Applications
I see this request a lot where people want a list of all their nodes, plus all their related objects such as interfaces/volumes/app monitors. Using normal SQL/SWQL it is a mess because every time you join another table you end up with lots of duplicated data like this: That one database server had 126 rows using normal…
Is it possible to create a report to show what Nodes in NCM use what connection profile? If so, any tips
I have inherited our Solarwinds installation and would like to cleanup the NCM Connection Profiles. Is there a way to create a report to show me what nodes are using what connection? If so, any tips or suggestions would be greatly appreciated.
IPAM Report For DHCP Scopes With 0% Used IPs
Hi All, I am looking for a report that I can run that will list all of the scopes that have 0% of the IP addresses used, meaning the DHCP scope is not being utilized. Is that possible? Thanks!
Capacity Issues Report
This report utilizes a combination of resources to show some capacity issues being experienced within your environment.
SAM Licenses by Group and Node
SAM License Usage by App and Group: SELECT c.Name AS [GROUP NAME],a.Name AS [APPLICATION NAME],CASE WHEN a.CustomApplicationType = 'ABXA' THEN '50' WHEN a.CustomApplicationType = 'ABSA' THEN '50' WHEN a.CustomApplicationType = 'ABIA' THEN '30' WHEN a.CustomApplicationType = 'ABTA' THEN '5' ELSE…
Need Help modifying a SWQL Query (date/time)
I have a report the list events for the past 24 hours. I now need that same report for just yesterday. SELECT et.Name , ToLocal(e.EventTime) as EventTime , e.EventType , e.Message , e.InstanceSiteId FROM Orion.Events AS e INNER JOIN Orion.EventTypes AS et ON et.EventType = e.EventType AND et.InstanceSiteId =…
Re-Indexed Interfaces Report
This report is designed to show Nodes with Interfaces that have been re-indexed. When an Interface is re-indexed, it is orphaned in Orion. This report allows you to easily find all of the interfaces that have been orphaned in this manner for clean up, and to show what devices may need to be assessed for new interface…
Credentials in script
Hi All i am calling a python script that uses Request to call a REST api to get status of Jira - i created Credentials in SAM - the user is an application user and NOT an OS user i user the credential variables username = ${USER} password = ${PASSWORD} but - when i TEST i get the following error Get Output Failed: Testing…
adding subtotals and total to report
New user here …still trying to learn what some of you already know. I've created a report that groups by End of Service. So I get multiple nodes within each group. Great. Now I would like to add subtotals to each group, otherwise I have to count each line item - that's too painful. I would also like to put a total number…
VERIFYING NODE REPORTS
I am interested in bouncing an idea or two off others ... here goes. 1) I've stepped into a position that requires me to create reports. I'm trying to verify the number of nodes within database - using web-based reporting. Created a report that shows: node name, last polled. Found out that a good portion of the database…