Hi Omega,
Looks like an issue with the report definition. Import the below and it should hopefully be fixed. FYI - I added man_type to the report_sql field.
This will be included in the next release.
First remove the old query by menu -> Admin -> Queries -> List Queries and clicking the X icon. Import the new query by copying the below and pasting it into the textbox at menu -> Admin -> Queries -> Import Query.
Mark.
[code]<?xml version="1.0" encoding="ISO-8859-1"?> <report> <details> <report_name>Specific OU</report_name> <report_display_in_menu>n</report_display_in_menu> <report_sql><![CDATA[SELECT man_icon, hostname, system.system_id as system_id, man_model, man_owner, man_type, org_name, location_name FROM system LEFT JOIN oa_group_sys ON system.system_id = oa_group_sys.system_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_org ON system.man_org_id = oa_org.org_id LEFT JOIN oa_location ON system.man_location_id = oa_location.location_id WHERE oa_group_sys.group_id = @group AND sys_sw_windows.windows_active_directory_ou = (SELECT windows_active_directory_ou FROM sys_sw_windows WHERE windows_id = ?)]]></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>Devices in a specific Active Directory OU.</report_description> </details> <columns> <column> <column_order>0</column_order> <column_name>Icon</column_name> <column_variable>man_icon</column_variable> <column_type>image</column_type> <column_link></column_link> <column_secondary>man_type</column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> <column> <column_order>1</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>left</column_align> </column> <column> <column_order>2</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>left</column_align> </column> <column> <column_order>3</column_order> <column_name>Assigned To</column_name> <column_variable>man_owner</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>4</column_order> <column_name>Organisation</column_name> <column_variable>org_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>5</column_order> <column_name>Location</column_name> <column_variable>location_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>6</column_order> <column_name>Tags</column_name> <column_variable>tag</column_variable> <column_type>text</column_type> <column_link></column_link> <column_secondary></column_secondary> <column_ternary></column_ternary> <column_align>center</column_align> </column> </columns> </report>[/code]
_________________ Support and Development hours available from [url=https://opmantek.com]Opmantek[/url]. Please consider a purchase to help make Open-AudIT better for everyone.
|