Is it possible to pull the Organization Description Field into a report in Dell KACE
I want to run a report and I want to have the Organization Description field in it, does anybody know how to pull that field into a report, and is it even possible ?
Answers (2)
You *should* be able to do this by using a variation of the query below, although I can't be 100% on this as I only have 1 ORG here.
Just two things to be aware of:
1) You'll need to expand the WHERE T.TABLE_NAME RLIKE statement to include any other tables you are pulling from (i.e. WHERE T.TABLE_NAME RLIKE 'MACHINE|USER|etc).
2) You'll want to use DISTINCT in the SELECT query to filter results, due to the type of JOIN being used. Actually, there's nothing really to JOIN on (I tried TABLES.TABLE_IN_ORG1 but got "command denied to user"), thus the "openness" of this.
SELECT DISTINCT M.NAME AS MACHINE_NAME, T.TABLE_SCHEMA AS ORG
FROM ORG1.MACHINE M, INFORMATION_SCHEMA.TABLES T
WHERE T.TABLE_NAME rlike 'MACHINE'
ORDER BY M.NAME
Hope that helps!
John
Are you asking about the KACE organizations ie Org1, Org2? Or are this a specialized field in your KACE system such as a location asset?
Comments:
-
In KACE when you create more than one Organization there is a place underneath the Organization name where you can enter a Description for that Organization. I have contacted Dell and they also say that there is no table in the database so it cannot be used in reports. - CharlesG 12 years ago
-
That's what I figured you meant, but wanted to be sure. Could you create a group concat field in your query that inserts a field into your report with that info based on the organization? - sdnbtech1 12 years ago
