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
attack3Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stronglineCommented:
it's called ProtocolSettings
0
stronglineCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
attack3Author Commented:
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
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

stronglineCommented:
I am not entirely sure - but you might have to manually change the protocol setting in ADUC to have this attribute populated.
0
ryangormanCommented:
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] http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/Q_22143272.html
0
MATTHEW_LCommented:
This may also be hlepful for you.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Q_22450744.html

You can try selectivly enabling and disabling each protocol so you can see exactly what gets changed in the protocolsettings attribute.  It is essentailly null for all enabled default, or specific keywords for each protocol with either a 0 or a 1 to show enabled / disabled status.
0
attack3Author Commented:
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
0
MATTHEW_LCommented:
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§§§
0
attack3Author Commented:
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!
0
MATTHEW_LCommented:
0
attack3Author Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.