Update login account

[FrankvH]

Hello,

Big part of our users getting a new windows login. I am wondering if we can update the login account without so the users dont loose their work.

Regards

Frank

[mfranz]

Hi Frank,

Can you please elaborate on what work you mean?

Best regards,

Markward

[FrankvH]

Hello,

With work I mean their reports and views.

Regards

Frank

[mfranz]

Hi Frank,

Thanks for the clarification. As you are referring to AD credentials (logins), I assume, you are running FNMS on prem? Operator logins can be found in the ComplianceOperator table. All objects related to operators (like views and reports), are linked to the ComplianceOperatorID. That means, as long as the specific row in this table is not removed and therefore the ComplianceOperatorID stays the same, you should be able to just update the field OperatorLogin with some SQL magic 🙂

Schema is <DomainFlatName>\<Login> but sou should see it in the existing data.

Best regards,

Markward

[FrankvH · Accepted solution]

Hello Markward,

Finally get around to do some test with the suggested solution. What at the end was simple.

I used the following update SQL:

update ComplianceOperator
set OperatorLogin = 'new_domain\new_login'
where OperatorLogin = 'old_domain\old_login'

We have tested this and it works.

Regards

Frank