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).
Related Articles
Duplicate computers appear on the Search Computer page but not the All Computers report 72Number of Views Duplicates In Search For Computers Only (computers displayed twice) 94Number of Views Computer reporting as a VM host with hypervisor in use 56Number of Views Applications per Computer / Applications per computer per user report doesn't show many results when filtered 106Number of Views Installed count discrepancy between "Installed Applications" vs "Application Installation Details" reports from different … 4Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago