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.
-
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 3 years 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 3 years ago
Answers (2)
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
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 3 years 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 3 years 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 3 years 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 3 years ago
