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 ?
Community Chosen Answer
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!