Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Groups and Reports - what do you want? https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=5755 |
Page 1 of 1 |
Author: | Mark [ Thu Aug 18, 2011 10:22 am ] |
Post subject: | Groups and Reports - what do you want? |
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. |
Author: | Shmee [ Fri Aug 19, 2011 2:01 am ] |
Post subject: | Re: Groups and Reports - what do you want? |
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. |
Author: | Mark [ Fri Aug 19, 2011 12:39 pm ] |
Post subject: | Re: Groups and Reports - what do you want? |
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>[/code] [attachment=0] 1.png [ 227.92 KiB | Viewed 4961 times ] |
Author: | Shmee [ Sat Aug 20, 2011 12:48 am ] |
Post subject: | Re: Groups and Reports - what do you want? |
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 |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |