Build Reports for Appliction Inventory Using SQL 2005 Business Development Studio

To build reports for application inventory using SQL 2005 Business Development Studio use the following...

SELECT   T0.Name AS [Workstation Name], T1.Name AS Application, T1.Version, T0.Guid, T3.login_name, T3.equip_status

FROM     vComputer AS T2 
INNER JOIN vResourceEx AS T0 ON T2.Guid = T0.Guid 

LEFT OUTER JOIN       Inv_AeX_OS_Add_Remove_Programs AS T1 ON T0.Guid = T1._ResourceGuid 

This section does a join on our Asset database (remedy) to pull user info. This is commented out as an example.

--LEFT OUTER JOIN [CHDEVAPPS01
--\WAREHOUSE].remedydata.dbo.vw_remedydata_AllEquip AS 
--T3 ON T0.Name = T3.asset_name

If you want to use report parameters uncomment the following line in for your dataset in BIDS.

--WHERE   (T1.Name IN (@Application))