+ Post New Thread
Results 1 to 3 of 3
Enterprise Software Thread, Exchange 2007 Opath query in Technical; Is it possible to create a custom GAL that includes all user email addresses, groups and dynamic distribution lists excluding ...
  1. #1

    Join Date
    Oct 2009
    Location
    North Yorkshire
    Posts
    28
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Unhappy Exchange 2007 Opath query

    Is it possible to create a custom GAL that includes all user email addresses, groups and dynamic distribution lists excluding any users who have their custom attribute 1 set to 'student' and also exclude any users where custom attribute 10 is set to 'headteacher'?
    I've been trying using the set-globaladdresslist recipient filter parameter in power shell but to no avail.
    I've successfully done this in LDAP but I'm unable to transpose the query into Opath.

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,270
    Thank Post
    884
    Thanked 2,747 Times in 2,321 Posts
    Blog Entries
    11
    Rep Power
    785

  3. #3

    Join Date
    Oct 2009
    Location
    North Yorkshire
    Posts
    28
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for that Synack
    I managed to convert my Global Address Lists LDAP filters to Opath following your links.
    I have since realised that even through I have set up discrete GALs for staff, students and HT and everything is fine in OWA, Outlook 2010 chooses to ignore my users' msExchQueryBaseDN values (e.g. Staff use CN=Staff GAL,CN=All Global Address Lists,CN=Address Lists Container,CN=Exchange Organization,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=laurenjac k,DC=internal) and doesn't display the correct GAL for staff (Staff GAL). However, when students open the Outlook2010 application, they do see the correct GAL (Student GAL).
    Anybody willing to check my OPATH recipient filters at all? FYI I am administering Exchange 2007?

    HeadTeacher GAL OPATH
    ( ( Alias -ne $null ) -and ( ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and -not ( Database -ne $null ) -and -not ( ServerLegacyDN -ne $null ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq'user' ) -and ( recipientType -eq 'UserMailbox' ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'contact' ) ) -or ( ObjectCategory -like 'group' ) -or ( ObjectCategory -like 'publicFolder' ) -or ( ObjectCategory -like'msExchDynamicDistributionList' ) ) -and -not ( customAttribute1 -eq 'student' ) )
    ( ( Alias -ne $null ) -and ( ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and -not ( Database -ne $null ) -and -not ( ServerLegacyDN -ne $null ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and ( recipientType -eq 'UserMailbox' ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'contact' ) ) -or ( ObjectCategory -like 'group' ) -or ( ObjectCategory -like 'publicFolder' ) -or ( ObjectCategory -like 'msExchDynamicDistributionList' ) ) -and -not ( customAttribute1 -eq 'student' ) )

    Student GAL OPATH
    ( ( customAttribute1 -eq 'student' ) -and ( ObjectClass -eq 'user' ) -and ( ObjectCategory -like 'person' ) -and ( Alias -ne $null ) -and ( ServerLegacyDN -ne $null ) )

    Staff GAL OPATH
    ( ( Alias -ne $null ) -and ( ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and -not ( Database -ne $null ) -and -not ( ServerLegacyDN -ne $null ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq'user' ) -and ( recipientType -eq 'UserMailbox' ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'contact' ) ) -or ( ObjectCategory -like 'group' ) -or ( ObjectCategory -like 'publicFolder' ) -or ( ObjectCategory -like'msExchDynamicDistributionList' ) ) -and -not ( customAttribute1 -eq 'student' ) )
    ( ( Alias -ne $null ) -and ( ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and -not ( Database -ne $null ) -and -not ( ServerLegacyDN -ne $null ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'user' ) -and ( recipientType -eq 'UserMailbox' ) ) -or ( ( ObjectCategory -like 'person' ) -and ( ObjectClass -eq 'contact' ) ) -or ( ObjectCategory -like 'group' ) -or ( ObjectCategory -like 'publicFolder' ) -or ( ObjectCategory -like 'msExchDynamicDistributionList' ) ) -and -not ( customAttribute1 -eq 'student' ) -and -not ( customAttribute10 -eq 'headteacher' ) )

    Regards
    Marty



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 18th April 2012, 03:54 PM
  2. Exchange 2007 Query RE: Mailboxes
    By 01hanstu in forum Windows
    Replies: 2
    Last Post: 20th May 2011, 11:39 AM
  3. Exchange 2007 public folders
    By everton4europe in forum How do you do....it?
    Replies: 11
    Last Post: 29th March 2008, 12:52 PM
  4. Virtual Server 2005 R2 + Exchange 2007
    By Simcfc73 in forum Windows
    Replies: 4
    Last Post: 8th February 2007, 12:04 AM
  5. Exchange 2007 Beta 2 available for download
    By Norphy in forum Windows
    Replies: 3
    Last Post: 25th July 2006, 06:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •