查詢內建範本列表Manage => Queries => List Querise
點選工作站的範本出來看
這邊列出了NAME IP MANUFACTURER MODEL SERIAL FROM FACTOR MEMORY PROCESSOR與SQL查詢語法，可參考這些語法改成自己想要的欄位列表
原始WorkStation SQL語法
……………………..
SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, system.domain AS `system.domain`, system.ip AS `system.ip`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, system.os_family AS `system.os_family`, system.memory_count AS `system.memory_count`, system.form_factor AS `system.form_factor`, processor.description AS `processor.description` FROM system LEFT JOIN processor ON (processor.system_id = system.id AND processor.current = ‘y’) WHERE @filter AND system.type = ‘computer’ AND system.class != ‘server’ AND system.class != ‘hypervisor’ ORDER BY system.name
……………………..
自己編修後 主要條件改為 system.type = ‘computer’ AND system.form_factor = ‘desktop’ AND system.class != ‘server’ AND system.class != ‘hypervisor’ AND system.class != ‘virtual server’
只秀COMPUTER與DESKTOP的設備
……………………..
SELECT system.id AS `system.id`, system.icon AS `system.icon`, system.type AS `system.type`, system.name AS `system.name`, system.domain AS `system.domain`, system.ip AS `system.ip`, system.manufacturer AS `system.manufacturer`, system.model AS `system.model`, system.serial AS `system.serial`, system.os_family AS `system.os_family`, system.memory_count AS `system.memory_count`, system.form_factor AS `system.form_factor`, processor.description AS `processor.description` FROM system LEFT JOIN processor ON (processor.system_id = system.id AND processor.current = ‘y’) WHERE @filter AND system.type = ‘computer’ AND system.form_factor = ‘desktop’ AND system.class != ‘server’ AND system.class != ‘hypervisor’ AND system.class != ‘virtual server’ ORDER BY system.ip
自訂查詢欄位 Manage => Queries => Create Queries
查詢內建範本列表Manage => Queries => List Querise 多出了剛新增的查詢，點綠色PLAY鍵可列表
符合剛剛設定條件的列表資訊，再點選右上角的Export即可匯出報表
![clip_image001[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0011.gif "clip_image001[1]"){kind=small}
![clip_image002[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0021.gif "clip_image002[1]"){kind=small}
![clip_image003[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0031.gif "clip_image003[1]"){kind=small}
![clip_image004[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0041.gif "clip_image004[1]"){kind=small}
![clip_image005[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0051.gif "clip_image005[1]"){kind=small}
![clip_image006[1]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0061.gif "clip_image006[1]"){kind=small}
![clip_image001[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0012.gif "clip_image001[2]"){kind=small}
![clip_image002[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0022.gif "clip_image002[2]"){kind=small}
![clip_image003[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0032.gif "clip_image003[2]"){kind=small}
![clip_image004[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0042.gif "clip_image004[2]"){kind=small}
![clip_image005[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0052.gif "clip_image005[2]"){kind=small}
![clip_image006[2]](http://blog.infinity.idv.tw/wp-content/uploads/2020/02/clip_image0062.gif "clip_image006[2]"){kind=small}
近期留言