/build/static/layout/Breadcrumb_cap_w.png

Uncataloged Software Report

I would like to create a report that list all new uncataloged software detected in the last 24 hours. We  have users that are installing software and not telling IT and the software does not show in the KACE catalog so they dont show on the compliance report. 


2 Comments   [ + ] Show comments
  • I had a user download a software and it does not show in the discovered, only the uncatalogued section. So it is installed but not in the KACE catalog, I can add it to the local catalog and it will show in license compliance but the uncatalogued section is quite large so it would be rather hard to filter out. - jrunkles1221 2 months ago
  • How would I go about doing a report that shows the the last 24 hours of software changes for devices? The 24 hours part is whats getting me. - jrunkles1221 2 months ago

Answers (2)

Posted by: Hobbsy 2 months ago
Red Belt
0

if the user installs software, it will not appear in the "uncatalogued" section, software in that tab is only software that is not included in the downloaded KACE Software catalogue, in other words it is not recognised. The installation will show in the "Discovered" tab, if it is a product held within the downloaded catalogue and is installed, or "Not-discovered" if it is in the catalogue but not found to be installed on any device.

I would suggest you need to look in the history of the device as that will show what has been installed. In the device inventory record, go to software and click the "show changes" link to display what has been installed and removed.


You may prefer a report from the asset history to see what has been added

Posted by: Hobbsy 2 months ago
Red Belt
0

Try something like this to start


Select * from ASSET_HISTORY


WHERE ASSET_HISTORY. CHANGE_TYPE = "DETECTED" AND

ASSET_HISTORY. FIELD_NAME = "SOFTWARE" AND

ASSET_HISTORY.TYPE_NAME = "Device" AND

ASSET_HISTORY.TIME > DATE_SUB(NOW(), INTERVAL 31 DAY)


You could then further refine the report to exclude all the standard software maybe


Comments:
  • This actually works perfectly! Thanks. How do I go about excluding common software by name? I assume it would be a different table, the column name comes up as value1 and I tried to add "ASSET_HISTORY. Value1 NOT LIKE "Microsoft Office 365 Business" AND" and that did not work. - jrunkles1221 2 months ago
    • You might want to try adding != statements with OR to build up your query and take out the software you don’t need. - Hobbsy 2 months ago
      • Thank you. I have this
        Select * from ASSET_HISTORY

        WHERE ASSET_HISTORY. CHANGE_TYPE = "DETECTED" AND

        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - en-us" AND
        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - es-es" AND
        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - ar-sa" AND
        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - zh-cn" AND
        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - fr-fr" AND
        ASSET_HISTORY. Value1 != "Microsoft Office 365 Business - de-de" AND
        ASSET_HISTORY. Value1 != "Microsoft Edge" AND
        ASSET_HISTORY. Value1 != "Adobe Acrobat Reader DC" AND
        ASSET_HISTORY. Value1 != "Microsoft Edge Update" AND
        ASSET_HISTORY. Value1 != "Google Chrome" AND

        ASSET_HISTORY. FIELD_NAME = "SOFTWARE" AND
        ASSET_HISTORY.TYPE_NAME = "Device" AND
        ASSET_HISTORY.TIME > DATE_SUB(NOW(), INTERVAL 10 DAY)

        Is there a way to exclude with a contains statement , like exclude all the contain "Microsoft Office 365" - jrunkles1221 2 months ago
      • Think I figured it out.

        Using:
        ASSET_HISTORY. Value1 NOT LIKE "%Microsoft Office 365 Business%" AND
        ASSET_HISTORY. Value1 NOT LIKE "%Chrome%" AND - jrunkles1221 2 months ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ