Results 1 to 3 of 3

Thread: Finding the Email Address in OU

  1. 12-04-2006, 10:37 PM #1
    myBU
    myBU is offline Registered User
    Join Date
    May 2006
    Posts
    29

    Finding the Email Address in OU

    Hi there!

    I have exported the email addresses from exchange but I got the following :

    X400:c=US;a= ;p=Company Inc.;o=COMPANY;s=cHarold;%SMTP:cHarold@company.com %FAXMAKER:cHarold@COMPANY.CompanyInc..com

    I want to get only the cHarold@company.com , before the 'SMTP:' word. How will I go about this?

    Please help.

    Thanks a lot!

    myBU
    Reply With Quote Reply With Quote
  2. 12-05-2006, 09:36 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If you use ms sql server, patindex function may help.
    Reply With Quote Reply With Quote
  3. 12-05-2006, 01:29 PM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If it is MS Active Directory, you can write OPENROWSET query to it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules