This forum is closed. Thank you for your contributions.

Remove From My Forums

APPVManagement Database-Want to know which user in the Active Directory have access to the which APPV Packages

Question
0

Sign in to vote

I have three table in the APPVManagement Database

PackageGroups

PackageGroupsMembers

PackageVersions

from these tables I can know which package relate to which APPV Connection Group.I have already made two Connected groups on APPV Management Console and Assign Each Package to Group.

But I want to get the Active Directory users , which user have Access to which package ?

how can I do that ?

there is one field named as "SID" in the PackageGroupEntitlements. Is this use to Map ACtive Directory Groups ?

Tuesday, December 4, 2012 9:08 AM

Answers

1

Sign in to vote
If you have the SID you can then write a script to translate that into the user or group name - see here for an example: http://blogs.technet.com/b/heyscriptingguy/archive/2010/10/12/use-powershell-to-translate-a-user-s-sid-to-an-active-directory-account-name.aspx

Please remember to click "Mark as Answer" or "Vote as Helpful" on the post that answers your question (or click "Unmark as Answer" if a marked post does not actually answer your question). This can be beneficial to other community members reading the thread.

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Twitter: @stealthpuppy | Blog: stealthpuppy.com | The Definitive Guide to Delivering Microsoft Office with App-V
- Proposed as answer by znack Wednesday, December 5, 2012 8:22 PM
- Marked as answer by Aaron.ParkerModerator Saturday, December 8, 2012 10:09 AM
Tuesday, December 4, 2012 10:59 AM

Moderator

All replies

0

Sign in to vote

Hellom

Ontop of my head I have no idea if thats the proper table, you can reverify if this is the place within the DB schema;

http://social.technet.microsoft.com/Forums/en-US/appvdocumentation/thread/c380abe8-32c5-4fce-8cab-e3bdf6d1a2ff/

Seems right and perhaps the easiest route would be to verify?
Nicke Källén | The Knack| Twitter: @Znackattack

Tuesday, December 4, 2012 9:57 AM
1

Sign in to vote
If you have the SID you can then write a script to translate that into the user or group name - see here for an example: http://blogs.technet.com/b/heyscriptingguy/archive/2010/10/12/use-powershell-to-translate-a-user-s-sid-to-an-active-directory-account-name.aspx

Please remember to click "Mark as Answer" or "Vote as Helpful" on the post that answers your question (or click "Unmark as Answer" if a marked post does not actually answer your question). This can be beneficial to other community members reading the thread.

This forum post is my own opinion and does not necessarily reflect the opinion or view of my employer, Microsoft, its employees, or other MVPs.

Twitter: @stealthpuppy | Blog: stealthpuppy.com | The Definitive Guide to Delivering Microsoft Office with App-V
- Proposed as answer by znack Wednesday, December 5, 2012 8:22 PM
- Marked as answer by Aaron.ParkerModerator Saturday, December 8, 2012 10:09 AM
Tuesday, December 4, 2012 10:59 AM

Moderator