SELECT A.NL_FQDN, A.NL_IPSTR, /*A.NL_MAC,*/ (SELECT NI_MOTHERBOARDNAME FROM ALDER.DEVINFOALL_CPU WHERE NI_DEVID = A.NL_DEVID) AS NI_MOTHERBOARDNAME, (SELECT NI_NAME FROM ALDER.DEVINFOALL_CPU WHERE NI_DEVID = A.NL_DEVID) AS NI_NAME, A.NL_PLATFORM, (SELECT CONCAT(ROUND(NI_TOTALMEM/1024/1024,2),' GB') FROM ALDER.DEVINFOALL_MEM WHERE NI_DEVID = A.NL_DEVID) AS NI_TOTALMEM, B.NI_NAME AS DISK_NAME, B.N..