Probably the easiest way is to go into Remedy Administrator (or Remedy User as an Administrator) and turn on the SQL logs for a bit. Note that if you turn them on in Administrator, it will generate SQL logs for all transactions for all users. This can use huge chunks of disk space. Using the logs in User will only track the transactions run by you. Rick
________________________________ From: Action Request System discussion list(ARSList) on behalf of Rob Ashmore Sent: Sun 7/23/2006 7:28 PM To: [email protected] Subject: How to see the SQL code generated by Remedy Dear All, For the purposes of analysis and reporting, a csv file is currently extracted from the Remedy Help Desk databases using the Remedy front-end (to specify time ranges and the names of the required columns). This is a messy / high maintenance approach to reading the data and does not lend itself to a good automated 'load' process. Rather than use the above method I want to interrogate the underlying Oracle tables using 3rd party SQL based software. It would help immensely if I could see the SQL code which is generated by the Remedy front-end when it produces the csv flat-file extract. I could then simply copy it into my 3rd party software program, make any necessary changes and run the code. (I would be using SAS software, more specifically 'SAS pass-thru sql' ). Could anyone please suggest where / how I can get at the code generated ( I presume in SQL) by the Remedy front-end. The sql generated is probably not very complex but I really need to see which columns come from which tables and how they are joined. I do already have read access to the 'ARADMIN' schema tables in Oracle and can see them from within SAS. If it is not possible to access the generated SQL, is there any other method which would allow me to see all the table names /columns/joins etc used in the extract. Thanks In Advance, Rob Ashmore (BTW it is probably painfully obvious that I am not really familiar with the Remedy system. Hopefully the above makes sense though! ) ______________________________________________________________________ This email contains confidential information intended only for the addressee. If you received it in error, please inform us by reply email or by calling us from Australia on 131 137 or Internationally on 612 93239500. Please also delete this email and destroy any hard copy. You must not disclose or use the information in this email. ______________________________________________________________________ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
