Error while opening Web Reports for Archive Manager Reporting Pack: Login failed for SQL Server login 'Mstats'. The password for this login has expired
SELECT [AMServerName], COUNT(*) AS [_Count] FROM (SELECT * FROM (SELECT AMServerName, MailboxName, MessageID, [MsgSize(KB)], DateProcessed, [Date] FROM (SELECT TOP 1000 'xxx' AS AMServerName, Name AS MailboxName, OrigionalMessageID AS MessageID, Size / 1024.0 AS [MsgSize(KB)], DateProcessed, CONVERT(DATETIME, CONVERT(NVARCHAR, DateProcessed, 112), 112) AS [Date] FROM [xxx].[ArchiveManager].dbo.Message ME INNER JOIN [xxx].[ArchiveManager].dbo.MailboxMessage MAME ON MAME.MessageID = ME.MessageID INNER JOIN [xxx].[ArchiveManager].dbo.Mailbox MA ON MA.MailboxID = MAME.MailboxID ORDER BY DateProcessed DESC ) InnerQuery) DummyQuery) [_IntResult] WHERE (([AMServerName] IN (xxx))) GROUP BY [AMServerName] ORDER BY [AMServerName] ASC
(0x80040217)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center