Extract Manager field from Exchange server 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to extract Manager field from Exchange server using VB 6, and put data to SQL 2000. The data we got out from that Manager field is something like this: "cn=WhiteL,cn=Recipients,ou=Operations Office,o=TSI Corporation."

"White" is the last name of my manager. So in Outlook address book, if I check the property of my own email address, click the Organization tab, I would see White, Larry K. (full name) and "WhiteLK" (networkID or Alias) as my manager. I also see "WhiteLK" if I check my manager's Outlook property under Alias.

The question is why the data I extract contains "WhiteL" and in Outlook, it shows "WhiteLK"? Are there any way I can extract the right networkID, "WhiteLK"?
 
Manager is an AddressEntry object and you are getting the Exchange
distinguished name from the AddressEntry. See if it works better for what
you want if you use Manager.Name.




phamtasmic said:
I tried to extract Manager field from Exchange server using VB 6, and put
Click to expand...
data to SQL 2000. The data we got out from that Manager field is something
like this: "cn=WhiteL,cn=Recipients,ou=Operations Office,o=TSI Corporation."
"White" is the last name of my manager. So in Outlook address book, if I
Click to expand...
check the property of my own email address, click the Organization tab, I
would see White, Larry K. (full name) and "WhiteLK" (networkID or Alias) as
my manager. I also see "WhiteLK" if I check my manager's Outlook property
under Alias.
The question is why the data I extract contains "WhiteL" and in Outlook,
Click to expand...
it shows "WhiteLK"? Are there any way I can extract the right networkID,
"WhiteLK"?
 
Ken,

Thanks for responding. I guess I was not clear in my previous email. I use a SQL Select statement to get this data from Exchange using VB 6. That is where I use "SELECT Manager, etc..." to get the Manager column. The data I got from it will be loaded into a SQL table to be used by other applications. I don't know if Manager.Name would work in the SELECT statement but I can try.
 
You might have to use the MAPI property tag for that in a SQL statement
using DAV syntax instead of using an Outlook property name.

Are you using an ODBC connection? If so you might not be able to get what
you want, from a contact item the ODBC connection only returns about 44 of a
contact's fields instead of all of them and some of the field names provided
aren't the same as the Outlook property names.




phamtasmic said:
Ken,

Thanks for responding. I guess I was not clear in my previous email. I
Click to expand...
use a SQL Select statement to get this data from Exchange using VB 6. That
is where I use "SELECT Manager, etc..." to get the Manager column. The data
I got from it will be loaded into a SQL table to be used by other
applications. I don't know if Manager.Name would work in the SELECT
statement but I can try.
 
Back
Top