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

Custom SWQL query is [_LabelFor_ColumnName] a thing?
Hello all, I'm looking to create a Custom SWQL Query that pulls in interface bps data and sorts the bps column as a number rather then a string. I'm wondering if there is a magic [_ItemFor_ColumnName] like [_LinkFor_Node] or [_IconFor_Node] does. Currently using CONCAT causes the column to be sorted as a string and that's…
Node downtime report makes no sense
I am working on a report using Node Downtime History fields and the output makes no sense. Every Final Datetime value is also seen as the Start Datetime value for the next outage event. How is this possible?
How to format the "ToLocal" SWQL command
I need to convert the timestamps in a SWQL report to show in local time. I know that the ToLocal command will do that, but I can't tell where the parentheses go. Can anyone provide a before and after example? Thanks.
Possible to reverse engineer a web report?
Is it possible to start with an Orion report that was configured using Select Objects or Dynamic Query and then see the SQL, or better yet, the SWQL equivalent?
I give up on SWQL Joins!!
I cannot figure out how to construct a SWQL JOIN to save my life. I am even using the SWQL Studio but can't get the syntax right. I've searched and I cannot find any good references or tutorials. Lots of references on WHAT it can do, but none so far on HOW TO DO IT!! Using a simple example of the Nodes table and the Nodes…
Need a report on Customer device availability
I need a little help with a custom SWQL report that shows the average availability of each customer devices over a defined time period, grouped by customer. I used to have a custom SQL report that worked, but it must be on an old DB schema cuz it doesn't work now on 2020.2.6. Having a good SWQL version is better anyway,…
SWQL/SQL report joining multiple component script outputs into one. SSL Cert Monitor Issuer, Expiration, and Subject.
I'm currently using the SSL: Certificate Expiration template provided by @KMSigma.SWI and it's working great. Now we want to see the data in an easier to digest format. Problem is that the only place I'm able to find all the data pulled by this single component is in the DynamicEvidence table and there's no easy way for me…
Error in custom SQL report; want to convert to SWQL
I have a custom SQL report that generates an error in 2020.2.6 - probably because it is from an older database schema. Can anyone help with the error message at the beginning and also convert it to SWQL? Appreciate it. Error executing SQL: Operand type clash: datetime2 is incompatible with numeric Query: SELECT TOP 10000…
Emails/email notifications failing to send, why?
Hi all, I am posting with an issue and a couple of questions that I'd very much appreciate being solved. We have several made jobs for "Config Change Comparison" reporting, somewhat like the given template. After the jobs are done running, each one gives out an error stating "Unable to send a notification email to *blank*.…
Need report listing report schedule action information
I want to create a report that will list any report schedules where the Action is configured to send an email to a specific person. I cannot find the database table where the "ActionID" is stored. There is some useful information in the ReportJobs table, but I can't find the ActionID field anywhere. Anyone have an idea?