|
Problems with Berrystats reportin in 2007 -
05-12-2008, 12:53 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.
|