Report for selected/unselected list resources for all nodes

Dear all,

I want to know what are all the volumes or interfaces what are selected for monitoring under "List Resources" for a given nodes - is there a report that can be used to pull the selected or unselected resources for all nodes in monitoring? In this example i need to get either selected or unselected resource list

Find more posts tagged with

list resources

Accepted answers

All comments

stuartd

We have a report that shows what has already been selected...

The logic is quite straightforward:

You just need to add on all the other aspects you want to pull back from the dropdown list, and then select appropriate fields in the edit resource section.

If I get time I'll have a look at some SWQL for showing all possible resources and their current state.

stuartd

So here's a little bit of SWQL code that will tell you all volumes (monitored or not) but what I can't see is a way to include what state they are in.

SELECT 
     cov.VolumeId
	,cov.Caption
	,cov.RawCaption
	,cov.FullName
	,cov.VolumeIndex
	,cov.VolumeType_Value
	,cov.VolumeType
	,cov.PollingType_Value
	,cov.PollingType
	,cov.VolumeDescription

FROM Cortex.Orion.Volume AS cov

MarkyB

We meet again @stuartd

Can a query list all nodes with building and city custom attributes?

Asking for a SQL phobe

stuartd

Ha .. well I'm no expert in S(W)QL and it depends on how you want to display or filter them, but as an example, create your query and then in the WHERE statement it could be something like:

WHERE IP_Address LIKE '10.1.%' ((AND cp.Building LIKE ''%xyz%' ) OR (cp.City LIKE '%abc%'))

If you just want them to appear in your results somewhere then just make them a part of your SELECT statement where they are included either because they are in that table, or they are JOIN'd or they have an implied join.

edwinhoekman

Gents,

I would use a Navigation Propperty (the chain sign in SWQL Studio). By using the Navigation Property you can avoid Joins. It would look something like:

SELECT 
     [cov].VolumeId
	,[cov].Caption
	,[cov].RawCaption
	,[cov].FullName
	,[cov].VolumeIndex
	,[cov].VolumeType_Value
	,[cov].VolumeType
	,[cov].PollingType_Value
	,[cov].PollingType
	,[cov].VolumeDescription
    ,[cov].Node.IP_Address -- getting IP_Address out of Orion.Nodes	
    ,[cov].Node.CustomProperties.City -- getting City out of Orion.NodesCustomProperties
    ,[cov].Node.CustomProperties.Building -- getting Building out of Orion.NodesCustomProperties

FROM Cortex.Orion.Volume AS [cov]

WHERE [cov].Node.IP_Address LIKE '%A.B.%' AND [cov].Node.CustomProperties.City LIKE '%%'