Where can i know which user ID is login SAP?

[Former Member]

I have a manager ID, when I trying to login, it prompted that <b>"License error: 100000011 Cannot log on; the user is already connected to the same company"</b>. I know this message appear because of 2 login is using the manager ID. I wish to stop one of the manager login, where can i do that?

The SQL Enterprise Manager only show the computer name of the login user, it never show the SAP ID. Even thought i know which computer is connected to the database, but i do not know which ID they are using.

Please advcie, thank you.

[Former Member]

Check this post:

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19056%3Fpage%3Dlast%26x-order%3Ddate] [original link is broken] [original link is broken] [original link is broken];

Julian.

[Former Member]

Look on the computer where you installed the license server

in the installation folder

C:\Program Files\SAP\SAP Business One ServerTools\License

the file B1Upf.xml

you have the list of users, the affected licence, and an information if they are currently connected

<IsConnected>1</IsConnected>

HTH

Sebastien

[Former Member]

but even there are 2 logon using the same ID...the Upf.xml just only show once...so i still cannot identify there is how many logon using the same ID....

and even i know that is a 2 logon...where can i kick one of the login ID?

Thank for your reply...sebastian...

[Former Member]

Hi,

I don´t really know on 2005 (I think is not possible, but not 100% sure), but we tried on 2004 to do the same without success.

Regards,

Ibai Peñ

[AlexGrebennikov]

have you friends considered an opportunity to keep all the log in/off events in UDT (or independent DB) and analyze it?

[Former Member]

yes Alexey,

I have create a table, and added the following code in SBO_SP_TransactionNotification

DECLARE @usercode NVARCHAR(8)
DECLARE @lastLoginDate DATETIME
DECLARE @currentLoginDate DATETIME


IF @object_type = 12 and @transaction_type = 'U'
BEGIN
	SET @currentLoginDate = GETDATE()
	SET @usercode = (SELECT user_code FROM [OUSR] WHERE INTERNAL_K = @list_of_cols_val_tab_del)
	SET @lastLoginDate = (SELECT MAX(loginDate) FROM [@NMD_USIGN] WHERE usercode = @usercode)

	IF DATEDIFF(s, @lastLoginDate, @currentLoginDate) > 60 OR @lastLoginDate IS NULL
	BEGIN
		INSERT INTO [@USER_LOGIN] (usercode, loginDate) VALUES (@usercode, @currentLoginDate)
	END
END

[john_obrien7]

Hi Sebastien,

Can you explain why you are performing select statement on [@NMD_USIGN] to get the last login date?

Also, is this update on obj 12 triggered by the update of the last login field on OUSR when a user logs in?

Thanks,

John