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>
|