#若還有比對資料會造成設備資料被覆蓋的問題在把比對參數關閉即可
大概找到問題了，比對條件只用TYPE+SERIAL配對，就會造成覆蓋問題。
到設定列表
找到比對出問題的參數
大概找到問題了，比對條件只用TYPE+SERIAL配對，就會造成覆蓋問題。
到設定列表
找到比對出問題的參數
- 1月 27 週三 202116:03
OpenAudIT蒐集電腦資料被其他不同電腦資料覆蓋的問題(兩台資料只剩下一台)
- 12月 23 週一 201917:08
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 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……………………..
點選工作站的範本出來看這邊列出了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……………………..1
