Useful SQL Query - Move Archive Details (Intra-site moves)
All - I know it's been awhile, but this took a bit to sort out. The purpose of this query was to get all necessary information from the EnterpriseVaultDirectory when pertaining to EV Move Archive. This was tested and should be very helpful with reviewing the details of multiple single site (Intra-site) moves.Useful SQL Query (Vault Cache CC Download Status)
All - Been awhile but I figured I'd provide this query. In later versions of Enterprise Vault, the ClientDiagnostics.aspx page has been included to provide admin-level information on Vault Cache/Virtual Vault for an environment. Prior to this however, it was necessary to sift through VCView,IIS logs and the EnterpriseVaultDirectory for details on how Vault Cache was working fo
Daily Archiving Statistics appended to output file. VBScript.
I needed an easy way to look at the trends of EV archiving. Number of messages and sizes; So Icreated this VBScript around MichelZ's SQL script: SELECT COUNT(*) AS Count, MIN(ArchivedDate) AS FirstArchive, MAX (ArchivedDate) AS LastArchive, SUM(ItemSize)/1024 AS SaveSetSize, SUM(OriginalSize)/1024/1024 AS OriginalSizeMSMQs Folder Size - Appended to .csv - Email Alert if folder larger than 4GB. VBScript.
Over the last year Ihave found journalling has been enabled 'out of nowhere' on MSMQs on our EVservers; once the MSMQ storage folder gets to 8GB (The storage limits for MSMQs on our servers) the archiving task fails and archiving stops working.
