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

SQL query to SWIS

roadcycling

Hello,

I have a query in SQL but if I run it with SWIS (/orion/Admin/swis.aspx) I have an error

Server error: Error: A query to the SolarWinds Information Service failed.

RunQuery failed, check fault information.
Source entity [AlertHistoryView] not found in catalog

My query :

SELECT AlertHistoryID, AlertObjects.EntityCaption, Nodes.team, Nodes.Tribe, Nodes.Squad

FROM AlertHistory INNER JOIN AlertObject ON AlertHistoryView.AlertObjectID = AlertObjects.AlertObjectID INNER JOIN Nodes ON AlertObjects.EntityCaption = Nodes.Caption

WHERE (AlertHistoryView.AlertHistoryID = '''+ $Alert.AlertObjectID +''')

I can not convert it. Is it possible to help me?

Thanks

Best regards

Find more posts tagged with

Accepted answers

roadcycling

Hello,

Your query is too long in execution and the SW does not respond

What I have done :

I select my alerte :

SELECT AlertObjectID, AlertID, AlertNote, EntityType, EntityCaption, EntityNetObjectId, EntityDetailsUrl, RelatedNodeDetailsUrl, RelatedNodeCaption, RelatedNodeID FROM Orion.AlertObjects WHERE AlertObjectID IN (SELECT AlertObjectID FROM Orion.AlertActive WHERE Acknowledged = 1) AND (AlertNote NOT LIKE '%noticket::%' OR AlertNote is NULL)

With the value of RelatedNodeID (sam NodeID)

SELECT NodeID, Alerting, Country, NodeType, SiteCode, SiteType, Squad, Team, Tribe FROM Orion.NodesCustomProperties Where NodeID = ''' + $Alert.RelatedNodeID + '''

This allows me to recover the custom attributes of the node

Best Regards

All comments

i_like_eggs

looking at the query it looks like some of the tables you are referring to don't exist in the database. like the AlertObject should be AlertObjects. i have converted what i think you need, try this:

SELECT AH.AlertHistoryID, AO.EntityCaption,EntityCaption, CP.team, CP.Tribe, CP.Squad

FROM Orion.AlertHistory AH

INNER JOIN Orion.AlertObjects AO ON AO.AlertObjectID =AH.AlertObjectID

INNER JOIN Orion.AlertConfigurations AC ON AC.AlertID = AO.AlertID

INNER JOIN Orion.Nodes N ON N.NodeID = AO.RelatedNodeID

LEFT JOIN ORION.NodesCustomProperties CP ON CP.NodeID = N.NodeID

roadcycling

Hello,

Your query is too long in execution and the SW does not respond

What I have done :

I select my alerte :

With the value of RelatedNodeID (sam NodeID)

SELECT NodeID, Alerting, Country, NodeType, SiteCode, SiteType, Squad, Team, Tribe FROM Orion.NodesCustomProperties Where NodeID = ''' + $Alert.RelatedNodeID + '''

This allows me to recover the custom attributes of the node

Best Regards