View Single Post
  (#534 (permalink)) Old
hayabusa Offline
Talking BlackBerry Encyclopedia
 
hayabusa's Avatar
 
Posts: 235
Join Date: Aug 2006
Location: Kansas
Model: 8700
Carrier: Cingular
Cool Issues with BerryStats reporting and Exchange 2007 - 05-12-2008, 12:50 PM

It looks like the sql view in berrystats will not poll the entire exchange server name from the serverDN dir. In 2007 Microsoft has changed this field spacing in the DN. So the string is longer in 2007 then 2003. The string in 2007 and 2003 I have pasted below....
================================================== =====
/o=Cargill/ou=Exchange Administrative Group (FYDIBOHF23SPDLT)/cn=Configuration/cn=Servers/cn="My 2007 Exchange Server Name"/cn=Microsoft Private MDB
================================================== ======
/o=Cargill/ou=First Administrative Group/cn=Configuration/cn=Servers/cn=="My 2007 Exchange Server Name"/cn=Microsoft Private MDB
================================================== =====

In the SQL view it polls the server name by using
SUBSTRING(CAST(dbo.UserConfig.ServerDN AS varchar(100)), PATINDEX('%Servers/cn=%',
dbo.UserConfig.ServerDN) + 11, PATINDEX('%/cn=Microsoft%', dbo.UserConfig.ServerDN) - (PATINDEX('%Servers/cn=%', dbo.UserConfig.ServerDN)
+ 11)) AS ExchServer

Going forward with exchange 2007 you will not be able to use this because the spacing is different on the server DN.
Berrystats only polls the first 7 digits and does not give you the entire exchange server name for that field.

If anyone has worked on this please let me know.

Last edited by hayabusa : 05-12-2008 at 12:51 PM.
   
Reply With Quote