|
SELECT Distinct R .Netbios_Name0, ARP .DisplayName0 FROM dbo .v_R_System R INNER JOIN dbo.v_GS_ADD_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID Inner Join dbo.v_FullCollectionMembership FCM ON R.ResourceID = FCM.ResourceID and CollectionID = 'SMS00001' WHERE ARP .DisplayName0 in ( 'Microsoft Office Professional Edition 2003', 'Microsoft Office Enterprise 2007', 'Microsoft Office Professional Plus 2007', 'Microsoft Office Project Professional 2003', 'Adobe Indesign CS3', 'Adobe Acrobat 8 Professional - English, Franais, Deutsch', 'Adobe Acrobat 7.0 Professional', 'Adobe Photoshop Elements', 'FAS 100 Asset Accounting', 'Keyboard Express', 'Macromedia Dreamweaver MX 2004', 'QuickBooks Pro 2007', 'Traffix for Windows 8.0')
|
|
|