![]() ![]() This is the end of the Vault Store information (SELECT COUNT(*) FROM (SELECT DISTINCT SavesetIdentity, HoldGroupIdentity FROM Change the SQLserverName.VaultStoreName with the correct information WHERE CaseID = - This is the section where the individual Vault Stores need to be entered (SELECT COUNT(*) FROM tblIntDiscoveredItems SELECT, StatusID, LegalHoldGroupID, CaseID This can be run with less then 5 vault stores without removing entries There are 10 entries, two per vault store. Replace SQLServerName.EVVaultStoreX with the appropriate Sql server name and vault Store. Add the new variable in the INSERT and SELECT statements at the end of the scriptĢ. Add the in the SET section after the Vault Store sectionħ. Add the to the SET line (after the Vault Store section)Ħ. Add another SET section in the Vault Store section of the codeĥ. Increase the DECLARE variables:, SET the new variables to 0Ĥ. Adding another VSCountX in the temporary tableĢ. Additional vault stores can be added by:ġ. This script is setup to allow up to 5 Vault Stores. If using an Instance, enclose the Sql server name \ instance with brackets. Important Notes: If crossing multiple SQL servers, interconnect the Sql servers by running the following command: EXECUTE sp_addlinkedserver SQLServerName SCRIPT 2: This is designed to supply BY CASE the amount of legal holds the DA customer database reports as 'on-hold' PER VAULT STORE SET = 4, INTO #DBTable (DatabaseName) VALUES NEXT FROM TBLCursor INTO DISTINCT DatabaseName AS 'DA Databases with holds' FROM #DBTable Copy the text below into a New Query window and execute the script against the appropriate Vault Store database. ![]() SCRIPT 1: Determines which DA Customer databases are placing Legal Holds on Vault Store databasesġ. The SQL Scripts below will report and validate if any DA databases have added holds to items in the Vault Stores. The queries may take an extended amount of time, depending on the numbers of items on Legal Hold and the available SQL resources at the time the queries were executed. Note: As these queries do not perform any data manipulation, it is safe to run these queries on production databases. This information is easily obtained by running the appropriate SQL queries via the SQL Server Management Studio, as below. When troubleshooting the Discovery Accelerator (DA) Legal Hold process, there may be a need to obtain the counts of items on Legal Hold within the Enterprise Vault (EV) Vault Stores. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |