Report - for Microsoft compliance - where is the SAM_CATALOG table in SQL Query for K1000
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.
Count(CATALOG.SAM_CATALOG.ID) As Count_ID,
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
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
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...)