Miscellany

SELECT DISTINCT 
                      ALL_HBA.AHBA_ID, ALL_HOSTS.AHOS_Name, LKP_HBA.LHBA_Manufacturer, LKP_HBA.LHBA_Description, LKP_LOGICAL_DISKS.LLDS_DeviceID, 
                      ALL_LOGICAL_DISKS.ALDS_LUNSizeMB, ALL_HBA.AHBA_SCSIPort
FROM         ALL_HBA INNER JOIN
                      ALL_HOSTS ON ALL_HBA.AHOS_ID = ALL_HOSTS.AHOS_ID INNER JOIN
                      LKP_HBA ON ALL_HBA.LHBA_ID = LKP_HBA.LHBA_ID INNER JOIN
                      ALL_LOGICAL_DISKS ON ALL_HOSTS.AHOS_ID = ALL_LOGICAL_DISKS.AHOS_ID INNER JOIN
                      LKP_LOGICAL_DISKS ON ALL_LOGICAL_DISKS.LLDS_ID = LKP_LOGICAL_DISKS.LLDS_ID
WHERE     (LKP_HBA.LHBA_Manufacturer <> 'Hewlett-Packard Company') AND (LKP_HBA.LHBA_Manufacturer <> 'Compaq')