• State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 3113 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Web Designer: How to create AD group membership overview?

IDManagement
over 6 years ago

Hi Everyone,

 

I'm going to create new recertification for service accounts from AD, but don't know how to implement following requirements:

1. Show all memberships of each service account in a table view

2. Place this table view in a button, for example that managers can view memberships on demand.

Thanks in advance!

  • 0 over 6 years ago
    seems like i faced trouble with filtering ADSAccount in Initializer

    following statement works fine:
    SqlCompare("uid_adsaccount", "d2b5825b-e7e0-4ba8-8470-8551c6bfe3c4", "string", "like")

    But I need to insert current uid_adsaccount for each table row instead of "d2b5825b-e7e0-4ba8-8470-8551c6bfe3c4", which represents static account.
  • 0 over 6 years ago
    select 1 from (select uid_adsaccount from adsaccout where uid_person ='%useruid%')

    This will return first uid_adsaccount. In case person has more than one AD account add some additional conditions to get the right one
  • 0 over 6 years ago

    Thanks, but this select returns the same results:
    service account - all AD groups.
    Is there a way to make something like this:
    select 1 from (select current uid_adsaccount from adsaccount)

    To clarify my task: I need to see an account with all assigned groups, like Account MemberOf in ActiveDirectory.