Windchill Java & JSP Change Management Reporting Tool

Change Management Reporting Tool:

GUI - JSP Page/Program:

Change Management Reporting:

PR - Problem Report
ECR - Enterprise Change Request
ECN - Enterprise Change Notice
ECA - Enterprise Change Activity
ALL Change Management Processes

FULL Depth Related
CM Processes Reporting

Sample Html Output Report: Change_Management_Reporting.htm

Sample PDF Output Report: Change_Management_Report.pdf

Java command line method & JSP to Html reporting:

Zip (with java source, classes & jsp): cmReport16.zip

Zip has folder structure as should be used to drop right into folder:

<WT_HOME>/codebase/

You should be able to unzip right into your codebase folder & it should
drop the files into the appropriate folders:

JSP: <WT_HOME>/codebase/infoengine/jsp/cust/cm/report/

<WT_HOME>/codebase/infoengine/jsp is default JSP virtual gateway folder.

Java: <WT_HOME>/codebase/cust/cm/report/

<WT_HOME>/codebase/ is default java method virtual gateway folder.

Java Command Line entry is:

java cust.cm.report.cmReport16

arguments are: -PR, -ECR, -ECN, -ECA & -ALL

-PR = Problem Reports
-ECR = Enterprise Change Requests
-ECN = Enterprise Change Notices
-ECA = Enterprise Change Activities
-ALL = All reports

No arguments = -ALL

This zip has all code (Java & JSP) without folder structuring:

cmReport16_nf.zip

=============================================================

FULL Depth Related CM Processes Reporting = allows for full change
management reporting (CM processes & related CM processes)
including such info:

Name, Number, Description, etc.

It also shows workflow info associated to each cm process reported:

Creator, Container, Name, Description, etc.

It also includes Context info:

reviewDate, submitDate, proposedSolution, etc.

It should also include Robot Expression Java output:

Name, Number, Description, etc (as shown below).

Sample Output:

PR: PR-00102 - wt_test_wtpart_ljett.prt PR28002 Name: wt_test_wtpart_ljett.prt PR Number: PR-00102 Description: wt_test_wtpart_ljett.prt PR Creator Name: Administrator Creator EMail: datajett@aol.com LifeCycle State: UNDERREVIEW Organization Name: DJ Requester: Administrator Issue Priority: LOW Category: COST_REDUCTION Workflow Creator: Administrator Container: DJ_Prod_01 Workflow Name: PR Process_PR-00102 - wt_test_wtpart_ljett.prt PR Workflow Desc: Problem Report creation, analysis, and disposition. Team Name: PR Team Context Name: reviewDate Value: null Context Name: submitDate Value: 2007-04-27 21:15:05.2 Context Name: prComments Value: null Context Name: inInitialPhase Value: false Context Name: prName Value: wt_test_wtpart_ljett.prt PR Context Name: prNumber Value: PR-00102 Context Name: prDescription Value: wt_test_wtpart_ljett.prt PR Context Name: prContainer Value: DJ_Prod_01
Related ECR:	00061 - wt_test_wtpart_ljett.prt CR28101 Name: wt_test_wtpart_ljett.prt CR Number: 00061 Description: wt_test_wtpart_ljett.prt CR Need Date: null Creator Name: Administrator Creator EMail: datajett@aol.com LifeCycle State: UNDERREVIEW Organization Name: DJ Request Priority: LOW Category: COST_REDUCTION Workflow Creator: Administrator Container: DJ_Prod_01 Workflow Name: Change Request Workflow_00061 - wt_test_wtpart_ljett.prt CR Workflow Desc: Change Request creation, analysis, and disposition. Team Name: Change Request Team Context Name: Analysis_Comments Value: null Context Name: approvalDate Value: null Context Name: submitDate Value: 2007-04-27 21:35:20.997 Context Name: proposedSolution Value: null Context Name: businessDecisionSummary Value: null Context Name: AnalyzeClarify_Comments Value: null Context Name: ReviewClarify_Comments Value: null Context Name: inInitialPhase Value: false Context Name: ecrNumber Value: 00061 Context Name: ecrDescription Value: wt_test_wtpart_ljett.prt CR Context Name: ecrName Value: wt_test_wtpart_ljett.prt CR Context Name: ecrContainer Value: DJ_Prod_01
Number of PR's: 10
************************************************************
ECR: 00103 - cm_report_tasks_NEW2 CN34304 Name: cm_report_tasks_NEW2 CR Number: 00103 Description: edit cm_report_tasks_NEW2 CR Need Date: 2007-05-28 00:00:00.0 Creator Name: Administrator Creator EMail: datajett@aol.com LifeCycle State: UNDERREVIEW Organization Name: DJ Request Priority: HIGH Category: PRODUCT_IMPROVEMENT Workflow Creator: Administrator Container: DJ_Prod_01 Workflow Name: Change Request Workflow_00103 - cm_report_tasks_NEW2 CN Workflow Desc: Change Request creation, analysis, and disposition. Team Name: Change Request Team Context Name: Analysis_Comments Value: null Context Name: approvalDate Value: null Context Name: submitDate Value: 2007-05-05 23:15:37.015 Context Name: proposedSolution Value: null Context Name: businessDecisionSummary Value: null Context Name: AnalyzeClarify_Comments Value: null Context Name: ReviewClarify_Comments Value: null Context Name: inInitialPhase Value: false Context Name: ecrNumber Value: 00103 Context Name: ecrDescription Value: edit cm_report_tasks_NEW2 Context Name: ecrName Value: cm_report_tasks_NEW2 CN Context Name: ecrContainer Value: DJ_Prod_01
Related PR:	PR-00143 - cm_report_tasks_NEW2 PR34303 Name: cm_report_tasks_NEW2 PR Number: PR-00143 Description: cm_report_tasks_NEW2 PR Creator Name: Administrator Creator EMail: datajett@aol.com LifeCycle State: UNDERREVIEW Organization Name: DJ Requester: Administrator Issue Priority: LOW Category: COST_REDUCTION Workflow Creator: Administrator Container: DJ_Prod_01 Workflow Name: PR Process_PR-00143 - cm_report_tasks_NEW2 PR Workflow Desc: Problem Report creation, analysis, and disposition. Team Name: PR Team Context Name: reviewDate Value: null Context Name: submitDate Value: 2007-05-05 23:10:37.125 Context Name: prComments Value: null Context Name: inInitialPhase Value: false Context Name: prName Value: cm_report_tasks_NEW2 PR Context Name: prNumber Value: PR-00143 Context Name: prDescription Value: cm_report_tasks_NEW2 PR Context Name: prContainer Value: DJ_Prod_01
Related ECN:	00061 - cm_report_tasks_NEW2 CN34306 Name: cm_report_tasks_NEW2 CN Number: 00061 Description: update cm_report_tasks_NEW2 CN Need Date: 2007-05-29 00:00:00.0 Creator Name: Administrator Creator EMail: datajett@aol.com LifeCycle State: OPEN Organization Name: DJ Workflow Creator: Administrator Container: DJ_Prod_01 Workflow Name: Change Notice Workflow_00061 - cm_report_tasks_NEW2 CN Workflow Desc: Change Notice creation, implementation, and audit. Team Name: Change Notice Team Context Name: cibComments Value: null Context Name: auditComments Value: null Context Name: submitDate Value: null Context Name: approvalDate Value: null Context Name: fastTrack Value: true Context Name: amendComments Value: null Context Name: inInitialPhase Value: true Context Name: unpromotable Value: null