cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Update login account

Jump to solution

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

1 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

View solution in original post

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

4 Replies
mfranz
Level 16 Champion
Level 16 Champion

Hi Frank,

Can you please elaborate on what work you mean?

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos

Hello,

With work I mean their reports and views.

Regards

 

Frank

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

Softline Group is Europe's leading independent expert in Software Asset Management.

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