/build/static/layout/Breadcrumb_cap_w.png
09/25/2019 122 views

I have created a report via the KACE SMA Wizard. I would like to extract the SQL query it is using so i can leverage in an external system. Is it possible to see the SQL or do i need to completely rewrite the query in mySQL (Something i'm not too familiar with)

0 Comments   [ + ] Show comments

Comments


All Answers

1

When you edit the report there should be a button for "Edit SQL". Click that and copy the query from there.

Answered 09/25/2019 by: chucksteel
Red Belt

  • The "Edit SQL" button is not present.. It is on some of my reports but others do not have this option. I beleive this button only works on reports that only encompass a single table which once i have multiple tables involved it is no longer there
    • Hmm. In that case, you might be better off posting what you want the report to include and seeing if someone can help create the query.