Epicor - Admin Console Sessions

Kinetic ERP
1

Hi there, I need to know that if the Admin Console User Sessions are being saved in any of the Epicor Table. This is because, I need to make a Dashboard, to capture those users who are opening Multi Session specially from multiple computers,

2

[Ice].[SessionState]
Check the above table it will show you all active sessions, SessionType column will give you the idea of the same.

1 Like
3

I have checked this table already,
SessionType shows strings like: 00000003-C071-4FD8-900D-F58EE96BBCCE
Also, there are more entries in this table then the actual sessions in admin console.

Thanks

4

You might have better luck using the IIS logs for this

5

I’m giving this a bump because I have the same question and hoping someone might have a little more information.

The ice.SessionState table doesn’t hold all the same information that is displayed in the Admin Console ‘Sessions’ list. It seems to be only part of the picture.

Does anyone know if the Last Used Date/Time and Client Computer for each session is stored in another database table?

6

Skip the table and use the business object or the service: Ice.BO.AdminSessionSvc.

      {
        "LicNum": 0,
        "SessionID": "cec88a88-83ac-47d5-8cb7-75d5b3434373",
        "CurUserID": "mwonsil",
        "LastDate": "2022-09-30T15:38:00Z",
        "CurComp": "PTI",
        "SessionType": "00000003-b615-4300-957b-34956697f040",
        "Suspended": false,
        "Suspend": false,
        "Timeout": 0,
        "ClientComputerName": "PTXXXXXXX",
        "SerialNum": 0,
        "SysRowID": "00000000-0000-0000-0000-000000000000",
        "LicenseType": "00000003-b615-4300-957b-34956697f040",
        "Expired": true,
        "UserName": "Mark Wonsil",
        "SessionTypeDescription": "DefaultUser",
        "InUse": false,
        "InstallationName": "PTI Engineered Plastics Inc",
        "RowMod": ""
      },
1 Like
7

Even better. Thanks Mark

1 Like