Skip to Content
0
Former Member
Dec 07, 2009 at 06:47 AM

To Create an utility program for query.

61 Views

Hello all,

I have a requirement where I need to develop an utility program which should create a downloadable report with more or less the following content.

System

Client

Query name

Query description

Creation timestamp

Creator

Infoset

Tables involved

If possible, we would like to know how many times they were run and when was the last time it ran.

Can you please let me know where are the queries saved? And from where can we get the details for these above mentioned fileds? ( Except system and Client).

Do feel free to add any other information you may consider relevant.

Thanks in Advance,

Rachana.