Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to find out which queries are being used ?

Former Member

‎04-10-2015 2:23 PM

0 Kudos

We have a number of InfoSet Queries which the users are calling from SQ00. Some of them are very old.

I would like to find out which queries are being used, so we can have the idle queries decommissioned.

How can this be done ?

Best regards,

Peter

1 REPLY 1

Former Member

‎04-15-2015 1:32 PM

0 Kudos

Hi,

It's been a while since I've done this but one method is to use ST03N & look for the execution of programs with an AQ* prefix.  The general structure is AQZZ/<query user group><query name>.

You could probably get the same info from the audit log but I've not checked that.

Cheers,