Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Report creation ? https://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/ |