A report from kace/system that contains specific report from kace organizations
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
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
CraigT
8 years ago
Top 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.
Posted by:
chucksteel
8 years ago
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?
