/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Extract SQL from report

09/25/2019 282 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.

Don't be a Stranger!

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

Sign up! or login

Share

 
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