This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Orion EOC SWQL Custom report

rufus.blackmon over 6 years ago

Hi, I am trying to create a dashboard with the swql of my SAM environment. I am not sure if EOC has its own SWQL. However I am not receiving the same out put in EOC that I am getting through SAM.

Any ideas would be great

example:

SELECT DISTINCT
Nodes.Caption as [DownNodes],
Nodes.detailsurl as [_linkfor_DownNodes],
'/Orion/images/StatusIcons/Small-' + tostring(Nodes.StatusIcon) AS [_IconFor_DownNodes]
,AlertActive.TriggeredDateTime

FROM Orion.AlertObjects (nolock=true) AlertObjects

INNER JOIN Orion.AlertActive (nolock=true) AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID

INNER JOIN Orion.Nodes (nolock=true) Nodes ON Nodes.Caption=AlertObjects.RelatedNodeCaption

Where TriggeredMessage like '%is Down%' and TriggeredMessage not like '%tv%'
Order by TriggeredMessage

0 tdanner over 6 years ago

What versions of EOC and SAM are you working with?
You wrote, "I am not receiving the same out put in EOC that I am getting through SAM" - what is different?
Cancel
Vote Up 0 Vote Down

Cancel
0 rufus.blackmon over 6 years ago in reply to tdanner

Hi, I am on sam 6.5 and EOC 2.0. I put the exact swql query from my custom SAM dashboard in my EOC custom dashboard. My question is does EOC have its own swql table name??? example orion or dbo.
Cancel
Vote Up 0 Vote Down

Cancel
0 tdanner over 6 years ago in reply to rufus.blackmon

The entity names are the same. What is the difference between what you are getting from that query in EOC vs. SAM?
Cancel
Vote Up 0 Vote Down

Cancel
0 rufus.blackmon over 6 years ago in reply to tdanner

HI, I am not getting any results from the OrionEOC dashboard that I am seeing from the SAM dashboard with the same query.
Cancel
Vote Up 0 Vote Down

Cancel
0 rufus.blackmon over 6 years ago in reply to rufus.blackmon

SAM SWQL Query placed in EOC Custom Query Dashboard
*****
SELECT DISTINCT
Nodes.Caption as [DownNodes],
Nodes.detailsurl as [_linkfor_DownNodes],
'/Orion/images/StatusIcons/Small-' + tostring(Nodes.StatusIcon) AS [_IconFor_DownNodes]
,AlertActive.TriggeredDateTime
FROM Orion.AlertObjects (nolock=true) AlertObjects
INNER JOIN Orion.AlertActive (nolock=true) AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID
INNER JOIN Orion.Nodes (nolock=true) Nodes ON Nodes.Caption=AlertObjects.RelatedNodeCaption
Where TriggeredMessage like '%is Down%' and TriggeredMessage not like '%tv%'
Order by TriggeredMessage
Cancel
Vote Up 0 Vote Down

Cancel