Query in SOI database - relationship between user groups and the queues they can access

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

We need a SELECT that shows the relationship between user groups and the queues they can access.

Environment

Release : 4.2

Component : SOI ALERT MANAGEMENT

Resolution

Here are the SQL Queries and their meaning..

 

 

select * from usergroupsecurity

The UserGroupID will provide the number associated with the actual Group 

select * from alertqueues

The QueueID will provide the number accociated with the actual Queue Name

select * from UserGroupSecurityAssignment

The UserGroupID will associated with the name of the User Group and the InternalID column will associaed with the Alert Queue Name

 

NOTE:  If no entire exist for an User Group, this means that the group have access to all Alert Queues.