Systems Management Question

A report from kace/system that contains specific report from kace organizations

11/04/2015 1106 views
Greetings everyone 
Is there way to create a report from /kace/system site that its a summary / sum of a specific raport for each organization in Kace, for example i would like to create a report " Bad extension list " that ll contain a raport :
- "Exe list loc " from ogranization 1 ( that raport is accesible from kace/admin when log in that organization )
- "BAC list loc" from organizaton 2 ( that raport is accesible from kace/admin when log in that organization )
( that raport is accesible from kace/admin when log in that organization ) from organization 3

Thanks for help
Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author

You can combine orgs by replacing the ORGx tables with <ORGANIZATION_DB> and the system will iterate through all orgs and create a query joining all orgs together.  Now the real kicker here is that if you are looking at assets the columns are created dynamically so you have to manually do that in SQL.  In that case you prefix all of your tables with the proper DB name and place a UNION ALL between each of the separate queries.

All of the ORG databases are restricted by a Rx user for access but the System level one uses "Report" user that you can use to access them all.  This makes for a good spot to break out MySQL workbench to put your more complicated queries together with.
Answered 11/04/2015 by: CraigT
Orange Belt

All Answers

Organization data is stored in separate ORGx tables, so ORG1.MACHINE, ORG2.MACHINE, etc. As far as I know the reporting users only have access to their particular organization, but my KBox doesn't have ORGs enabled so I can't test that. Have you setup a tool like MySQL Workbench and connected to the database using different users to see if you can access the tables?

Answered 11/04/2015 by: chucksteel
Red Belt

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