How do I correct the package count when it appears that the package count has multiplied?
When the package count in the package servers page on the NS is reporting a higher number of available packages than what the package servers actually have the problem can be corrected by running the following SQL code against the altiris database using query analyzer.
Note! Backup your database before running this code.
-- SQL Query begins here
select distinct *
drop Table swdpackageserver
drop Table PkgSvrCleanup_Temp
-- SQL Query ends here
The specific cause for this situation is unknown but is most often found when the NS experiences performance issues related to SQL IO or when package servers do not have reliable network links.