Hi. I am using Exchange 2007. I am trying to do a specific search for users in active directory WITH email addresses that are NOT present in 14 specific groups. I want the results to show these users who are NOT in the 14 specified groups. I haven't used LDAP in a while so I'm a bit rusty but I'm open to anything that will get these users NOT in those groups and exported to a spreadsheet. THANKS!
i downloaded it and gave it a quick try. im not sure its going to give me what i need but its a nice utility. i see theres other things i could use. i hope hope to learn more when i get some real time to play with it.
thanks
Opps Sorry for previous blank post. Has anyone answered this yet because it was bugging me something rotten...until I cracked it.In the saved queries, Click Define Query and go into the advanced tab of Users,Contacts and GroupsClick Field buttonUse the User>MemberofCondition = IsnotValue must be Distinguished Name of Group....not the group nameQuickest way to get Distinguished Name of group is through ADSIEdit, unless you want to work it through and type it in of course.Repeat for each group you want to check against. Hope this helps as it worked for me. I only had to do two groups but it should be okay.
Sorry about the blank post above. Not sure if this has been solved yet, but it has been bugging me for a few days. I needed to find out which users were not members of any internet access group, so I could put them in one to gain internet access when they get back from holiday. I dont want over 8000 users ringing me on Monday saying they got no internet.When setting the check for each group do the followingUser>Memberofset the condition to IsnotValue = Distinguished Name of Group, not GroupNameIt doesnt work using GroupName but when I entered the Distinguished Name of a group I wanted to check, it worked. All you need to do is put in a condition for each of the groups you need to check the user is a member of.Hope this helps, it worked for me.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 5  Replies
Get-ADUser -LDAPFilter "(!(memberof=$group))"