EVDashboard bug?
Updated: 03 Jul 2011 | 6 comments
This issue has been solved. See solution.
EVDashboard VBScript contains this snippet:
strSQLQuery1 = "SELECT MbxDisplayName AS 'Mailbox'," & _
"ExchangeComputer AS 'ExchangeServer'," & _
"MbxItemCount AS 'NumItemsMailbox'," & _
"MbxSize/1024 AS 'MailboxSizeMB'," & _
"MbxExchangeState AS 'ExchangeState'," & _
"DefaultVaultID AS 'DefaultVaultID'," & _
"ComputerNameAlternate AS 'EVServer'," & _
"SQLServer AS 'DBServer'," & _
"DatabaseDSN AS 'EVDatabase' " & _
"FROM " & _
"EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry AS EME," & _
"EnterpriseVaultDirectory.dbo.ExchangeServerEntry AS ESE, " & _
"EnterpriseVaultDirectory.dbo.Archive AS EA, " & _
"EnterpriseVaultDirectory.dbo.VaultStoreEntry AS EVSE," & _
"EnterpriseVaultDirectory.dbo.ComputerEntry AS ECE " & _
"WHERE " & _
"EME.MbxArchivingState = 1 AND " & _
"EME.ExchangeServerIdentity = ESE.ExchangeServerIdentity AND " & _
"EME.MbxDisplayname = EA.ArchiveName AND " & _
"EA.VaultStoreEntryId = EVSE.VaultStoreEntryId AND " & _
"EVSE.VaultStoreEntryId = ECE.DefVaultStoreEntryID " & _
"ORDER BY Mailbox"
But there is no column in the dbo.ExchangeMailboxEntry named ExchangeServerIdentity
So the VBScript fails right there.
Discussion Filed Under:
Comments
BTW it is the
BTW it is the Inc_Enabled_Maiboxes.vbs file that has this line.
The other VBS files have a pre-9.0 and 9.0 and newer IF THEN constructs to avoid this bug.
(in the other VBS files if version is > 9.0, this string is used instead - EMS.ExchangeServerIdentity = ESE.ExchangeServerIdentity)
Andrey, EV Dashboard isn't a
Andrey,
EV Dashboard isn't a Symantec product, you should probably ping JPRKnight directly.
https://www-secure.symantec.com/connect/user/jprkn...
Regards,
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Hehe, I figured, but I saw
Hehe, I figured, but I saw other EVdashboard threads here, so I thought someone here would pay attention :)
Yeah, no worries. You just
Yeah, no worries. You just never know how active he might be but if you send him an email from his contact page he might respond sooner. :)
Tony Sterling
www.bluesource.net or www.bluesource.co.uk
Offices in the US and the UK
Yeah so that query was good
Yeah so that query was good for EV8 an since ev9 it changed for exchange 2010
It should be
FROM ExchangeMailboxEntry EME,
ExchangeMailboxStore EMS,
ExchangeServerEntry ESE
WHERE EME.MbxStoreIdentity = EMS.mbxStoreIdentity
AND EMS.ExchangeServerIdentity = ESE. ExchangeServerIdentity
Yep, I looked up the
Yep, I looked up the equivalent queries in the other Inclusion VBS files earlier today and figured out the difference. Thanks for confirming.
Some of the other VBS files actually have a separate If then statement to compensate for the EV 9.0 changes, but the main VBS files doesn't. Go figure.
Now the whole thing is working better, except it is tripping over the Organisation_Archiving_History, it times out while connecting to SQL for some reason. I obviously don't have any SQL connection issues because other parts of the VBScript work well.
So for now I went to the EVDashboard_Data_Collector.vbs and removed the line that calls the inc_Organisation_Archiving_History.vbs
Would you like to reply?
Login or Register to post your comment.