BohdanMohylnyi
Nintex Newbie

How i clean this table [Authorization].[OAuthSessionState]

How i clean this table and for what this table need?

[Authorization].[OAuthSessionState]

 

Labels: (2)
0 Kudos
Reply
1 Reply
khanh
Nintex Employee
Nintex Employee

Re: How i clean this table [Authorization].[OAuthSessionState]

Hi BohdanMohylnyi,

 

It sounds like the table is getting too large. Out of curiosity, can you run the following SQL query?

 

SELECT count (*) FROM [Authorization].[OAuthSessionState]
WHERE DATEDIFF(s, [CreatedUtc], SYSUTCDATETIME()) > [ExpiresInSeconds]
0 Kudos
Reply