Report: To list count of all duplicate Packages

Article:HOWTO82321  |  Created: 2012-11-14  |  Updated: 2013-02-06  |  Article URL
Article Type
How To

Please use the following SQL code to get a report to list a count of all duplicate packages within SMP

 Copy each of  the following code in SQL code section while creating a 2 new reports.

1. SMP Console > Reports > all reports 
2. Reports > Right Click > New > Report > SQL report


--- to list duplicate  packages COUNT

select Name,  COUNT(*) AS dupes  From SWDPackage (nolock)

where _Latest = 1 

--and Name like '%adobe%'

Group by Name  HAVING  (COUNT(*) > 1) 

order by dupes desc

--- to list DETAILS FOR duplicate  packages

select swp.Name, swp.Version, swp.[Package Location], swp.[Package Size], swp._Refreshed From SWDPackage as  swp (nolock)

inner join 

( select Name,  COUNT(*) AS dupes  From SWDPackage (nolock)

where _Latest = 1 Group by Name  HAVING  COUNT(*) > 1) sc on swp.Name = sc.Name

where swp._Latest = 1 --and swp.Name like '%adobe%'

order by Name

Article URL

Terms of use for this information are found in Legal Notices