Hi,

I generated the report of inactive users and I want to generate the inactive users - access report. 

I tried using the select likelist=xyz & report scope=xyz(xyz - refers to previous step users list) but unfortunately the report is showing different class, profiles and access. 

It will be great helpful if someone guide me to generate the desired report. 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi,

I generated the report of inactive users and I want to generate the inactive users - access report. 

I tried using the select likelist=xyz & report scope=xyz(xyz - refers to previous step users list) but unfortunately the report is showing different class, profiles and access. 

It will be great helpful if someone guide me to generate the desired report. 

Regards

Madhukar

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi,

I generated the report of inactive users and I want to generate the inactive users - access report. 

I tried using the select likelist=xyz & report scope=xyz(xyz - refers to previous step users list) but unfortunately the report is showing different class, profiles and access. 

It will be great helpful if someone guide me to generate the desired report. 

Regards

Madhukar

Hi Madhukar,

You have three queries there, two of TYPE=RACF and a scope report. 

Since you did not specify a REPORT_SCOPE layout yourself, I take it SCKRCARL(CKRRSCOP) will be embedded there.
(You should be able to see that in SYSPRINT.)

Assuming you don't have an ID XYZ in your database, I take it the REPORT SCOPE=XYZ cannot produce any output.

===

If you are looking to run a scope report in a second pass, I think you are looking for something more like this:

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "REPORT ,"

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST "SCOPE="| KEY(0) ","

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "SCOPE=XYZ"     /* need to put something to close command... */

Since this does not specify a REPORT_SCOPE layout, the CKRRSCOP default one will be used.
If you want to define your own N TYPE=REPORT_SCOPE layout, you need to include that in the input before the REPORT statement.

I hope this begins to help.

Regards,

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi,

I generated the report of inactive users and I want to generate the inactive users - access report. 

I tried using the select likelist=xyz & report scope=xyz(xyz - refers to previous step users list) but unfortunately the report is showing different class, profiles and access. 

It will be great helpful if someone guide me to generate the desired report. 

Regards

Madhukar

Hi Madhukar,

You have three queries there, two of TYPE=RACF and a scope report. 

Since you did not specify a REPORT_SCOPE layout yourself, I take it SCKRCARL(CKRRSCOP) will be embedded there.
(You should be able to see that in SYSPRINT.)

Assuming you don't have an ID XYZ in your database, I take it the REPORT SCOPE=XYZ cannot produce any output.

===

If you are looking to run a scope report in a second pass, I think you are looking for something more like this:

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "REPORT ,"

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST "SCOPE="| KEY(0) ","

N TYPE=SYSTEM OUTLIM=1 DD=CKR2PASS
SORTLIST "SCOPE=XYZ"     /* need to put something to close command... */

Since this does not specify a REPORT_SCOPE layout, the CKRRSCOP default one will be used.
If you want to define your own N TYPE=REPORT_SCOPE layout, you need to include that in the input before the REPORT statement.

I hope this begins to help.

Regards,

Hi Jeroen,

sorry for the confusion.

My code: it generates the report of inactive users: 

N TYPE=RACF NAME=XYZ DD=CKR2PASS 

S S=BASE C=USER PASSINT_EFFECTIVE<>255 LJDATE<TODAY-90 

SORTLIST KEY

N TYPE=RACF NAME=ABC1 DD=CKR2PASS 

SELECT LIKLIST=XYZ 

SORTLIST CLASS KEY 

REPORT SCOPE=XYZ 

Instead of manually providing the list of users in SCOPE, whether I can code with complete list of users? 

Regards

Madhukar

Hi Madhukar,

It is not entirely clear to me what you are referring to exactly.

LIKELIST copies a SELECT clause, but that requires the report to be of the same type, and I am guessing the earlier report is not a REPORT_SCOPE one.

SCOPE= expects an ID, not a clause.

So you might be looking to generate SCOPE=id1 SCOPE=id2 etc.

Regards,

Hi,

I generated the report of inactive users and I want to generate the inactive users - access report. 

I tried using the select likelist=xyz & report scope=xyz(xyz - refers to previous step users list) but unfortunately the report is showing different class, profiles and access. 

It will be great helpful if someone guide me to generate the desired report. 

Regards

Madhukar