OpenAudit 8.4 Report Windows Service Pack Details

2013 May 25

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>