Extract SQL from report

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

Answers (1)

Posted by: chucksteel 2 years ago
Red Belt

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

  • 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 - dwestness 2 years ago
    • 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. - chucksteel 2 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ