How can I identify the last query modified on my system?

Version 1
    Question

    How can I identify the last query modified on my system?

    Answer

    Run the following in SQL query analyser:

     

    SELECT     md_guid, md_name, md_title, md_last_update

    FROM         md_query_template

    ORDER BY md_last_update DESC

    Environment

    ITBM all