{"id":1113,"date":"2019-12-23T17:10:18","date_gmt":"2019-12-23T09:10:18","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/?p=1113"},"modified":"2019-12-23T17:10:18","modified_gmt":"2019-12-23T09:10:18","slug":"open-audit-%e8%87%aa%e8%a8%82%e6%ac%84%e4%bd%8d%e6%9f%a5%e8%a9%a2%e6%96%b9%e5%bc%8f","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=1113","title":{"rendered":"Open-audit \u81ea\u8a02\u6b04\u4f4d\u67e5\u8a62\u65b9\u5f0f"},"content":{"rendered":"

\u67e5\u8a62\u5167\u5efa\u7bc4\u672c\u5217\u8868Manage => Queries => List Querise<\/font><\/p>\n

\"clip_image002\"<\/font><\/a><\/p>\n

\u9ede\u9078\u5de5\u4f5c\u7ad9\u7684\u7bc4\u672c\u51fa\u4f86\u770b<\/font><\/p>\n

\"clip_image004\"<\/font><\/a><\/p>\n

\u9019\u908a\u5217\u51fa\u4e86NAME IP MANUFACTURER MODEL SERIAL FROM FACTOR MEMORY PROCESSOR\u8207SQL\u67e5\u8a62\u8a9e\u6cd5\uff0c\u53ef\u53c3\u8003\u9019\u4e9b\u8a9e\u6cd5\u6539\u6210\u81ea\u5df1\u60f3\u8981\u7684\u6b04\u4f4d\u5217\u8868<\/font><\/p>\n

\"clip_image006\"<\/font><\/a><\/p>\n

\u539f\u59cbWorkStation SQL\u8a9e\u6cd5<\/font><\/p>\n

\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<\/font><\/p>\n

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<\/font><\/p>\n

\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<\/font><\/p>\n

\u81ea\u5df1\u7de8\u4fee\u5f8c \u4e3b\u8981\u689d\u4ef6\u6539\u70ba system.type = ‘computer’ AND system.form_factor = ‘desktop’ AND system.class != ‘server’ AND system.class != ‘hypervisor’ AND system.class != ‘virtual server’<\/font><\/p>\n

\u53ea\u79c0COMPUTER\u8207DESKTOP\u7684\u8a2d\u5099<\/font><\/p>\n

\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<\/font><\/p>\n

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<\/font><\/p>\n

\u81ea\u8a02\u67e5\u8a62\u6b04\u4f4d Manage => Queries => Create Queries<\/font><\/p>\n

\"clip_image008\"<\/font><\/a><\/p>\n

\"clip_image010\"<\/font><\/a><\/p>\n

\u67e5\u8a62\u5167\u5efa\u7bc4\u672c\u5217\u8868Manage => Queries => List Querise \u591a\u51fa\u4e86\u525b\u65b0\u589e\u7684\u67e5\u8a62\uff0c\u9ede\u7da0\u8272PLAY\u9375\u53ef\u5217\u8868<\/font><\/p>\n

\"clip_image012\"<\/font><\/a><\/p>\n

\u7b26\u5408\u525b\u525b\u8a2d\u5b9a\u689d\u4ef6\u7684\u5217\u8868\u8cc7\u8a0a\uff0c\u518d\u9ede\u9078\u53f3\u4e0a\u89d2\u7684Export\u5373\u53ef\u532f\u51fa\u5831\u8868<\/font><\/p>\n

\"clip_image014\"<\/font><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\u67e5\u8a62\u5167\u5efa\u7bc4\u672c\u5217\u8868Manage => Queries => List Querise<\/p>\n<\/p>\n

\u9ede\u9078\u5de5\u4f5c\u7ad9\u7684\u7bc4\u672c\u51fa\u4f86\u770b<\/p>\n<\/p>\n

\u9019\u908a\u5217\u51fa\u4e86NAME IP MANUFACTURER MODEL SERIAL FROM FACTOR MEMORY PROCESSOR\u8207SQL\u67e5\u8a62\u8a9e\u6cd5\uff0c\u53ef\u53c3\u8003\u9019\u4e9b\u8a9e\u6cd5\u6539\u6210\u81ea\u5df1\u60f3\u8981\u7684\u6b04\u4f4d\u5217\u8868<\/p>\n<\/p>\n

\u539f\u59cbWorkStation SQL\u8a9e\u6cd5<\/p>\n

\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026..<\/p>\n

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[564],"tags":[565],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1113"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1113"}],"version-history":[{"count":1,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1113\/revisions"}],"predecessor-version":[{"id":1114,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1113\/revisions\/1114"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1113"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}