Trick for producing a list of users and the transactions they have accessed

Describes how to produce a list of SAP users and their transactions to increase Basis administration productivity.

Giovanni Davila

Published: 16 Jan 2006

How can I produce a list of users and the transactions they have accessed for the past month? Is there any tool apart from turning the audit log on?

Without using SM19 and SM20 to turn auditing on and analyzing the audit logs, you basically have one option: ST03N. In ST03N you can use the User Profile under the Analysis Views section.

Just keep in mind that ST03N keeps limited data and it might not help you to go back one full month. Check the configuration parameters by switching to "Expert Mode" and looking under "Collector and Performance DB," "Statistics Records and Files".

Dig Deeper on SAP Basis

On The Spot: Mario Linkies on SAP security This month Mario Linkies answers all of your SAP security questions.

Listing TCODE transactions used to view what users are logged in to SAP Does an authorization code exist to collect a list of all TCODEs and users logged in to SAP during a time period?

SAP security audit log setup In this tip our upgrade/migration expert, Bert Vanstechelman, provides unorthodox uses for the Security Audit Log. Learn how to install this tool and use it to report resources necessary for the companies next upgrade and weigh transaction efforts.

Verifying which ABAP programs are in use Bert Vanstechelman addresses how to determine ABAP program usage.

Go-Live check Confused about the various checkpoints before and after a Go-Live? This handy tip walks you through the typical process so you know what to expect.

2. How do you set up and use system auditing of transactions? Learn the response to the second question in SearchSAP.com's exclusive security quiz. Read the answer and more detailed information.

Related Q&A from Giovanni Davila

SAP Basis best practices for transferring a client from one server to another

Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading

SAP transport management fundamentals

Learn fundamentals of transport management and STMS from Basis guru Giovanni Davila in this expert tip. Continue Reading

Copy from the production system to the development system

Giovanni Davila, Basis expert, provides advice on how to copy all SAP users from one system to another in this tip. Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

RPA in manufacturing increases efficiency, reduces costs

In this Q&A, Shibaji Das of UiPath discusses why manufacturers should implement RPA to improve efficiency, help with ERP system ...

A look inside the new Redwood Oracle UI design

The two designers who head Oracle's Redwood user experience and branding effort explain the philosophy behind the new look and ...

Process mining software pulls back curtains on how processes work

Here's what two vendors, Celonis and Signavio, offer in the emerging field of process mining software, which enables ...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Amazon Managed Apache Cassandra Service stokes competition

Vendors in the open source Cassandra NoSQL database market voice their concerns about AWS' entry into the field, as the cloud ...

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

SearchAWS

Prepare for an AWS outage with these preventative steps

Set up the proper data protection and recovery measures before a cloud outage hits. Follow these backup and disaster recovery ...

AWS seeks niche in the cloud UC market

AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.

National Australia Bank cashes in on AWS training and certification

Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

There's no such thing as a data science unicorn, U.S. government experts caution. You'll need more than programmers and technical...

Tableau 2020.1 unveiled for beta testing

Featuring improvements to Explain Data, an AI product that aims to explain the reasons behind data points, the update is made up ...

Data scientist vs. data analyst: What's the difference?

Data scientists and data analysts have a lot of crossover in their roles, but they're certainly not the same. Here's a look at ...

SearchContentManagement

DNA as a content storage device is closer than you think

Storing content in DNA may one day be possible, but today, it's neither practical nor cost-effective. Here's where this ...

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

SearchHRSoftware

US Army HR expects migration to Azure cloud will cut IT costs

The U.S. Army civilian HR operations is hoping for lower operational costs and improved services with a shift to the Microsoft ...

H-1B lottery change may drive increase in visa applicants

The U.S. is launching an H-1B electronic registration system in March. It should make the process of applying for a visa easier, ...

Fight the skills gap with a great upskilling and reskilling strategy

Just say 'no' to a skills gap and high turnover with upskilling and reskilling. Here's a look at the ins and outs of these ...

Trick for producing a list of users and the transactions they have accessed

Describes how to produce a list of SAP users and their transactions to increase Basis administration productivity.

Dig Deeper on SAP Basis

Related Q&A from Giovanni Davila

SAP Basis best practices for transferring a client from one server to another

SAP transport management fundamentals

Copy from the production system to the development system

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

RPA in manufacturing increases efficiency, reduces costs

A look inside the new Redwood Oracle UI design

Process mining software pulls back curtains on how processes work

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

Oracle Autonomous Database features free DBAs from routine tasks

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

SearchDataManagement

Amazon Managed Apache Cassandra Service stokes competition

Aerospike 4.8 advances database persistent memory support

Data warehouse technologies evolve as vendors look skyward

SearchAWS

Prepare for an AWS outage with these preventative steps

AWS seeks niche in the cloud UC market

National Australia Bank cashes in on AWS training and certification

SearchBusinessAnalytics

Government IT pros: Hiring data scientists isn't an exact science

Tableau 2020.1 unveiled for beta testing

Data scientist vs. data analyst: What's the difference?

SearchContentManagement

DNA as a content storage device is closer than you think

Acquia acquisition of AgilOne CDP signals CX platform expansion

Personalization engines help engage and retain customers

SearchHRSoftware

US Army HR expects migration to Azure cloud will cut IT costs

H-1B lottery change may drive increase in visa applicants

Fight the skills gap with a great upskilling and reskilling strategy

Dig Deeper on SAP Basis

Related Q&A from Giovanni Davila

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.