廣告

2019 年 12 月
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

彙整

Open-audit 自訂欄位查詢方式

查詢內建範本列表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 […]