Report of all transports imported to production by a username

[Former Member]

Internal audit is looking for a report of all transport requests imported into production by a user to verify proper segregation of duties. I can't see mthing like this in STMS. Anyone come accross a report that will do this?

[Former Member]

Hi

I would try to run SE16 have a look at E070 and E071 tables. In SE16 screen you have the option to filter on several conditions such as user name, date, etc...

We also had this issue and we ended up writing a customer report for this.

Cheers

Edited by: BearCheese on Nov 17, 2008 10:48 PM

[Former Member]

I took a look thru these tables and couldn't find a way to see what user actually did the import of a transport request from TST to PRD. I can manually do a search of the SLOG*.PRD files, get an import data, and then look in the E070 table to find the transport that was imported at that data.

This gets me the info I need, but is very ugly. Anybody know a better way to do this?

[ps0907]

In STMS, you can select the PRD queue and then select Import History. Once you are on the history page, you can select Edit -> Display More to include the user-id that performed the transport.