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:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

1
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

Please log in to comment

Answers

0
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

Please log in to comment
Answer this question or Comment on this question for clarity