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

Need simple SWQL query help!
Would like to use swql to return the following: NodeID, NodeName, followed by all custom properties that are not NULL or BLANK. Has anyone done this with SWQL? Reason for SWQL is so that I can create a custom SWQL resource with a search bar as I need to be able to query large sets of nodes with similar naming conventions.…
Server+Usage.xml
Web-based Server Usage Report Based almost entirely on the Server Usage - Avg, Total, Peak - Mem and CPU Load ReportWriter Report by km96svt
Combining Data from 2 Tables
I want to combine data from 2 reports into the same query result displayed in a Report Table. One data set is from a UPS temperature sensor and is collected using SNMP within a SAM Application Monitor. I am able to get the data I want using: SELECT TOP 1000 hivs.ObservationTimestamp AS Timestamp, hivs.HardwareItemID AS…
Availability Query is Dropping data
I have this SQL query that gives me the average availability of the previous month for the firewalls at my sites: DECLARE @startOfCurrentMonth DATETIME SET @startOfCurrentMonth = DATEADD(month, DATEDIFF(month, 0, CURRENT_TIMESTAMP), 0) SELECT sub.SummaryMonth AS Month_Of, AVG (sub.AVERAGE_of_Availability) as Total_Average…
Create a report for specific computers from a specific group
Hello Im having a hard time applying proper filters to achieve what I need. Im trying to create a report of 20 machines inside of one computer group with percent of updates installed. How can I achieve this? Thanks
Report on Custom Properties
Having trouble with SWQL for cus prop entries. Node.CustomProperties.group_membership = 'AVAYA' this fails - Query is not valid any advice?
Comment Field in Mute Alerts Report
Hi All ! I am using mute alert report that is written in SWQL. (Pasting the code below). My requirement is that we should have a comment field (lets say i can request users to write that in Notes field why did they put it in mute alerts). And then the notes field is also displayed as additional column. Currently the code…
report to show users that have never logged in
I need to show a report listing all user accounts that have never logged in. How do I format the Where statement to do that? I think those are the accounts that have a LastLogin value of "1/1/1900", right?
How do I add tab names to an Excel export of a multi-section report?
I've finally gotten my storage capacity report doing what I want it to and have broken it into 3 sections in a scheduled report that sends an email with a link, a PDF and an Excel workbook. The link and the PDF in the email both look and work great. Unfortunately when I get the Excel workbook it has a tab for each section…
we want youtube and facebook user NTA
we want youtube and facebook user