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.