/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Editing reports in k1000 using SQL workbench

11/19/2015 734 views

Hi guys

Need a little help. I would like to edit some reports that I

created in the k1000 using an sql editor...(Workbench to be precise).

I have connected successfully but cant seen to find the report to

edit.

I am not an sql guru, and haven't worked with it in a while... but I

have used it before.

Any one know how to edit reports or any other schema in the k1000??

Where are they located??  Cant find them in the KBSYS or the ORG1.

Thanks Guys.

0 Comments   [ + ] Show comments

Comments


All Answers

1
You can't edit the reports directly in the database. Open the report in the web interface and copy the SQL query to Workbench. Once you have made the necessary changes, either paste them back into the original report or create a new SQL report in the reporting module.

Reports are stored in the SMARTY_REPORTS table so if you really want to pull the query directly from the table that's where you'll find them.

Answered 11/19/2015 by: chucksteel
Red Belt

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