Open-AudIT

What's on your network?
It is currently Mon Apr 23, 2018 7:21 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Thu Aug 18, 2011 10:22 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
What reports would you like that aren't available out-of-the-box ?

I have no problem's creating reports (even custom report's that would not be as useful for others) that people want/need.

Just post your request in this thread. If you need something sensitive, post here and I can email you the XML definitions - just let me know.

_________________
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 Aug 19, 2011 2:01 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
The last report you built for me was great and solved my same "UUID" problem.

The other major report that we have made in Jasper is a report that shows all the computers by year: lowest to highest, and then subdivided by company and then location, or in OA2s case Organization and Location. This makes it easy for management to approve our computer and server budgets.

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


Top
 Profile  
Reply with quote  
PostPosted: Fri Aug 19, 2011 12:39 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1944
Location: Brisbane, Australia
So date purchased, organisation, location?
Should be easy enough - with one caveat...
There is no way to break a report into seperate sections.
I can create a report showing the details and sorted by the above order, but there will be no section breaks, as such.

A screenshot is attached - note I haven't populated any "Date Purchased" fields on this dataset, but it is sorting by that, then Org, then Location...

Try the below definition.

Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<report>
   <details>
      <report_name>System Replacement</report_name>
      <report_display_in_menu>y</report_display_in_menu>
      <report_sql>SELECT system.system_id, system.hostname, system.man_manufacturer, system.man_model, system.man_serial, oa_location.location_name, oa_org.org_name, system.man_purchase_date FROM system left join oa_group_sys on system.system_id = oa_group_sys.system_id left join oa_location on system.man_location_id = oa_location.location_id left join oa_org on system.man_org_id = oa_org.org_id where oa_group_sys.group_id = ? GROUP BY system.hostname ORDER BY oa_org.org_name, oa_location.location_name</report_sql>
      <report_display_sql></report_display_sql>
      <report_view_file>v_report</report_view_file>
      <report_view_contents></report_view_contents>
      <report_processing></report_processing>
      <report_sort_column>1</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>left</column_align>
      </column>
      <column>
         <column_order>1</column_order>
         <column_name>Date Purchased</column_name>
         <column_variable>man_purchase_date</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>2</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>left</column_align>
      </column>
      <column>
         <column_order>3</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>4</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>left</column_align>
      </column>
      <column>
         <column_order>5</column_order>
         <column_name>Owner</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>6</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>
   </columns>
</report>


Attachment:
1.png
1.png [ 227.92 KiB | Viewed 1361 times ]

_________________
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: Sat Aug 20, 2011 12:48 am 
Offline
Helper

Joined: Fri Feb 19, 2010 1:02 am
Posts: 67
Location: Washington State, USA
Thanks again man! I have been reading over your reports and they seem pretty simple to create. I may try and write a couple of my own just to play with it.

-Shmee

_________________
Server Info:
OA: v1.0.3
OS: Ubuntu 13.04 on Hyper-V for Website (LAMP)
OS: Windows Server 2008 R2 for Script (Domain Server)
Auditing: 366 Machines (XP/Win7/Ubuntu)
LDAP: Active Directory


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

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 4 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