Open-AudIT

What's on your network?
It is currently Thu Apr 26, 2018 11:40 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Query Specific OU error
PostPosted: Thu Mar 26, 2015 7:31 pm 
Offline
Helper

Joined: Wed Aug 08, 2012 1:49 am
Posts: 65
OA 1.6.2

The query Specific OU show this error after clicking on OU:

-----------------------------------------------------------
A PHP Error was encountered

Severity: Notice

Message: Undefined property: stdClass::$man_type

Filename: theme-tango/v_report.php

Line Number: 153
--------------------------------------------------------------
After this error the PC are listed.


How can i fix it?
Thanks


Top
 Profile  
Reply with quote  
PostPosted: Fri Mar 27, 2015 11:05 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
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>

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Fri Mar 27, 2015 8:20 pm 
Offline
Helper

Joined: Wed Aug 08, 2012 1:49 am
Posts: 65
works perfectly!!
thank you very much
Frank


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group