System Details
y
SELECT system.system_id, system.hostname, system.man_owner, system.man_ip_address, system.man_model, DATE_FORMAT(system.timestamp, '%Y-%m-%d') as last_audited, system.man_manufacturer, system.man_serial, system.man_form_factor, sys_sw_windows.windows_client_site_name, sys_sw_windows.windows_user_name, oa_location.location_name FROM system LEFT JOIN oa_location ON system.man_location_id = oa_location.location_id 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
v_report
0
0
System Name
hostname
link
/main/system_display/
system_id
1
Last Audited
last_audited
timestamp
2
Form Factor
man_form_factor
text
3
Manufacturer
man_manufacturer
text
4
Model
man_model
text
5
Serial
man_serial
text
6
User
windows_user_name
text
7
Windows Site
windows_client_site_name
text
8
Owner
man_owner
text
9
Location
location_name
text
10
IP
man_ip_address
ip_address
center
11
Tags
tag
text
center