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

Application Availability Report

Just wanted to let others benefit from this. We are using Application Monitor and the report below gives us some nice statistics on the availability of applications on servers with a certian namepattern as shown:

quote:SELECT
Applications.FullName AS ApplicationName,
AVG(ApplicationStatistics.Availability) AS AVERAGE_of_Availability

FROM
Applications INNER JOIN ApplicationStatistics ON (Applications.AppID = ApplicationStatistics.AppID)

WHERE
( DateTime > (GetDate()-30) )
AND
(
(Applications.FullName LIKE '%LIMS%') OR
(Applications.FullName LIKE '%WTS%') OR
(Applications.FullName LIKE '%DKORACLE%') OR
(Applications.FullName LIKE '%COGNOS%') OR
(Applications.FullName LIKE '%TERM%')
)

GROUP BY
Applications.FullName

ORDER BY FullName ASC

If anubody has any suggestions on how one could exclude weekends and perhaps also just should the last full month rather than the past 30 days, I would appreciate the input

Lars Grabowski
Global Infrastructure
Chr. Hansen A/S

Currently using:
Cirrus Version 2.1 DL-500 Feb. 2006 (8.1.42)
Orion Application Monitor 7.8.94
Orion Web Engine Version 7.8.133
Orion NPM SLX 7.8.5 March 2006
Alert Manager 8.1.15

Find more posts tagged with

Accepted answers

All comments

RyanJett

Adding "Last Month" can be tricky when using an Advanced SQL Report. When building any other type of Report, "Last Month" is calculated when the Report is executed, and the date/time values are hard-coded into the SQL Query at run-time.

The WHERE statement for the query for Last Month (March 06 in this example) excluding all Saturdays and Sundays would look like this:

WHERE
( DateTime BETWEEN 38777 AND 38807.9999884259 )
AND
(
(DATEPART(weekday, DateTime) <> 1) AND
(DATEPART(weekday, DateTime) <> 7)
)
AND
(
(Applications.FullName LIKE '%LIMS%') OR
(Applications.FullName LIKE '%WTS%') OR
(Applications.FullName LIKE '%DKORACLE%') OR
(Applications.FullName LIKE '%COGNOS%') OR
(Applications.FullName LIKE '%TERM%')
)

Keep in mind that "38777" and "38805.9999884259" represent "3/1/2006 12:00:00 AM" and "3/31/2006 11:59:59 PM" respectively. These numbers would have to be updated each month manually to change the timeframe.

Ryan Jett
SolarWinds.Net
918-307-8100

Grabowski

Hi Ryan,

Thanks for your reply. One question though: Who can remember that "38777" and "38805.9999884259" represent "3/1/2006 12:00:00 AM" and "3/31/2006 11:59:59 PM" and who can figure out what to put in their place the following month? What I really need is something that every month will make a report for the previous full month without me modifying the code over and over again.

Any suggestions?

Lars Grabowski
Global Infrastructure
Chr. Hansen A/S

Currently using:
Cirrus Version 2.1 DL-500 Feb. 2006 (8.1.42)
Orion Application Monitor 7.8.94
Orion Web Engine Version 7.8.133
Orion NPM SLX 7.8.5 March 2006
Alert Manager 8.1.15