• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 895
  • Last Modified:

Searching using Custom Attributes in AD

Hi

We are running Exchange 2007/ 2010 and AD 2003.

On our mailboxes and Distribution Groups, we use Custom Attributes to mark which Cost Center the object belongs to for billing purposes. For the sake of this example, the extension attribute 1 marks the Cost Center (Marketing, Corporate, etc).

I need to pull:

1. A list of all mailboxes belonging to Marketing

2. A list of all Distribution Lists belonging to Marketing

3. A list of all mailboxes with the name SMITH belonging to Marketing

4. A list of all DL's containing the word CORPORATE that belong to Marketing

Does anyone know how I can do this, using either the Exchange Management Shell or Quest Powershell?
0
neil4933
Asked:
neil4933
1 Solution
 
abhijitwaikarCommented:
0
 
Ian MeredithCommented:
Here's your starting point....  being able to mass export mailboxes.

http://www.stevieg.org/2010/07/using-the-exchange-2010-sp1-mailbox-export-features-for-mass-exports-to-pst/

Once you have the right command you will be able to insert your filtering string to get the required result.


This should help with your distribution lists

http://www.networksteve.com/exchange/topic.php/Powershell_command_to_list_all_distribution_groups_and_members_o/?TopicId=3657&Posts=11


Here is the breakdown on the command  Get-DistributionGroup

http://technet.microsoft.com/en-us/library/bb124755.aspx

Here is the breakdown on the command New-MailboxExportRequest

http://technet.microsoft.com/en-us/library/ff607299.aspx


Here are the Filtering options for the above commands - Filterable Properties for the -Filter Parameter in Exchange 2007 SP1 and SP2

http://technet.microsoft.com/en-au/library/bb738155(EXCHG.80).aspx


0
 
neil4933Author Commented:
Thanks both...really I'm looking for a way to search for custom attributes using Quest?

0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
KenMcFCommented:
neil4933, you can use the -LDAPFILTER switch with the quest tools.

get-qaduser -LDAPFILTER "(extensionattribute1=VALUE)"

get-qadgroup -LDAPFILTER "(extensionattribute1=VALUE)"

0
 
neil4933Author Commented:
hi Ken

Ah, thanks...do you know how I'd use that to find the below then?
0
 
KenMcFCommented:
There are several ways you can get this information. Here is one example that should work and get what you want if I am reading you question right.


1. A list of all mailboxes belonging to Marketing

get-qaduser -ldpafilter "(extensionattribute1=Marketing)"


2. A list of all Distribution Lists belonging to Marketing

get-qadgroup -ldpafilter "(extensionattribute1=Marketing)"

3. A list of all mailboxes with the name SMITH belonging to Marketing

get-qaduser -ldpafilter "(&(sn=Smith)(extensionattribute1=Marketing))"


4. A list of all DL's containing the word CORPORATE that belong to Marketing

get-qadgroup -ldpafilter "(&(name=*corporate*)(extensionattribute1=Marketing))"
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now