management nightmare

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’)

Leave a Reply

Your email address will not be published. Required fields are marked *