Need a cross reference report that shows the Endevor package name, element and element vv.ll being executed

Products

• Endevor

Issue/Introduction

Does Endevor have a report or utility that can be used to correlate the Specific version of an Element and its package information.

The information shown in element screen is misleading this is needed for a SOX audit

 

 

 

 

Environment

Release : 18.1

Component :

Resolution

The CSV report will provide the cross reference information needed. The below JCL will create a sequential file that can be used to create an excel spreadsheet and filter the data as needed. 

The JCL for the job: 

//*------------------------------------------------------------------- 
//* PACKAGE ACTION SUMMARY CSV                                               
//*------------------------------------------------------------------- 
//DELETE   EXEC PGM=IDCAMS                                             
//SYSPRINT   DD SYSOUT=*                                               
//SYSIN      DD *                                                      
  DELETE 'IPRFX.IQUAL.PKG.SUMMARY.CSV'                                 
/*                                                                     
//*------------------------------------------------------------------- 
//*   STEP 2 -- EXECUTE CSV UTILITY                                    
//*------------------------------------------------------------------- 
//STEP1    EXEC PGM=NDVRC1,REGION=4M,                                  
//         PARM='CONCALL,DDN:CONLIB,BC1PCSV0'                          
//STEPLIB  DD DISP=SHR,DSN=YOUR.ENDEVOR.SIQUAUTU                       
//         DD DISP=SHR,DSN=YOUR.ENDEVOR.CSIQAUTH                       
//CONLIB   DD DISP=SHR,DSN=YOUR.C11801.CSIQLOAD                        
//LISTPKG  DD DSN=IPRFX.IQUAL.PKG.SUMMARY.CSV,                         
//         DISP=(NEW,CATLG,DELETE),                                    
//         SPACE=(CYL,(5,50),RLSE),                                    
//         DCB=(DSORG=PS,RECFM=VB,LRECL=4092,BLKSIZE=4096)             
//C1MSGS1  DD SYSOUT=*                                                 
//BSTERR   DD SYSOUT=*                                                 
//BSTIPT01 DD *                                                        
LIST PACKAGE ACTION                                                    
TO FILE LISTPKG                                                        
FROM PACKAGE ID PACKAGENAME                                            
 .                                                                     

This Knowledge document will step thru the process to create an Excel Spreadsheet of the data. 

https://knowledge.broadcom.com/external/article?articleId=17650

Here is an example of what a filtered spreadsheet looks like for a particular package. 

PKG ID

SCL STMT#

SITE ID

ELM ACT

APPR REQ (S)

VALIDATION REQ (S)

LOC (S)

ENV NAME (S)

SYS NAME (S)

SBS NAME (S)

TYPE NAME (S)

STG # (S)

STG NAME (S)

STG ID (S)

VV.LL (S)

ELM (S)

RPJLONGNAMEPKG

1

0

GENERATE

Y

Y

C

ENV1

RPJ

RPJ

COPY

1

STG1

1

1.05

ADDBILL

RPJLONGNAMEPKG

2

0

GENERATE

Y

Y

C

ENV1

RPJ

RPJ

JANET2

1

STG1

1

1

JANET_TESTING_REVERSE

RPJLONGNAMEPKG

3

0

GENERATE

Y

Y

C

ENV1

RPJ

RPJ

RJTXT

1

STG1

1

1

Package-review#approve

RPJLONGNAMEPKG

4

0

GENERATE

Y

Y

C

ENV1

RPJ

RPJ

HFS

1

STG1

1

1

REALLYREALLYREALLYLONGFILENAME