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

Component Availability

Is there a way to build a component availability report? I have been successful in pulling application availability however I am needing a break down by component.

Find more posts tagged with

Accepted answers

All comments

vinay.by

I am assuming you are talking about SAM Component Availability, yes you can build it

Add the required fields onto the report like say Application Name, Application Status, Component Name, Component Status etc

brooke.twehus

Yes, thank you! I figured it out right after I posted this.

vinay.by

bucweat

If you want SWQL query, this should get you started in the right direction:

SELECT
     node_name
    ,app_name
    ,comp_name
    ,Availability
    ,[sm].DisplayName as [Avail]
    ,date
    ,numrecs
    ,total
    ,ROUND(((numrecs*1.0)/(total*1.0))*100.0,1) as p
FROM
(
    select 
         [as].Application.Node.NodeName as node_name
        ,[as].Application.Name as app_name
        ,[as].Application.Components.Name as comp_name
        ,[as].Availability
        ,DateTrunc('day', [as].TimeStamp) as date
        ,sum([as].RecordCount) as numrecs
        ,   ( 
                select 
                    sum([as2].RecordCount) as s 
                from Orion.APM.ApplicationStatus AS [as2]
                where 
                    [as].Application.Node.NodeName = [as2].Application.Node.NodeName
                    and [as].Application.Name = [as2].Application.Name
                    and DateTrunc('day', [as].TimeStamp) = DateTrunc('day', [as2].TimeStamp)
            ) as total
    from Orion.APM.ApplicationStatus AS [as]
    WHERE 
        ([as].Application.Name like 'msi_%')
        and [as].TimeStamp BETWEEN DATETIME('2024-01-01') and DATETIME('2024-12-30')
    group BY
         [as].Application.Node.NodeName
        ,[as].Application.Name
        ,[as].Application.Components.Name
        ,DateTrunc('day', [as].TimeStamp)
        ,[as].Availability
)
JOIN Orion.APM.StatusMetadata [sm] on Availability = [sm].ApmStatusValue
ORDER BY
     node_name
    ,app_name
    ,comp_name
    ,date desc

A few notes:

I preappend all of my app names with "msi_" so that I can easily search for them. You'll want to adjust or remove ([as].Application.Name  like 'msi_%') accordingly...note if you remove filter you'll get a lot of stuff you might not care about.
Originally I didn't have [as].Application.Components.Name  as  comp_name in the query as all of my apps have only one component. I added it here and it seems to be working...but you should verify for yourself.
I have polling of my apps set to every 60 seconds.
This query should take handle pruning of tables by database maintenance scripts (e.g. 1 record/min kept for 7 days, then pruned to 1 record/hour that summarizes the 1 sample/min data)

sharath_kb

Use custom table, and select object as "application or component" It all depends on what fields you select during the report columns. It will be directly available