Enterprise Vault useful SQL queries
I have worked some time on EV and due to encountering many issues which were hidden from day to day system checks we developed some interesting and useful SQL queries which when used can keep you better informed on whats going on with your EV environment This is just a sample of some of the more useful queries we use regularly
Script to know AD permission assigned on Archives/Folders
Most of time we need a script/SQL query to know permission assigned or delegated to Archives or archive folders. This information can also be found from the Vault Admin Console but it’s difficult when we have large no of archives, additionally vault admin console does not allow to make a report of permission details.
New DQL templates in Data Insight 5.1
Data Insight provides you the ability to query the data being monitored by using Data Insight Query Language (DQL). You can use canned DQL templates, and generate a report in CSV format. You can select any of the built-in queries and even modify the content to suit your specific reporting needs.EV Dashboard 0.17 available for download
Hi all, Ev Dashboard 0.17 is now available for download from www.evdiscuss.net/download. Below is the low-down on the most recent changes: Bug fix: Dates are now written into the EVDashboard database using ISO format regardless of locale (YYYY/MM/DD HH/MM/SS).EV Dashboard... Monitor, manage, maintain Enterprise Vault infrastructure, users, mailboxes, archives.
EVDashboard; an ASPbased IIS site which can do a lot of things to help you manage Enterprise Vault. NOTE: This software should be installed into your test environments first. By no means should you go right ahead and install it into your production systems. Only one person is responsibile for your EVinfrastructure; you. Use this software responsibly.
Synch Status or Inv_Synch_Status messages filling the evtqfast queue
This issue comes from a variety of issues, and with each subsequent release listed in the Environment section, a cause of the issue is fixed; however, subsequent releases have also introduced new causes. The main cause of the issue stems from the Task: New Software Portal Settings Task. This Task consists of two embedded tasks:
