mcarriere893
Posts: 3621
Score: 300 Joined: 4/12/2002 From: Manitoba, Canada Status: offline
|
Couple o simple ones to get you started: SELECT DISTINCT v_R_System.Name0, v_SoftwareProduct.ProductName, v_SoftwareProduct.ProductVersion FROM v_SoftwareInventory INNER JOIN v_SoftwareProduct ON v_SoftwareInventory.ProductId = v_SoftwareProduct.ProductID INNER JOIN v_R_System ON v_SoftwareInventory.ClientId = v_R_System.ResourceID WHERE (v_SoftwareProduct.ProductName = ' Microsoft (R) .NET Framework' ) ORDER BY v_R_System.Name0, v_SoftwareProduct.ProductVersion SELECT DISTINCT v_R_System.Name0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS.Version0 FROM v_GS_ADD_REMOVE_PROGRAMS INNER JOIN v_R_System ON v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_R_System.ResourceID WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 IN (' Microsoft .NET Framework (English)' , ' Microsoft .NET Framework 1.1' , ' Microsoft .NET Framework 2.0' , ' Microsoft .NET Framework 2.0 Beta' , ' Microsoft .NET Framework 2.0 Beta 2' )) ORDER BY v_GS_ADD_REMOVE_PROGRAMS.DisplayName0
_____________________________
Mark Carriere Microsoft MVP-SMS www.SMSUG.ca
|