Can I run a report on reports in Kace 1000?
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
Answers (2)
Please log in to answer
Posted by:
Nico_K
7 years ago
yes you can!
And it is easy enough...
And it is easy enough...
select TITLE,CATEGORY,DESCRIPTION,QUERY from SMARTY_REPORT
It shows you all reports and also the query, see pic ;)
It shows you all reports and also the query, see pic ;)
Comments:
-
Just what I needed, thank you. - nadecats 7 years ago
Posted by:
chucksteel
7 years ago
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
Comments:
-
Unfortunately I don't know enough MySQL to get through this. - nadecats 7 years ago
