SQL Server Activity monitoring of user login

[Former Member]

Hi Gurus,

I'm having user login table in sql database that having login ID and password, users are login using browser with my IIS Server, now I want to check who is login ?

Thanks in advance

Gokul

[Former Member]

Hello Gokul,

Did try store procedures sp_who and sp_who2?

BR,

SAPFan

[Former Member]

Hi SAPFan,

thanks for your replay but its shows login is 'sa', sa is a default login user what we have already configured in web.config file for the connection of database, I want to know who was login in portal, all login user id are in login table of database

Thanks

Gokul

[Former Member]

Hello Gokul,

Did you mean SAP Portal ? If yes please check as follow:

SAP NetWeaver Administrator-> Monitoring ->Session Monitoring

You might also be interested noten which describes activity report:

998653 - Central Note for the Portal Activity Report

BR,

SAPFan