We have inherited an ILMT environment but it seems we do not have the correct ILMT admin credentials. We do have access to the BigFix side of things and we also have access to the ILMT (SQL) database, so we know the ILMT admin username, just not the password. Is there a procedure to reset this password to a known value, via scripts or database manipulation please?

There is no easy way to rediscover the LMT admin password.

However, you can query database for dbo.users and find the user.

Once you know the user, you can use the command below to reset the password to 'Administrator1' for user admin:

update dbo.users set "password_hash"='$2a$10$sVH.T/vAZw61VnqwKNKxSeLQYWnTsDhmfIoHXvmvGINihGHEXqH4S' , "authentication_method"='password',"authentication_backend"=NULL where "username"='admin'

Thankyou , that did the trick!

Regards

Michel