Skip to main content
June 28, 2022
Question

How to find executed queries in appian mysql

  • June 28, 2022
  • 4 replies
  • 1 view

Hi Everyone,

Is there any way to find out out the list of executed sql queries in mysql database hosted in appian cloud?

Thanks,

Shubham

    4 replies

    vikashk739
    June 28, 2022

    Hi Shubham, don't know how much it can help but you can get your last executed query at least, by going to SQL tab of Database and clicking on get auto saved query

    harshitb6843
    June 28, 2022

    AFAIK, there isn't any such way to get the queries. Let's see if someone else has a solution to this.

    vikashk739
    June 28, 2022

    Hi Shubham, 

    You can go to the Database, at the bottom you can find the console and there you can click on History, it will have all the executed queries. I have checked and found that it only contains queries of recent session only not all past queries.

    Got this info from Stack overflow

    christineh465186
    June 28, 2022

    look into the rdbms-audit-log if you are referring to DB activity for your business datasource (i.e. MariaDB) when in Appian managed cloud