When comparing the Search For Computers Page & All Computers Report a discrepancy may be perceived: Why are there more devices in the All Computers Report than Search For Computers? Please see example below:

Multi-platform - Snow License Manager 9.x

Logic Behind Deletion:

The reason this happens is because the All Computers Report includes devices that have been flagged to be deleted from Snow License Manager & are stored in ds.tblComputersToDelete.

The sequence of events are that when a machine is deleted it is stored into two tables - ds.tblComputersToDelete & dbo.tblComputersDeleted.

The first service to run is the Snow License Manager Maintenance Service which will delete the device from ds.tblComputersToDelete;

1) Prior to Maintenance Service being restarted.

2) After Maintenance Service being restarted & prior to the Snow Software Inventory Service being restarted:

The next to run is the Snow Software Inventory Service; when the Computers are deleted from ds.tblComputersToDelete & the column 'ActionStatus' is checked as 1 (which = true) & the service will continue to delete the device.

After Snow Software Inventory Service Restart:

The difference is in fact by design because the All Computers Report includes the deleted computers until the Services run (on a schedule)

Check Snow License Manager Maintenance Service - is it currently running? If not please start the service; if so please restart the service. Remember if the information is still in ds.tblComputersToDelete it will likely be related to the maintenance service. If this is unsuccessful review the log file for further details - C:\Program Files\Snow Software\Logs\Maintenance + also check SELECT * FROM ds.tblComputersToDelete as an 'orphaned CID' could be causing a build up of devices unable to delete.

Check Snow Software Inventory Service - is it currently running? If not please start the service; if so please restart the service. Remember if the information is still in dbo.tblComputersToDelete it will likely be related to the Inventory service. If this is unsuccessful review the log file for further details C:\Program Files\Snow Software\Logs\InventoryService + check SELECT * FROM dbo.tblComputersDeleted.

Run the below query to update the status of a device to test manually:

Update tblComputersDeleted

SET ActionStatus =1

Where ComputerID = xyz

Please then restart the Snow Software Inventory Service & monitor the log files & tables again. It should trigger a deletion process.

The All Computers Report has more entities as it includes the deleted computers until the Snow License Manager Maintenance Service + Snow Software Inventory Service are ran (on a schedule).