Skip to main content
Nintex Community Menu Bar

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

  • July 9, 2021
  • 1 reply
  • 7 views
B
Forum|alt.badge.img+1

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

[Authorization].[OAuthSessionState]

 

    1 reply

    K
    Nintex Employee
    Forum|alt.badge.img+10
    • khanhNintex Employee
    • Nintex Employee
    • July 13, 2021

    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]
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement