Q: What would be your response if I asked you to modify the script in challenge #1 to output to a single file called "saplogons.txt"?
Notice that most of the time we run queries within the application. In fact, that is the recommended way to work with SAP. However, there are situations like the ones I described in this article where it is more effective and efficient to submit queries at the database or operating system level.
I strongly recommend that you work with the database very carefully. The database is the heart of SAP. Last but not least, let me tell you about my "Effortless administration" formula:
Knowledge + Scripts
-------------------------- = Effortless administration
- Giovanni's Basis FAQ
- SearchSAP.com's Basis tip archive
- Quiz: A 360 in SAP Basis
- Basis Learning Guide
- Featured Topic: All about Basis
- More checklists for Basis and other SAP topics
Overcoming Basis challenges by reaching inside the database
Basis challenge #1: Reporting logon information
Basis challenge #2: Gathering SQL Server information
Basis challenge #3: Getting system profile parameters
Review: Conclusion and more resources