How To Verify If The Admin Or Any User Is Active In The Tenant?

News Knowledge Base
1

How to verify if the Admin or any user is active in the Tenant?

Issue Description: In few scenarios, when trying to provide a role to the user or add the user to a folder, error "User not found" is thrown, though, the user is present in the UI of the Orchestrator.

Resolution:

  1. Verify in which Tenant the issue is.
  • (Select * from dbo.Tenants) - would provide all the Tenant list.

  1. Capture the ID of the tenant and query below:
  • Select * from dbo.Users table where Tenant ID=IDFetched and Username='Admin' (Example)

  1. In the output result, capture the value from the column - "Key"

  1. Queries in the identity.AspNetUsers with the following key.
  • (Select * from identity.AspNetUsers where Id = KeyFetched

  1. From the output, verify the isDeleted Column

  1. If the isDeleted Column = 1 then alter to make the isDeletedColumn=0
  • (update identity.AspNetUsers set isDeleted=1 where Id =KeyFetched

  1. Post the above steps, it should be possible to add the user to a folder or update any role.