I am looking to report on a list of Managed group names and the Query's used on them. Is there a way to get this info? Example of output report Group NameQuery NameECIATApplication_Support_Team is ECIATEBIATApplication_Support_Team is EBIATCitrixAdd Mosaiq citrix serversNetworkAdd Network Devices

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

Report to list Query's within Managed Groups

I am looking to report on a list of Managed group names and the Query's used on them. Is there a way to get this info?

Example of output report

Group Name	Query Name
ECIAT	Application_Support_Team is ECIAT
EBIAT	Application_Support_Team is EBIAT
Citrix	Add Mosaiq citrix servers
Network	Add Network Devices

Find more posts tagged with

Accepted answers

jellobones

gd.Expression is a field with the filter/condition value that actually builds your dynamic query. If you do not need to see that then you can just run this:

SELECT g.Name, gd.Name

FROM Containers g

INNER JOIN ContainerMemberDefinitions gd

ON g.ContainerID=gd.ContainerID

WHERE FromClause IS NULL

ORDER BY g.Name

All comments

jellobones

Hope this helps... added the gd.Expression just in case you need to see the actual filter. Simply remove it if you don't need it.

SELECT g.Name, gd.Name, gd.Expression

FROM Containers g

INNER JOIN ContainerMemberDefinitions gd

ON g.ContainerID=gd.ContainerID

WHERE FromClause IS NULL

ORDER BY g.Name

bman6074

thanks for the suggestion. I don't know what gd.Expressions is. do i just remove the G. and GD. from your script?

jellobones

gd.Expression is a field with the filter/condition value that actually builds your dynamic query. If you do not need to see that then you can just run this:

SELECT g.Name, gd.Name

FROM Containers g

INNER JOIN ContainerMemberDefinitions gd

ON g.ContainerID=gd.ContainerID

WHERE FromClause IS NULL

ORDER BY g.Name

bman6074

ok i tried running it in a report under SWQL and SQL but it says query not valid. I am not sure i am following what you explaining about gd.expression filter. I am by no means a SQL scripter.