Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

Report on installed software products and install date

Created: 01 Feb 2011 • Updated: 09 Feb 2011 | 3 comments
Steen Bogø's picture
This issue has been solved. See solution.

Hi all

Im working on a report that show installed products on a computer, but i need to have the install date for the product. This is the report im using.

Select vc.[Name]as 'computer name', vc.[User], p.[Product name]

from vcomputer vc

JOIN inv_SoftwareProduct_InstallationInfo ils on ils._ComputerResourceGuid = vc.guid

join vSoftwareProduct p on p.Guid = ils._ResourceGuid

Kind Regards

Steen

Comments 3 CommentsJump to latest comment

Andrew Bosch's picture

Does this work for you?

SELECT vc.Name, sp.Name, inst.InstallDate

FROM vRM_Computer_Item vc

JOIN Inv_InstalledSoftware inst

   ON inst._ResourceGuid = vc.Guid

   AND inst.InstallFlag = 1

JOIN ResourceAssociation ra

   ON ra.ChildResourceGuid = inst._SoftwareComponentGuid

   AND ra.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'

JOIN vSoftwareProduct sp

   ON sp.Guid = ra.ParentResourceGuid

ORDER BY vc.Name ASC

------------------------------------
Sr. Principal SQA Engineer
Symantec

SOLUTION
Steen Bogø's picture

Thanks, it works.

How can it be that you use the vRM_Computer_Item insted of the vComputer?

Regards

Steen

Andrew Bosch's picture

vRM_Computer_Item performs much better than vComputer when working with large data sets.  In my testing here (with over 200,000 computers in 1 database) there is a very noticeable difference.  However, if you are working with less than 10 or 20k computers then vComputer will work just fine...:-)

------------------------------------
Sr. Principal SQA Engineer
Symantec