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)
Please log in to answer
Posted by:
chucksteel
5 years ago
When you edit the report there should be a button for "Edit SQL". Click that and copy the query from there.
Comments:
-
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 5 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 5 years ago
