- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: Update login account
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Frank,
Can you please elaborate on what work you mean?
Best regards,
Markward
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
With work I mean their reports and views.
Regards
Frank
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
