|
SELECT Distinct R .Netbios_Name0, ARP .DisplayName0, OS .Caption0 FROM dbo .v_R_System R INNER JOIN dbo.v_GS_ADD_REMOVE_PROGRAMS ARP ON R.ResourceID = ARP.ResourceID INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON OS.ResourceID = ARP.ResourceID 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') AND R.Operating_System_Name_and0 in ('Microsoft Windows NT Workstation 6.1','Microsoft Windows NT Workstation 5.1')
|
|
|