OpenAudit 8.4 Report Windows Service Pack Details

Il software OpenAudit permette la creazione di report personalizzati, quello che propongo qui sotto è inerente all’analisi dei service pack per i sistemi Microsoft Windows.

Di seguito il file XML,
da importare nel sistema.

<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
	<details>
		<report_name>Windows Service Pack Details</report_name>
		<report_display_in_menu>y</report_display_in_menu>
		<report_sql><![CDATA[SELECT system.system_id, system.man_ip_address, system.hostname, system.man_form_factor, system.man_manufacturer, system.man_model, system.man_serial, system.os_name, sys_sw_windows.windows_service_pack, system.pc_date_os_installation AS installed, sys_sw_windows.windows_user_name, date_format( system.first_timestamp, '%Y-%m-%d' ) AS first_seen, date_format( system.last_seen, '%Y-%m-%d' ) AS last_seen, system.last_seen_by FROM system LEFT JOIN sys_sw_windows ON ( system.system_id = sys_sw_windows.system_id AND system.timestamp = sys_sw_windows.timestamp )  LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_id WHERE oa_group_sys.group_id = ? GROUP BY system.hostname ORDER BY system.hostname]]></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>
	</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_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>1</column_order>
			<column_name>IP</column_name>
			<column_variable>man_ip_address</column_variable>
			<column_type>ip_address</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align>center</column_align>
		</column>
		<column>
			<column_order>2</column_order>
			<column_name>Form Factor</column_name>
			<column_variable>man_form_factor</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>3</column_order>
			<column_name>Manufacturer</column_name>
			<column_variable>man_manufacturer</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>4</column_order>
			<column_name>Model</column_name>
			<column_variable>man_model</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>5</column_order>
			<column_name>Serial</column_name>
			<column_variable>man_serial</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>6</column_order>
			<column_name>OS</column_name>
			<column_variable>os_name</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>7</column_order>
			<column_name>SP</column_name>
			<column_variable>windows_service_pack</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>8</column_order>
			<column_name>OS Installed</column_name>
			<column_variable>installed</column_variable>
			<column_type>timestamp</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>9</column_order>
			<column_name>User</column_name>
			<column_variable>windows_user_name</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>10</column_order>
			<column_name>First Seen</column_name>
			<column_variable>first_seen</column_variable>
			<column_type>timestamp</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>11</column_order>
			<column_name>Last Seen</column_name>
			<column_variable>last_seen</column_variable>
			<column_type>timestamp</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
		<column>
			<column_order>12</column_order>
			<column_name>Last Seen By</column_name>
			<column_variable>last_seen_by</column_variable>
			<column_type>text</column_type>
			<column_link></column_link>
			<column_secondary></column_secondary>
			<column_ternary></column_ternary>
			<column_align></column_align>
		</column>
	</columns>
</report>