Open-AudIT
http://www.open-audit.org/phpBB3/

Report creation ?
http://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6516
Page 1 of 1

Author:  cburbs [ Sat Feb 27, 2016 1:52 am ]
Post subject:  Report creation ?

I created a report to pull the version of citrix receiver on PCs.

The one issue I see is I have duplicate hostnames for some PCs. Any help would be great.

Example
PC1 Citrix Receiver 14.3.100.10
PC1 Citrix Receiver 14.4.0.8014
PC1 Citrix Receiver 14.3.100.10


Here is my code
<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
<details>
<report_name>Installed - Citrix Receiver</report_name>
<report_display_in_menu>y</report_display_in_menu>
<report_sql><![CDATA[SELECT system.system_id, system.hostname, software.name, software.version FROM software LEFT JOIN system ON (system.system_id = software.system_id AND software.name = 'Citrix Receiver') JOIN oa_group_sys ON (system.system_id = oa_group_sys.system_id) WHERE oa_group_sys.group_id = @group]]></report_sql>
<report_display_sql></report_display_sql>
<report_view_file>v_report</report_view_file>
<report_view_contents></report_view_contents>
<report_processing></report_processing>
<report_sort_column>0</report_sort_column>
<report_description>Name, software name, software version where software_name like Citrix Receiver.</report_description>
</details>
<columns>
<column>
<column_order>0</column_order>
<column_name>System Name</column_name>
<column_variable>hostname</column_variable>
<column_type>link</column_type>
<column_link>/main/system_display/</column_link>
<column_secondary>system_id</column_secondary>
<column_align>left</column_align>
</column>
<column>
<column_order>1</column_order>
<column_name>Software Name</column_name>
<column_variable>name</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_align>left</column_align>
</column>
<column>
<column_order>2</column_order>
<column_name>Version</column_name>
<column_variable>version</column_variable>
<column_type>text</column_type>
<column_link></column_link>
<column_secondary></column_secondary>
<column_align>left</column_align>
</column>
</columns>
</report>

Author:  jpa [ Sat Feb 27, 2016 3:18 am ]
Post subject:  Re: Report creation ?

From your table names I see you're on a recent OpenAudit build. So you need a "WHERE software.current = 'y'" in there to get only the most recent software audit info.

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/