Asset Management Suite

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

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

Thanks, it works.

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

Regards

Steen

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...:-)