Client Management Suite

Hello guys,

We have received many negative feedback from our client regarding this report.

Can someone help us eliminate the updates/patch entry of software on this report?

It would be best if this report will only display the current installed software version and not include the upgraded/old versions and patches it have..

A simple search found this which should do the trick: 

https://www-secure.symantec.com/connect/forums/help-installed-software-computer-report-smp71

Symantec Support gave us a query.. Can you look on this if this will be enough?

SELECT vc.Guid, vc.Name AS ComputerName, vu.Name AS UserName, arp.DisplayName, arp.DisplayVersion

FROM vComputer vc

RIGHT JOIN (SELECT DISTINCT Name FROM vComputer) AS vc1

ON vc1.Name = vc.Name

INNER JOIN Inv_AddRemoveProgram arp ON vc.Guid = arp._ResourceGuid

INNER JOIN vUser vu ON vc.[User] = vu.Name

and Hidden='0' and [DisplayName] not like '%(KB%'

If you run that query as well as the one provided in the thread I pointed out, which one provides you with the information you need? 

check this SQL query.

(

Select CAST (MAX (rus.ModifiedDate) AS DATETIME) [Inventory Collection Time]

,rus.ResourceGuid

From ResourceUpdateSummary rus

WHERE rus.InventoryClassGuid = '1960C684-9BD6-450C-95F0-E5BF8AA45A77' OR

rus.InventoryClassGuid = '324AAA03-D5D2-4853-98E8-5483E4F4EABC' OR

rus.InventoryClassGuid = '88077BE9-9F64-41AD-98DF-C7AC7E0FA8F3'

GROUP BY rus.ResourceGuid

)