EV Dashboard 0.21 available for download.

[jprknight-oldax]

Hi all,

I have just uploaded a new version of EV Dashboard to www.evdiscuss.net/download.

It includes a new Singe Instance Storage Report. Thanks go to JesusWept2 for providing the SQL query, which I have wrapped up in some ASP.

A new table needs to be created 'SISReport', within the EVDashboard database. The code to create the table is in the /sql/EVDashboard Database Creation/CreateTables.sql.

Enjoy,

Jeremy.

[trichert]

So here is my whole processing log, it just doesnt seem to be processing anything of significance ?

******************************************************
*
*  EVDashboard Data Collector - v1.2.11
*
******************************************************

2010.11.01 05:30:05: Successfully opened config.xml.
2010.11.01 05:30:05: Running in pre-online day mode.
2010.11.01 05:30:05: Loading data from config.xml.
2010.11.01 05:30:05: Creating multi-dimentional array.

*************************************************************************

2010.11.01 05:30:05: Processing Usage Report By Archive.

*************************************************************************

2010.11.01 05:30:05: Processing Disabled Users.

*************************************************************************

2010.11.01 05:30:05: Processing Over Send Limit.

*************************************************************************

2010.11.01 05:30:05: Processing Over Warning Limit.

*************************************************************************

2010.11.01 05:30:05: Processing Over Receive Limit.

*************************************************************************

2010.11.01 05:30:05: Processing SQL info.

*************************************************************************

2010.11.01 05:30:05: Processing EV Site Name.

*************************************************************************

2010.11.01 05:30:05: Processing Hourly Archiving Rates.

*************************************************************************

2010.11.01 05:30:05: Processing Organisation Archiving History.
2010.11.01 05:30:05: Processing Organisation Archiving History - EVVSExpressVaultStore_1.
2010.11.01 05:30:05: Processing Service Alerts.
2010.11.01 05:30:05: (Service Alerts) - Inserted 0 new row(s) into database.

*************************************************************************

2010.11.01 05:30:05: Processing EV Disk Info.
2010.11.01 05:30:05: (EV Disk Info) - miaev01

*************************************************************************

2010.11.01 05:30:06: Processing Exchange Disk Info.

*************************************************************************

2010.11.01 05:30:06: Processing Exchange Mailboxes.

*************************************************************************

2010.11.01 05:30:06: Processing Domain Name.
2010.11.01 05:30:07: Processing EV Server EventLogs.
2010.11.01 05:30:07: (EV Server Event Logs) miaev01

*************************************************************************

2010.11.01 05:30:15: Processing SIS Report.

*************************************************************************

2010.11.01 05:30:16: Processing Enabled Mailboxes.

*************************************************************************

2010.11.01 05:30:16: Processing Enabled Mailboxes Databases.
2010.11.01 05:30:16: Processing MSMQ Message Count Alerts.
2010.11.01 05:30:16: Finished.
2010.11.01 05:30:16: Written StartTime as 2010.11.01 05:30:05
2010.11.01 05:30:16: Written FinishTime as 2010.11.01 05:30:16

[jprknight-oldax]

Hi,

As it is running through all that in a matter of a couple of seconds the db authentication is failing somewhere. Which is what you already know I guess.

Could you update the LoggingLevel = 1 -> 3 in EVDashboard_Data_Collector.vbs; so:

LoggingLevel = 3

Then rerun the process.

This should give us the reasons why your db connections are failing.

Thanks,

Jeremy.

[jprknight-oldax]

Oh and don't worry about changing the server time. The command process will still attempt db connections during the day, just less intensive processes.

[trichert]

Log file of run is attached.

Some things work like most of the 'Exchange Reports' but none of the User archive reports have any data at all. 

[jprknight-oldax]

Unfortunately your log file does not contain any errors so not much help.

However if the Exchange reports work and have data, but the EV ones do not I think your db connection into the Enterprise Vault databases need some investigation.

Can you try the same odbc test to your EnterpriseVaultDirectory database as before? Also the same with the 'test database connectivity' within EVdashboard from the help menu?

Then post those results.

Thanks,

Jeremy.

[trichert]

Ok so i tested ODBC connectivity to EVVSExpressVaultStore_1  (the EnterpriseVaultDirectory was apparently the wrong DB) and its fine with evro_user , but if i use test connection with the exact same user inside ev dashboard i get :

Error Number -2147467259: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "EVVSExpressVaultStore_1,1433" requested by the login. The login failed.

Next step. Try telnet localhost 1433 on your SQL server.
 

[jprknight-oldax]

The telnet 1433 should tell you if you have connectivity to the Enterprise Vault databases or not.

[Field_Technical]

Hello All,

  Dashboard looks greats.  Is there a work around for use on a two node cluster?

Thanks

[Field_Technical]

Cluster is what I meant to type

[jprknight-oldax]

@ Field Technical Services

Are you seeing some issues? Can you give some details?

Thanks,

Jeremy.

[Field_Technical]

Last time I tried a install of dashboard it told me that it did not support node cluster.

Thanks

[jprknight-oldax]

Hi FTS,

Sorry for the delay in responding, Strange this message has come up, EVD is not cluster aware.

This is one of the many reasons why this is free. If it works great, if not you may have to break out a code editor like notepad++ and have a look at things.

The bulk of the work on EVD took place when I was not too busy at work in 2009. Things have changed drastically since then.

Jeremy.