Skip to content

Instantly share code, notes, and snippets.

@xximjasonxx

xximjasonxx/output.txt

Created August 28, 2023 15:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xximjasonxx/95a88375703ab4d62768e4ab0e7070a6 to your computer and use it in GitHub Desktop.
Save xximjasonxx/95a88375703ab4d62768e4ab0e7070a6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
output.txt
2023-08-28T15:40:19.076841064Z ORDER BY [t].[AccountId], [a0].[AccountTypeId], [t0].[AddressId], [u].[UtilityId], [t1].[BGAccountMapId], [t1].[BillingGroupId0], [t2].[CAPMapId], [t2].[CustomerId0], [t3].[CAPMapId], [t3].[ProductId0], [t4].[CustomerId], [t4].[CAPMapId], [t4].[CustomerId0], [t6].[AccountId], [t6].[c], [t6].[BGAccountMapId], [t6].[BillingGroupId], [t8].[CAPMapId]
2023-08-28T15:40:33.910698728Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:33.910751636Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:33.910759030Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:33.910764059Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:33.910768487Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:33.910772886Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:33.910776723Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:33.910782293Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:33.910786561Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:33.910790759Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:33.914652829Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:33.914667407Z Executed DbCommand (2ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:33.914674099Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:33.914679699Z FROM [UserDetail] AS [u]
2023-08-28T15:40:33.914684188Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:33.914688195Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:33.916662131Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:33.916674835Z Executed DbCommand (1ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:33.916680726Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:33.937938346Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:33.937981446Z Executed DbCommand (1ms) [Parameters=[@__userIdInput_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:33.937991785Z SELECT [u].[UserAccountMapId], [u].[AccountId], [u].[CreatedBy], [u].[CreatedDate], [u].[IsHidden], [u].[ModifiedBy], [u].[ModifiedDate], [u].[UserId], [u].[ValidFrom], [u].[ValidTo]
2023-08-28T15:40:33.937997817Z FROM [UserAccountMap] AS [u]
2023-08-28T15:40:33.938003267Z WHERE [u].[UserId] = @__userIdInput_0
2023-08-28T15:40:33.948773428Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:33.948802752Z Executed DbCommand (1ms) [Parameters=[@__userIdInput_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:33.948827238Z SELECT CASE
2023-08-28T15:40:33.948833369Z WHEN EXISTS (
2023-08-28T15:40:33.948838098Z SELECT 1
2023-08-28T15:40:33.948849730Z FROM [UserDetail] AS [u]
2023-08-28T15:40:33.948855310Z WHERE [u].[UserId] = @__userIdInput_0) THEN CAST(1 AS bit)
2023-08-28T15:40:33.948861932Z ELSE CAST(0 AS bit)
2023-08-28T15:40:33.948866591Z END
2023-08-28T15:40:34.127666182Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.127726914Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:34.127735561Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.127741211Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:34.127746040Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.127751330Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:34.127756309Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.127761398Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:34.127778009Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.127783349Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:34.130307766Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.130328204Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.130337170Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:34.130343743Z FROM [UserDetail] AS [u]
2023-08-28T15:40:34.130349183Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:34.130355014Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:34.131893974Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.131916486Z Executed DbCommand (1ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.131937174Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:34.139948794Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.139969002Z Executed DbCommand (5ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.139977026Z EXEC @returnValue = [dbo].[usp_Account_GetLinkedAccount] @userId
2023-08-28T15:40:34.200777399Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.200837862Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:34.200847440Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.200854442Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:34.200860173Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.200866195Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:34.200871294Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.200876614Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:34.200886542Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:34.200892223Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:34.203321001Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.203343262Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.203360204Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:34.203366315Z FROM [UserDetail] AS [u]
2023-08-28T15:40:34.203371274Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:34.203376664Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:34.206148943Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.206171225Z Executed DbCommand (2ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.206178949Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:34.212857874Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.212883582Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.212898339Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:34.212918667Z FROM [UserDetail] AS [u]
2023-08-28T15:40:34.212925369Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:34.212931030Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:34.216548862Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:34.216579739Z Executed DbCommand (2ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:34.216589357Z EXEC @returnValue = [dbo].[usp_Account_GetLinkedAccount] @userId
2023-08-28T15:40:43.808588779Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.808652828Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:43.808661264Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.808666413Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:43.808673446Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.808678696Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:43.808684226Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.808690929Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.809351333Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.809366411Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.811680843Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.811701311Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.811710097Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:43.811715037Z FROM [UserDetail] AS [u]
2023-08-28T15:40:43.811719495Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:43.811723903Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:43.815131369Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.815165533Z Executed DbCommand (1ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.815188686Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:43.816096456Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.816113408Z Executed DbCommand (1ms) [Parameters=[@__userIdInput_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.816123416Z SELECT [u].[UserAccountMapId], [u].[AccountId], [u].[CreatedBy], [u].[CreatedDate], [u].[IsHidden], [u].[ModifiedBy], [u].[ModifiedDate], [u].[UserId], [u].[ValidFrom], [u].[ValidTo]
2023-08-28T15:40:43.816128125Z FROM [UserAccountMap] AS [u]
2023-08-28T15:40:43.816130680Z WHERE [u].[UserId] = @__userIdInput_0
2023-08-28T15:40:43.817781554Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.817797894Z Executed DbCommand (1ms) [Parameters=[@__userIdInput_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.817805839Z SELECT CASE
2023-08-28T15:40:43.817811891Z WHEN EXISTS (
2023-08-28T15:40:43.817817270Z SELECT 1
2023-08-28T15:40:43.817824614Z FROM [UserDetail] AS [u]
2023-08-28T15:40:43.817830335Z WHERE [u].[UserId] = @__userIdInput_0) THEN CAST(1 AS bit)
2023-08-28T15:40:43.817837548Z ELSE CAST(0 AS bit)
2023-08-28T15:40:43.817843219Z END
2023-08-28T15:40:43.972097059Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.972182057Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:43.972194480Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.972200020Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:43.972204669Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.972209798Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:43.972214687Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.972221300Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.972238392Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.972243882Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.975592009Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.975617507Z Executed DbCommand (2ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.975626173Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:43.975631924Z FROM [UserDetail] AS [u]
2023-08-28T15:40:43.975637765Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:43.975642523Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:43.977398079Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.977417746Z Executed DbCommand (1ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.977444626Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:43.980883592Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.980906105Z IDX10242: Security token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]' has a valid signature.
2023-08-28T15:40:43.980914620Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.980920722Z IDX10239: Lifetime of the token is valid.
2023-08-28T15:40:43.980926011Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.980959233Z IDX10234: Audience Validated.Audience: 'c296cf5c-c6bb-4f5c-b191-bab5e6df52fa'
2023-08-28T15:40:43.980966687Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.980971987Z IDX10245: Creating claims identity from the validated token: '[PII of type 'System.IdentityModel.Tokens.Jwt.JwtSecurityToken' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.981381807Z info: Microsoft.IdentityModel.LoggingExtensions.IdentityLoggerAdapter[0]
2023-08-28T15:40:43.981395372Z IDX10241: Security token validated. token: '[PII of type 'System.String' is hidden. For more details, see https://aka.ms/IdentityModel/PII.]'.
2023-08-28T15:40:43.983247166Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.983268165Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.983277372Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:43.983284025Z FROM [UserDetail] AS [u]
2023-08-28T15:40:43.983289565Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:43.983304553Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:43.984210368Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.984228191Z Executed DbCommand (5ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.984234673Z EXEC @returnValue = [dbo].[usp_Account_GetLinkedAccount] @userId
2023-08-28T15:40:43.985129368Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.985145057Z Executed DbCommand (2ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.985150567Z EXEC @returnValue = [dbo].[usp_User_AuthorizationContext] @userId
2023-08-28T15:40:43.987551674Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.987571059Z Executed DbCommand (1ms) [Parameters=[@__userObjectId_0='?' (Size = 255) (DbType = AnsiString)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.987599142Z SELECT TOP(1) [u].[UserId], [u].[CreatedBy], [u].[CreatedDate], [u].[CustomerId], [u].[DisplayName], [u].[Email], [u].[FirstName], [u].[IsDeleted], [u].[IsEmailVerified], [u].[IsEnabled], [u].[IsPhoneVerified], [u].[LastName], [u].[MiddleName], [u].[ModifiedBy], [u].[ModifiedDate], [u].[ObjectId], [u].[Phone], [u].[ProfileStatus], [u].[ProfileTypeId], [u].[SignInEmailAddressIssuer], [u].[Title], [u].[UPN], [u].[UpnIssuer], [u].[UserTypeId], [p].[ProfileTypeId], [p].[CreatedBy], [p].[CreatedDate], [p].[IsDeleted], [p].[ModifiedBy], [p].[ModifiedDate], [p].[ProfileTypeDesc]
2023-08-28T15:40:43.987605003Z FROM [UserDetail] AS [u]
2023-08-28T15:40:43.987609691Z LEFT JOIN [ProfileTypeMaster] AS [p] ON [u].[ProfileTypeId] = [p].[ProfileTypeId]
2023-08-28T15:40:43.987613959Z WHERE [u].[ObjectId] = @__userObjectId_0
2023-08-28T15:40:43.989756764Z info: Microsoft.EntityFrameworkCore.Database.Command[20101]
2023-08-28T15:40:43.989778915Z Executed DbCommand (2ms) [Parameters=[userId='?' (DbType = Int64), returnValue='?' (Direction = Output) (DbType = Int32)], CommandType='Text', CommandTimeout='30']
2023-08-28T15:40:43.989786690Z EXEC @returnValue = [dbo].[usp_Account_GetLinkedAccount] @userId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment