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.
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