This shows you the differences between two versions of the page.
| 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|}} | ||
| + | |||