Video Screencast Help

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