Intrepid explorer

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

Accepted Solutions
Intrepid explorer

Re: Update login account

Jump to 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

4 Replies
Shining star

Re: Update login account

Jump to solution

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
Intrepid explorer

Re: Update login account

Jump to solution

Hello,

With work I mean their reports and views.

Regards

 

Frank

Shining star

Re: Update login account

Jump to solution

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.
Intrepid explorer

Re: Update login account

Jump to 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