Updating user accounts in QC/ALM 11.0
Question ID: 108386
0
0

As we are planning to convert over to authenticating with the Abbott active directory, I wanted to know what technical options exist to convert existing user accounts over to how Abbott formats their user IDs. It would be cumbersome to add all the new user accounts and then add all of the permissions manually to the new user accounts. So, is there a converting tool or a script you would recommend that either converts accounts or creates a copy and converts accounts but retains all current project and project role properties?

Any help you can provide would be appreciated, then I can review those options with our Quality group.

Marked as spam
Posted by (Questions: 17, Answers: 5)
Asked on May 8, 2018 7:35 am
93 views
Answers (3)
0
Private answer

So, it sounds like you want to ''replace'' you current QC User that exists in the old LDAP server with a user (for the same person) from a NEW LDAP server.
If you happened to be able to use the same ''UserID'' in ALM as the corresponding user id in ''new'' LDAP the system, The LDAP User Import should just update the
same user entry that already exists in ALM, if you want to be super safe you should just backup the ''site admin DB'' so that if the import does not go the way
that you wants it you can just roll back and restore the old version of the site admin db. The main thing is you just need to make sure that UserID in ALM is
mapped to a value in active directory that has the same value for each user. For instance, if my username in ALM was ssingu I would need to map the UserID in
ALM to a value in Active Directory that has the same value ''ssingu'' that way ALM knows to update the existing user instead of creating a new one.

IF you cannot specify he SAME USERID in the NEW LDAP as the old one you need to add NEW users to QC that actually are the SAME as existing users, just with
different USERID's (because you have 2 different userID schemes in your 2 LDAP servers).

Like you asked there is no formal tool from HP HPE/Microfocus or a set of SQL scripts that could be used to create a copy of the current
User Names with all of their project and role assignments and then update the User Name to be reflective of the format that Abbott's active directory has rather
than the current which is the format that the SJM active directory has.

I can refer an API for ALM 11 to customize the object that can list the groups and group of the projects and their user list. Refer the section CustomizationUsersGroup Object, CustomizationUsersGroup Object Members in API document that represents a user group for purposes of adding and removing users
which is attached to the case.

We also highly recommend upgrading your ALM to the new/next level of ALM as ALM 11.0 has no support from HPE/Microfocus.

Marked as spam
Posted by (Questions: 0, Answers: 23)
Answered on May 10, 2018 10:42 am
0
Private answer

Thanks for your reply. Let me elaborate further. I am aware of being able to edit the other attributes of a user record. What I am wondering is, can I edit the User Name? Or create a copy of the users names. The situation is this. The currently installed user base is about 350 users (some access regularly and some just occasionally). That means user accounts for about 350 users. Most users are in an average of 2-3 projects. In those projects, they have an average of about 3-4 roles. So, 350 users times 2.5 projects is 875 times 3.5 roles is 3062 touches if I have to create all the new User Names manually and assign them to the same projects that the old User Names are assigned to with the same roles that the old User Names are assigned to.

Is there a tool provided by HPE/Microfocus or a set of SQL scripts that you are aware of that could be used to create a copy of the current User Names with all of their project and role assignments and then update the User Name to be reflective of the format that Abbott's active directory has rather than the current which is the format that the SJM active directory has? This could be either a copy of those accounts, then an update or possibly a straight update to the current User Names, but I want to know if there is any automated way that you have seen this done so that we can leverage it.

We cannot be the first company to want to update the User Names due to being purchased and then needing to point to a different active directory with a different ID format.

Marked as spam
Posted by (Questions: 17, Answers: 5)
Answered on May 8, 2018 4:25 pm
0
Private answer

Hi,
The ''Abbott'' active directory is just your internal active directory to your company, so it would be the same as enabling LDAP in any other environment. I believe that as long as their users have a matching user id that they map to in LDAP it should just fill in the information for that user and add it to the existing entry for that user in ALM. According to the admin guide, If the same usernames exist in the Users list, the Handle Conflict dialog box opens, then it will give you the option to update the existing user in ALM.

Marked as spam
Posted by (Questions: 0, Answers: 23)
Answered on May 8, 2018 7:55 am
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top