Report creation ?
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.

PC1 Citrix Receiver
PC1 Citrix Receiver
PC1 Citrix Receiver

Here is my code
<?xml version="1.0" encoding="ISO-8859-1"?>
<report_name>Installed - Citrix Receiver</report_name>
<report_sql><![CDATA[SELECT system.system_id, system.hostname,, software.version FROM software LEFT JOIN system ON (system.system_id = software.system_id AND = '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_description>Name, software name, software version where software_name like Citrix Receiver.</report_description>
<column_name>System Name</column_name>
<column_name>Software Name</column_name>

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