Highlighted
Frequent Contributor.
Frequent Contributor.
134 views

extract or export or download groups and permission to excel

Hi All

I have seen some old post with a link to export the groups and permission matrix to excel. These old links no longer work. 

Anyone who can help me with a solution for this?

0 Likes
2 Replies
Highlighted
Honored Contributor.
Honored Contributor.

Re: extract or export or download groups and permission to excel

Have a look at Project Insight for ALM, which is available at the Micro Focus Marketplace.

https://marketplace.microfocus.com/appdelivery/content/qc-project-insight 

Highlighted
Regular Contributor.
Regular Contributor.

Re: extract or export or download groups and permission to excel

did you mean something like this:

 

Sub permissionMatrixForProject()

 

Dim server, domain, project, qcUserName, qcPassword, i

 

server = *qcServer*

domain = *qcDomain*

project = *qcProject*

qcUserName = *qcUserName*

qcPassword = *qcPassword*

 

Set objOTAClient = CreateObject("TDApiOle80.TDConnection")

objOTAClient.InitConnectionEx server

objOTAClient.Login qcUserName, qcPassword

objOTAClient.Connect domain, project

 

Set listCustomizationUsersGroups = objOTAClient.Customization.UsersGroups.Groups

 

i = 2

 

For Each grp In listCustomizationUsersGroups

Range("A" & i) = grp.Name

Set listUsersInGroup = grp.UsersList

For Each usr In listUsersInGroup

Range("B" & i) = usr.Name

Range("C" & i) = usr.FullName

i = i + 1

Next

i = i + 1

Next

 

End Sub

@amit_saha2511 

if you want explanation in Hebrew reach me in pm

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.