廣告

2020 年 9 月
 123456
78910111213
14151617181920
21222324252627
282930  

彙整

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 […]