EV SQL query script for total number of message archived in the past day ?
Created: 29 Jul 2012 | Updated: 29 Jul 2012 | 5 comments
This issue has been solved. See solution.
Same as in article: https://www-secure.symantec.com/connect/forums/need-sql-query
Hi can anyone here please let me know what could go wrong with the following script:
SELECT CE.computername "EV Server", T.name "Task Name", ESE.exchangecomputer "Exchange Server", Count(s.idtransaction) "Items Archived" FROM enterprisevaultdirectory.dbo.exchangemailboxentry EME, enterprisevaultdirectory.dbo.exchangemailboxstore EMS, enterprisevaultdirectory.dbo.exchangeserverentry ESE, enterprisevaultdirectory.dbo.archivingretrievaltask ART, enterprisevaultdirectory.dbo.task T, enterprisevaultdirectory.dbo.computerentry CE, EVVaultstore1.dbo.archivepoint AP, EVVaultstore1.dbo.saveset S WHERE S.archivepointidentity = AP.archivepointidentity AND AP.archivepointid = EME.defaultvaultid AND EME.mbxstoreidentity = EMS.mbxstoreidentity AND EMS.exchangeserveridentity = ESE.exchangeserveridentity AND ART.exchangeserverentryid = ESE.exchangeserverentryid AND ART.taskentryid = T.taskentryid AND T.computerentryid = CE.computerentryid AND T.tasktype = 0 AND T.name = 'Exchange Mailbox Archiving Task for yourExchangeServer' AND S.archiveddate > Dateadd(d, -3, Getdate()) GROUP BY CE.computername, T.name, ESE.exchangecomputer
I have changed the two lines from:
yourvaultstore.dbo.archivepoint AP, yourvaultstore.dbo.saveset S
EVVaultstore1.dbo.archivepoint AP, EVVaultstore1.dbo.saveset S
to match my EV VaultStore Database, but still I got this error:
Msg 207, Level 16, State 1, Line 16 Invalid column name 'exchangeserveridentity'.
any help please ?