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)
( 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
Login to Subscribe
Please login to set up your
For security reasons, your link to this document has expired. Please click on the attachment link to access this file.
The attachment that you are looking for no longer exists.
There has been an issue retrieving your attachment. Please try again.
Get support for your product, with downloads, knowledge base articles, documentation, and more.
Maximize your product competency and validate technical knowledge to gain the most benefit from your IT investments.
Submit a suspected infected file to Symantec.
Report a suspected erroneous detection (false positive).
Set default language
Do you wish to save this as your future site?