티스토리 뷰

반응형
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.NI_VENDOR AS DISK_VENDOR,
      B.NI_MODEL AS DISK_MODEL,
      CASE
        WHEN INSTR(B.NI_MODEL, 'SSD') = '0' THEN "일반"
        WHEN INSTR(B.NI_MODEL, 'SSD') > '0' THEN "SSD"
      END GUBUN
FROM ALDER.NODELIST A, ALDER.DEVINFOALL_STORAGE B
WHERE A.NL_DEVID = B.NI_DEVID
AND B.NI_FILESYSTEM ='NTFS'
ORDER BY A.NL_IPSTR ASC

 

반응형
반응형
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함