/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


Can I run a report on reports in Kace 1000?

06/02/2016 1275 views
I could use a report of any existing reports that show fields that are filtered and the filter criteria.

Thanks,
nadecats
0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

2
yes you can!
And it is easy enough...
select TITLE,CATEGORY,DESCRIPTION,QUERY from SMARTY_REPORT
It shows you all reports and also the query, see pic ;)

Answered 06/07/2016 by: Nico_K
Red Belt

  • Just what I needed, thank you.

All Answers

1
Initially I thought that this wouldn't be too difficult but the report tables are pretty complicated. If you have MySQL experience then check the following tables:
SMARTY_REPORT - stores the report definitions
REPORT_FIELD - stores report fields

Answered 06/03/2016 by: chucksteel
Red Belt

  • Unfortunately I don't know enough MySQL to get through this.

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