topic To Create an utility program for query. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/to-create-an-utility-program-for-query/m-p/6386829#M1404079 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>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.</P><P></P><P>System</P><P>Client</P><P>Query name</P><P>Query description</P><P>Creation timestamp</P><P>Creator</P><P>Infoset</P><P>Tables involved</P><P></P><P>If possible, we would like to know how many times they were run and when was the last time it ran.</P><P>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).</P><P>Do feel free to add any other information you may consider relevant.</P><P></P><P>Thanks in Advance,</P><P>Rachana.</P></BODY></HTML> Mon, 07 Dec 2009 06:47:57 GMT Former Member 2009-12-07T06:47:57Z To Create an utility program for query. https://community.sap.com/t5/application-development-and-automation-discussions/to-create-an-utility-program-for-query/m-p/6386829#M1404079 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>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.</P><P></P><P>System</P><P>Client</P><P>Query name</P><P>Query description</P><P>Creation timestamp</P><P>Creator</P><P>Infoset</P><P>Tables involved</P><P></P><P>If possible, we would like to know how many times they were run and when was the last time it ran.</P><P>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).</P><P>Do feel free to add any other information you may consider relevant.</P><P></P><P>Thanks in Advance,</P><P>Rachana.</P></BODY></HTML> Mon, 07 Dec 2009 06:47:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/to-create-an-utility-program-for-query/m-p/6386829#M1404079 Former Member 2009-12-07T06:47:57Z Re: To Create an utility program for query. https://community.sap.com/t5/application-development-and-automation-discussions/to-create-an-utility-program-for-query/m-p/6386830#M1404080 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>You can use AQGQCAT table to retrieve query details.</P><P>Further tables on query are AQG*</P><P></P><P>Hope this Helps</P><P></P><P>Nag</P></BODY></HTML> Mon, 07 Dec 2009 07:02:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/to-create-an-utility-program-for-query/m-p/6386830#M1404080 Former Member 2009-12-07T07:02:27Z