Este Query sirve para obtener un listado de equipos que tienen Autocad instalado en tu red haciendo uso de la herramienta Open Source OpenAudit, igual te puede servir para otro software solo sustituye la palabra Autocad en todo el Query por el del software que quieres auditar.
Para agregarlo a OpenAudit ve al menú Admin / Queries / Import Query y luego haces clic en el botón Submit, con esto tendrás agregado el Query listo para usar.
Luego nos regresamos al inicio, hacemos clic en el menú Queries y luego en el nuevo query.
<?xml version=»1.0″ encoding=»ISO-8859-1″?>
<report>
<details>
<report_name>Installed – Autocad</report_name>
<report_description>Installed Autocad software (software name contains
‘autocad’).</report_description>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[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.class AS
system.class, system.os_family AS system.os_family, oa_org.name AS
oa_org.name, windows.user_name AS windows.user_name, software.name as
software.name, software.version AS software.version, software.id as
software.id FROM system LEFT JOIN software ON (software.system_id =
system.id AND software.current = ‘y’ AND software.name LIKE
‘%autocad%’) LEFT JOIN oa_org ON (oa_org.id = system.org_id)
LEFT JOIN windows ON (windows.system_id = system.id AND windows.current
= ‘y’) LEFT JOIN oa_group_sys ON (oa_group_sys.system_id =
system.id) WHERE oa_group_sys.group_id = @group ORDER BY system.name,
software.name]]></report_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>1</report_sort_column>
</details>
<columns>
<column>
<id>201</id>
<column_order>0</column_order>
<column_name>Icon</column_name>
<column_variable>system.icon</column_variable>
<column_type>image</column_type>
<column_link></column_link>
<column_secondary>system.type</column_secondary>
<column_ternary></column_ternary>
<column_align>center</column_align>
</column>
<column>
<id>202</id>
<column_order>1</column_order>
<column_name>Device Name</column_name>
<column_variable>system.name</column_variable>
<column_type>link</column_type>
<column_link>/devices/</column_link>
<column_secondary>system.id</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>203</id>
<column_order>2</column_order>
<column_name>Domain</column_name>
<column_variable>system.domain</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>204</id>
<column_order>3</column_order>
<column_name>IP Address</column_name>
<column_variable>system.ip</column_variable>
<column_type>ip_address</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>205</id>
<column_order>4</column_order>
<column_name>OS Family</column_name>
<column_variable>system.os_family</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>206</id>
<column_order>5</column_order>
<column_name>Organisation</column_name>
<column_variable>oa_org.name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>207</id>
<column_order>6</column_order>
<column_name>User</column_name>
<column_variable>windows.user_name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>208</id>
<column_order>7</column_order>
<column_name>Software Name</column_name>
<column_variable>software.name</column_variable>
<column_type>link</column_type>
<column_link>/report/specific_software/$group_id/</column_link>
<column_secondary>software.id</column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
<column>
<id>209</id>
<column_order>8</column_order>
<column_name>Software Version</column_name>
<column_variable>software.version</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_ternary></column_ternary>
<column_align>left</column_align>
</column>
</columns>
</report>