Differences

This shows you the differences between two versions of the page.

--- exchange:reporting:reporting_project [2010/03/06 10:26]
ben
+++ exchange:reporting:reporting_project [2010/04/28 05:29] (current)
ben
@@ Line 92: / Line 92: @@
 |parse_allExchange.pl       ||dname,cname,displayName,legacyExchangeDN      |
 |parse_allExchange_uni.pl   ||a test of unicode format    |
-|parse_bes.pl               ||set bes to '1' where legacyDN  |
+|parse_bes.pl               ||set bes to '1' where legacyDN=  |
-|parse_disabled.pl          ||Last AD logon time (64-bit 100ns since 1/1/1601 format) |
+|parse_disabled.pl          ||set disabled to '1' where DN= |
-|parse_id.pl                ||Home Mailbox Database for all Exchange users  |
+|parse_id.pl                ||set logon ID where DN= |
-|parse_lastExchangeLogon.pl ||Size&Server info for all Exchange users  |
+|parse_lastExchangeLogon.pl || |
-|parse_lastLogon.pl         ||Server is hardcoded right now, need to fix this one up ||
+|parse_lastLogon.pl         || |
-|parse_mailboxes.pl         ||Kicks off all the other scripts  |
+|parse_mailboxes.pl         || |
-|parse_ou.pl                ||Kicks off all the other scripts  |
+|parse_ou.pl                || |
-|parse_quota.pl             ||Kicks off all the other scripts  |
+|parse_quota.pl             || |
-|parse_samid.pl             ||Kicks off all the other scripts  |
+|parse_samid.pl             || |
-|sort_files.pl              ||Kicks off all the other scripts  |
+|sort_files.pl              || |
-|unicode.pl                 ||Kicks off all the other scripts  |
+|unicode.pl                 || |
 ===== Database Refresh =====
@@ Line 115: / Line 115: @@
 Some very useful reporting queries are on the **[[exchange:reporting_project:database_queries|Useful Queries]]** page.
+====== OpenRPT Notes ======
+To allow OpenRPT to save reports to the database:
+<code>
+create table report (  report_id serial primary key,  report_name text,  report_descrip text,  report_grade integer not null, report_source text  );
+</code>
+Also need to check out:
+http://www.eclipse.org/birt/phoenix/intro/
+http://oreports.com/
+http://www.pentaho.com/
+http://www.jaspersoft.com/ - http://jasperforge.org/
+Setup for datavision - copy mysql connector J .jar file into lib directory, setup connection like:
+{{:exchange:reporting:datavision_connection_info.png|}}

..., etc.

User Tools

Site Tools

Differences

Page Tools