Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to fetch the details of "USED BY" tab of Security Groups

Highlighted
James++
Regular Collector

How to fetch the details of "USED BY" tab of Security Groups

Hi Friends,

I want to delete all the Obsoleted "Security Groups".
So as a part of this requirement I need to fetch the data of various column like 'Type','Reffering Entity' and 'Details' of USED BY tab in Security Groups(Kindly check the Screen-shot in the attachment).

Any existing SQL View (Provided by HP) or any script available will be helpful.

It would be great help, if anyone can guide me how to do this, because manually execution of task will be a tedious activity.

Thanks.
4 REPLIES
Jim Esler
Honored Contributor

Re: How to fetch the details of "USED BY" tab of Security Groups

The easiest way to capture this kind of information usually is to enable debug logging on a relatively idle instance, trigger the activity, then disable logging. You can then find the SQL query in the log files.
James++
Regular Collector

Re: How to fetch the details of "USED BY" tab of Security Groups

Hi Jim,

Thanks for your quick reply, I got the query in the JDBC logs.

Once again thanks.
shijubch
Regular Collector

Re: How to fetch the details of "USED BY" tab of Security Groups

Hi,

 

Can anyone share the query to fetch the "USED BY " tab

 

Thanks

AlexSavencu
Honored Contributor

Re: How to fetch the details of "USED BY" tab of Security Groups

Hi, James,

 

one extra caution you should take: the query will only show entities which reference the security group(s) directly.

 

If your implementation uses custom SQL queries to query these security groups, some of the customized functionalities will fail.

 

I don't know if this applies to your implementation, but I think it's worth mentioning.

 

cheers

alex


--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event