Active Directory Users with Local Password

Provides a list of Active Directory users who are using local password to access AVEVA Mobile Operator. If you want the users to use the Active Directory credentials, then run the following scripts manually.

UPDATE ISMGT_User SET IsLocalPasswordSet=0, PasswordHash='', PasswordSalt='',UpdatedOn = SYSDATETIMEOFFSET(),UpdatedBy = '76E6022E-2DE2-485D-8E99-2AA67B3CCEE7' WHERE USER_PK in ('<User Primary key1>,'<User Primary Key2>')