ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 226618

calendar_today

Updated On:

Products

Endevor Software Change Manager (SCM)

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