Miscellaneous

I am trying to use  KACE for our Microsoft compliance reporting.  I am starting with Microsoft Office.  When I looked at the number of installations within the software catalog it became apparent that the results were distorted when there was more than one version of Office installed on a given machine.

I am a SQL faker - in that I don't really know how to write SQL queries, but use the wizard to create my initial SQL statement, then paste it into a SQL editor with a 'designer' visual interface that I can use to edit with SQL without actually knowing how to edit SQL :-)

I was able to create a query using this method to show me the number of machines that have a match to more than one "MS Office" version within the Software catalog. 

Select
  Count(CATALOG.SAM_CATALOG.ID) As Count_ID,
  MACHINE.NAME
From
  CATALOG.SAM_CATALOG Left Join
  SAM_MACHINE_JT SMJ On CATALOG.SAM_CATALOG.ID = SMJ.SAM_CATALOG_ID Left Join
  MACHINE On MACHINE.ID = SMJ.MACHINE_ID
Where
  CATALOG.SAM_CATALOG.SAM_TYPE = 'TITLED_SUITE' And
  CATALOG.SAM_CATALOG.NAME Like '%Office%' And
  CATALOG.SAM_CATALOG.PUBLISHER Like '%Microsoft%' And
  MACHINE.ID Is Not Null
Group By
  MACHINE.NAME
Having
  Count(CATALOG.SAM_CATALOG.ID) > 1

I want to be able to use the information in the SAM Catalog for other reporting, but I can't find that table (or a view) within my SQL editor, or in the ODBC connection view.  I don't know what object CATALOG.SAM_CATALOG is pointing to.  (or if I am asking my question in a way that makes sense...)

Any thoughts?