Hi, I need to pull in the last login information in about 450 systems to identify which servers are in use and which are not. How do you propose I do it. Any thoughts?

[former_member210892]

Hi, I need to pull in the last login information in about 450 systems to identify which servers are in use and which are not. How do you propose I do it. Any thoughts?

[Former Member]

Do you have any central monitoring in place or would you have to access all systems independently? 450 systems, really? Meaning SID1, SID2, etc. or instances SYSNR1, SYSNR2, etc? If systems, table USR02 field TRDAT has the last login date. If you want to know which instances are being used to logon to a system, I think you will have to go with statistics but then all systems would have to be properly configured (collector running). Are all systems ABAP systems? What versions?

[former_member210892]

Yeah around 450 systems. At this moment, we dont have a central system in place. so I cant go into the parent system and pull the data from all child systems. I need to be able to access all system's rsusr02 of all systems from one system and run my code in it. Any ideas?

[Former Member]

Do all systems have the same type of database? If yes, what database? You could look into writing a script to connect to all 450 databases remotely and retrieving the contents of USR02 (only the last entry, sorted by TRDAT descending). You will need a list of all databases (server name and SID) to be able to write such a script. Authentication is another issue, with Windows/SQL Server Windows authentication can be used.

[ACE-SAP]

Hi

Samuli's method is good.

I had to create such a script for querying the client status (T000) of many systems. It was with Oracle DB, I create a shell script that loops on the system list (SID, hostname and sap user password) and for each exec an sql script... using some nice feature of sqlplus... like the spool in append mode.

Best regards