When trying to create a custom report using the Inventory Reports - Mailboxes or Mailboxes with Disabled Accounts, selecting all fields and filter on Disable =True or False the following error is reported.
Unexpected error while attempting to read from the database.
Invalid column name 'FALSE'.
SELECT COUNT(*) AS [_Count] FROM (SELECT * FROM V_MailboxSizePerUserRecent) [_IntResult] WHERE ([Disabled] = FALSE AND ([Mailbox Email] NOT LIKE NB'%deleted%' OR [Mailbox Email] IS NULL))
(0x80040217)
Or
Unexpected error while attempting to read from the database.
Invalid column name 'TRUE'.
SELECT COUNT(*) AS [_Count] FROM (SELECT * FROM V_MailboxSizePerUserRecent) [_IntResult] WHERE ([Disabled] = TRUE)
(0x80040217)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center