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 ?

 

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

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

Answered 11/20/2012 by: jverbosk
Red Belt

Please log in to comment

Answers

0

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?

Answered 10/17/2012 by: sdnbtech1
Fourth Degree Green Belt

  • 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.
  • 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?
Please log in to comment
Answer this question or Comment on this question for clarity