SELECT
AaaUser.FIRST_NAME 'Usuario',
SystemInfo.WORKSTATIONNAME 'Estacion de Trabajo',
SoftwareList.SOFTWARENAME 'Nombre del Software',
SoftwareLicenses.LICENSEKEY 'Licencia Instalada',
swinstallationkeyinfo.PRODUCTKEY 'Licencia Detectada'
FROM
SystemInfo
LEFT JOIN SoftwareInfo ON (SystemInfo.WORKSTATIONID = SoftwareInfo.WORKSTATIONID)
LEFT JOIN SoftwareList ON (SoftwareList.SOFTWAREID = SoftwareInfo.SOFTWAREID)
LEFT JOIN SoftwareLicenses ON (SoftwareInfo.LICENSEID = SoftwareLicenses.RESOURCEID)
LEFT JOIN ResourceOwner ON (SystemInfo.WORKSTATIONID = ResourceOwner.RESOURCEID)
LEFT JOIN AaaUser ON (AaaUser.USER_ID = ResourceOwner.USERID)
LEFT JOIN swinstallationkeyinfo ON (SoftwareInfo.SOFTWAREINFOID = swinstallationkeyinfo.SOFTWAREINFOID)
WHERE
(((SystemInfo.WORKSTATIONNAME LIKE 'Vulpecula%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Libra%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Cetus%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Hydra%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Tucana%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Triangulum%' OR
SystemInfo.WORKSTATIONNAME LIKE 'CCNIBACKUP %' OR
SystemInfo.WORKSTATIONNAME LIKE 'SCULPTOR %' OR
SystemInfo.WORKSTATIONNAME LIKE 'Corvus%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Octans%' OR
SystemInfo.WORKSTATIONNAME LIKE 'BLACKBERRY%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Cetusbk%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Ws_cl_vap_%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Ws_cl_scl_%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Nb_cl_vap_%' OR
SystemInfo.WORKSTATIONNAME LIKE 'Nb_cl_scl_%' OR
SystemInfo.WORKSTATIONNAME LIKE 'respaldo%')
AND
SystemInfo.WORKSTATIONNAME NOT LIKE '%_ANTIGUO' AND
SystemInfo.WORKSTATIONNAME NOT LIKE '%_DE_BAJA' AND
SystemInfo.WORKSTATIONNAME NOT LIKE '%_BODEGA')
AND
(SoftwareList.SOFTWARENAME LIKE 'Microsoft Windows XP Professional' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Windows 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft(R) Windows(R) Server 2003%' OR
SoftwareList.SOFTWARENAME LIKE 'Windows 2000 Server' OR
SoftwareList.SOFTWARENAME LIKE 'Windows NT 4.0 ' OR
SoftwareList.SOFTWARENAME LIKE 'Windows XP professional' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Access 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft SQL Server 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office XP Standard' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Small Business%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Visio Professional 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Visio Standard 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Professional%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Standard Edition 200%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office Project%' OR
SoftwareList.SOFTWARENAME LIKE 'Microsoft Office 200%'))
ORDER BY 3,1