Systems Management Question
A report from kace/system that contains specific report from kace organizations
11/04/2015 1106 views
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 Chosen by the Author
Please log in to answer
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