Como obetener un listado de equipos con Autocad desde OpenAudit

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>

Comentarios