asked on

AD Schema - Exchange Protocol Fields

Hi,

I want to run an LDAP query (via Crystal Reports) against AD to determine what Protocols are enabled (OWA, POP3, IMAP4) for each user. These fields appear on the "Excahnge Features" page. I used the AD schema tool to locate the field that contains this data, and it looks like it falls under msExchProtocolCfgHTTPContainer, but I can't figure out the LDAP field name.

Thanks in advance!
- Louie

strongline

it's called ProtocolSettings

ASKER CERTIFIED SOLUTION

strongline

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

attack3

ASKER

Strongline - thanks!
I read the article @ the URL you sent. I guess I need to parse the result set, or something. Here's the query I'm runnign from within Crystal (generic values substitued e.g. "x, y, z" for clarity):

Select displayName, department, ProtocolSettings
from 'LDAP://DC=losangeles,DC=w,DC=x,DC=y, DC=z'
WHERE objectCategory='user'
AND department='aa'
OR department='bb'

The report pulls the names, etc. beautifully. But the Protocol Settings field keeps returning blank values. I know this is outside the scope of my original question, but can you shed some light?

Thanks!

- Louie

strongline

I am not entirely sure - but you might have to manually change the protocol setting in ADUC to have this attribute populated.

ryangorman

The protocolSettings field is difficult because disabling and then enabling a protocol does not return the protocolSettings field to the original contents. The effect is the same but the content differs. An empty protocolSettings attribute indicates that the defaults are in force and that OWA, POP3 and IMAP4 are allowed.

See [1]

[1] https://www.experts-exchange.com/questions/22143272/I-want-a-script-that-tell-me-wich-user-have-the-OWA-enabled.html

SOLUTION

MATTHEW_L

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

attack3

ASKER

Thanks for all the advice guys!

I'm going to dig a little deeper. My user account, for instance, only has OWA enabled i.e. POP3 and IMAP4 are disabled. Based on what ryangorman said, I would think that would be a value other than NULL. I'm going to try dumping the data into a text file to see if Crystal is doing something funky. I'll post an update either way.

Thanks again,
- Louie

MATTHEW_L

You should expect to see something like the following for that:

HTTP§1§1§§§§§§
IMAP4§0§1§4§ISO-8859-1§0§1§0§0
POP3§0§1§4§ISO-8859-1§0§§§

attack3

ASKER

Matthew,
Yeah, I saw that referenced in an MS KB article. I going to do a CSVDE dump to confirm the data. I may have to come up with a workaround if I can't get Crystal to play nice.

Thanks!

MATTHEW_L

Also a good way to view this stuff is with ADSIedit.

http://www.microsoft.com/downloads/details.aspx?familyid=49AE8576-9BB9-4126-9761-BA8011FABF38&displaylang=en

attack3

ASKER

All,
Here's the latest, I found out what the problem is (I think). Crystal uses TSQL to run it's queries. Apparently there's a problem with multivalue returns (I ran across this article - http://www.dbforums.com/t999924.html ). I guess I'm going to have to extract the data as text, and pump it into an SQL table in order to use Crystal (for consistency).

If anyone has a better idea, I'm open to suggestions.

- Louie