List of PSA Tables

[former_member205400]

Team,

I need a list of PSA tables to make sure I am "getting them all" in my PSA maintenance delete routine and this is what I am seeing:

In table RSTSODS I can get them all if I exclude these userapp types:

'FASTSTORE','ERRORSTACK','ORPHANED','CHANGELOG'

This leaves rows with 'NEW_DS' and ' ' in the results.

I'm seeing '/BIC/B' and '/BIC/B' in both the odsname and odsname_tech field and a valid entry in the userobj field and 'NEW_DS' in the userapp field. Looks like these are maybe 7.0 objects.

When I see blanks in the userobj and blanks in the userapp field the odsname is recognizable like '0country_text_pb'. This looks like a it is a 7.0 object.

Is there some SE38 report I can run that updates the userobj field with the odsname or updates the odsname with the userobj field?

That would make the table complete and accurate.

Mike

[former_member205400]

OK ... so here I just used the sql decode function to give me 1 field .... if the userobj field is blank, use the odsname.

Closing action