How can I check ComponentType as ComponentLevel in SAM Orion.APM? Is there any table of ComponentType in Orion

anooppandey3

Find more posts tagged with

sam

apm

solarwind apm

community discussion

solarwinds sam

Accepted answers

Seashore

Is it Orion.APM.Componentdefinition you are looking for?

SWQL for that could be:

SELECT TOP 10
    C.Name AS ComponentName
    ,D.Name AS ComponentType

FROM Orion.APM.Component AS C
INNER JOIN Orion.APM.Componentdefinition AS D ON C.ComponentType=D.ComponentType

All comments

Seashore

Is it Orion.APM.Componentdefinition you are looking for?

SWQL for that could be:

SELECT TOP 10
    C.Name AS ComponentName
    ,D.Name AS ComponentType

FROM Orion.APM.Component AS C
INNER JOIN Orion.APM.Componentdefinition AS D ON C.ComponentType=D.ComponentType

anooppandey3

Thanks for response.

How to check database availability for Node level and Component Level in Orion ?

Seashore

Have you set up SWQL studio? If not read more about to get started here: https://thwack.solarwinds.com/resources/b/product-blog/posts/intro-to-swql-studio