OK I will look at that part. How can I get a report to show all computers running like "9.11.9600".
I used the Flash report and changed a few lines but it gives me the computers with the count I just want a straight list in one output.
So it shows for example I have 9.11.9600.18163 7 which is 7 installs of v 9.11.9600.18163. I just want a list with all PCs no count value.
<?xml version="1.0" encoding="ISO-8859-1"?> <report> <details> <report_name>Installed - IE 11</report_name> <report_display_in_menu>y</report_display_in_menu> <report_sql><![CDATA[SELECT COUNT(DISTINCT system.system_id) AS software_count, sys_sw_software.software_name, sys_sw_software.software_version, sys_sw_software.software_publisher, sys_sw_software.software_url, sys_sw_software.software_email, sys_sw_software.software_id, sys_sw_software.software_comment, system.man_icon, system.man_os_family, system.hostname FROM sys_sw_software LEFT JOIN system ON (sys_sw_software.timestamp = system.timestamp AND sys_sw_software.system_id = system.system_id) LEFT JOIN oa_group_sys ON (system.system_id = oa_group_sys.system_id) WHERE oa_group_sys.group_id = @group AND sys_sw_software.software_name LIKE '%Internet Explorer%' and sys_sw_software.software_version LIKE '%9.11.9600%' GROUP BY sys_sw_software.software_name, sys_sw_software.software_version ORDER BY sys_sw_software.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>0</report_sort_column> <report_description>Name, software name, software version where software_name like IE11.</report_description> </details> <columns> <column> <column_order>0</column_order> <column_name>System Name</column_name> <column_variable>hostname</column_variable> <column_table>system</column_table> <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>Package 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> <column_order>1</column_order> <column_name>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> <column> <column_order>2</column_order> <column_name>Installs</column_name> <column_variable>software_count</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>
|