/build/static/layout/Breadcrumb_cap_w.png

K1000-View SQL for Reports created by Wizard?

Is it possible to view sql queries for the reports we created via the report wizard in the new K1000 Version: 6.4.120822? I would like to edit the queries manually. 

Thank you

0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: sam240 7 years ago
Second Degree Blue Belt
2

Top Answer

I found my answer if anyone is looking. This is a bug in Kace. http://www.itninja.com/blog/view/using-sql-to-modify-custom-reports-made-by-the-reporting-wizard-in-kace
Posted by: SMal.tmcc 7 years ago
Red Belt
1
you edit the wizard query and press the edit sql button at the bottom of the screen

Comments:
  • on which screen? I don't see edit sql button anywhere. Now these are the reports I created using report wizard. Do I need to have something enabled in order for the "edit sql" option to appear? - sam240 7 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

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