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

Custom Reports Enhancement - Custom Query Reports

Ability to build and save custom reports based similar to standard SQL queries. Giving the ability to pull data from a module outside of reports built into SWSD.

In order to build these, allow customers to submit a request to SolarWinds with the information they are wanting to pull and the SWSD support team can provide the query. This removes the need to document any DB or individual table structures.

Some custom commands can be used like in the example below for Dates to help run the query based on the ranges Solarwinds typically supports in the reports and dashboard for day/week/month/quarter periods.

Example Query:

select COMPUTER_NAME, LONG_TO_DATE(DETECTED_TIME) from cmdb.assets where DETECTED_TIME <=DATE_TO_LONG(09/29/2009 00:00:00) or (DETECTED_TIME <=<from_lastmonth> and DETECTED_TIME> = <to_lastmonth>)

Find more posts tagged with

Reports

New Feature

Status: None

Comments

wolgar

I previously used Freshservice, and the custom reporting module in Freshservice was fantastic. I could build my own custom reports to show trends and compare things like SLA failures that happened that week vs. total ticket intake that week, or out of all tickets closed in a week, how many had SLA failures. Or comparing how SLA failures impact CSAT responses.