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

SQL or VIEW to select group-members

FormerMember

Hi,

can someone point me to a sql statment that generates a list of nodes which a member of a certain group?

@SW Team: For future use it might be good to have some views (i.e. one per objecttype) with these information.

Many thanks in advance,

Jörg

Find more posts tagged with

Accepted answers

netlogix

how about:

SELECT *

FROM [NetPerfMon].[dbo].[ContainerMemberSnapshots]

inner join [NetPerfMon].[dbo].[Containers] on Containers.ContainerID = ContainerMemberSnapshots.ContainerID

where [EntityDisplayName] = 'Node'

All comments

FormerMember

Anyone?

netlogix

how about:

SELECT *

FROM [NetPerfMon].[dbo].[ContainerMemberSnapshots]

inner join [NetPerfMon].[dbo].[Containers] on Containers.ContainerID = ContainerMemberSnapshots.ContainerID

where [EntityDisplayName] = 'Node'

FormerMember

Thanks a lot netlogix!

I was looking at the wrong end. this works.

Kind regards, Jörg

ladycne

This was really helpful!

How can I add both these statements together?

SELECT containermembersnapshots.ContainerID

FROM [NetPerfMon].[dbo].[ContainerMemberSnapshots]

inner join [NetPerfMon].[dbo].[Containers] on Containers.ContainerID = ContainerMemberSnapshots.ContainerID

where [EntityDisplayName] = 'Node' and

ContainerMemberSnapshots.ContainerID in (53, 54, 55, 56)

with this query..

SELECT DISTINCT

CustomPollerAssignment_1.NodeID

,Nodes.School

,Nodes.Caption AS 'HostNode Name'

,nodes.MachineType

,mac.mac as MAC

,(SELECT CustomPollerStatus.Status

FROM

CustomPollerStatus

INNER JOIN

CustomPollerAssignment ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID

WHERE

(CustomPollerAssignment_1.NodeID = CustomPollerAssignment.NodeID) AND

(CustomPollerAssignment.PollerID = '6E20C586-5577-4E97-A7BE-7C53703F8975')) AS 'Serial Number'

FROM

CustomPollerAssignment AS CustomPollerAssignment_1

INNER JOIN

CustomPollers ON CustomPollerAssignment_1.PollerID = CustomPollers.PollerID

INNER JOIN

Nodes ON CustomPollerAssignment_1.NodeID = Nodes.NodeID

INNER JOIN

CustomPollerStatus AS CustomPollerStatus_1 ON CustomPollerAssignment_1.CustomPollerAssignmentID = CustomPollerStatus_1.CustomPollerAssignmentID

INNER JOIN NodeMACAddresses as MAC ON MAC.NodeID = Nodes.NodeID

ORDER BY School