HardSoft-Viewer SQL
/*HardInfo视图 */select Computers.Factory as 廠別,
Computers.Depart as 部門,
Computers.id as 財產編號,
Computers.Owner as 使用者,
Computers.Account as 帳戶,
Computers.Locate as 存放位置,
Hardware.OS as 操作系統,
Hardware.CPU,
Hardware.Computer_Type as 主機型號,
Hardware.Ram as 內存,
concat(ceil(Hardware.Ram / 256) * 256, 'MB') as 標準內存,
Hardware.Display_Card as 顯卡,
Hardware.MotherBoard_Vendor as 主板廠商,
Hardware.MotherBoard_Type as 主板型號,
Hardware.HardDisk_Type as 硬盤型號,
Hardware.HardDisk_Size as 硬盤大小,
/*Hardware.size / (1024 * 1024 * 1024) as STNAD_HARD,*/
concat(case when Hardware.HardDisk_Size/(1024*1024*1024)40 and Hardware.HardDisk_Size/(1024*1024*1024)80 and Hardware.HardDisk_Size/(1024*1024*1024)120 and Hardware.HardDisk_Size/(1024*1024*1024)160 and Hardware.HardDisk_Size/(1024*1024*1024)250 and Hardware.HardDisk_Size/(1024*1024*1024)320 and Hardware.HardDisk_Size/(1024*1024*1024)500 and Hardware.HardDisk_Size/(1024*1024*1024)750 and Hardware.HardDisk_Size/(1024*1024*1024)1024 and Hardware.HardDisk_Size/(1024*1024*1024)1500 and Hardware.HardDisk_Size/(1024*1024*1024)
页:
[1]