User Tools

Site Tools


exchange:reporting:reporting_project

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
exchange:reporting:reporting_project [2010/03/06 11:44]
ben
exchange:reporting:reporting_project [2010/04/28 05:29] (current)
ben
Line 94: Line 94:
 |parse_bes.pl ​              ||set bes to '​1'​ where legacyDN= ​ | |parse_bes.pl ​              ||set bes to '​1'​ where legacyDN= ​ |
 |parse_disabled.pl ​         ||set disabled to '​1'​ where DN= | |parse_disabled.pl ​         ||set disabled to '​1'​ where DN= |
-|parse_id.pl ​               || |+|parse_id.pl ​               ||set logon ID where DN= |
 |parse_lastExchangeLogon.pl || | |parse_lastExchangeLogon.pl || |
 |parse_lastLogon.pl ​        || | |parse_lastLogon.pl ​        || |
Line 115: Line 115:
  
 Some very useful reporting queries are on the **[[exchange:​reporting_project:​database_queries|Useful Queries]]** page. 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|}}
 +
exchange/reporting/reporting_project.1267893882.txt.gz ยท Last modified: 2010/03/06 11:44 by ben