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

Bring status icon into SQL report?

FormerMember

I have the following Advanced SQL report in Report Writer:

SELECT TOP 1000 [TimeStamp]

,[ApplicationName]

,[ComponentName]

,[ComponentStatus]

,[ResponseTime]

,[Threshold-ResponseTime-Warning]

,[Threshold-ResponseTime-Critical]

FROM [NetPerfMon].[dbo].[APM_AlertsAndReportsData]

WHERE (NodeName = Node)

ORDER by ResponseTime DESC

It returns the results I need, but I would also like to tack on a status indicator. (ie, the colored status icon of the monitored component).

How can I achieve this? It seems like something simple to do, but I am no SQL whiz, and all attempts to achieve this or find someone else on Thwack who has done it have failed.

Find more posts tagged with

Accepted answers

aLTeReGo

SAMs application status is handled a little differently than node status. I don't believe there is any way to include application status icons as part of a report. You could probably accomplish this using a Custom Query Resource following the SWQL examples outlined in the Orion SDK.

All comments

aLTeReGo

You will likely need to do an inner join to the nodes table but below is the query that should gather the node status icon

SELECT Nodes.StatusLED AS Status_Icon FROM Nodes

FormerMember

Thanks aLTeReGo, this gets me a little closer, however, this pulls the status icon for the node itself, which in this case is just a purple and white arrow because the node is an external website being monitored for response time.

What I am looking for are the icons that show the component status as shown below.

These icons are in the 'C:\Inetpub\SolarWindsNPM\Orion\APM\Images\StatusIcons\Components' folder, but I am not sure where they are referenced in the database(s), so I cannot figure out how to pull them in.

aLTeReGo

FormerMember

Thanks, I guess I wasn't crazy afterall. I'll figure out some other way if the SDK can't get me there. Case closed.