User % Mailbox Quota Database

Hi.. I want to exclude certain Mailbox databases from showing up on the dashboard on "User % Mailbox Quota " resource. Is there any filter or query i can run to achieve this. Also i want to exclude the same mailbox databases from the " User % Mailbox Quota " Report . Can you provide me the SWQL query to get this done.

Find more posts tagged with

exchange

mailbox

Alert

monitor

sam

Node

network

dashboard

solarwinds

quota

user

npm

server

report

Accepted answers

yaquaholic

Hi Max,

Sorry, I wasn't at my computer when I scribbled.... My bad.

Now tested and error free (on my SWQL Studio anyway).

SELECT a.Name as ApplicationName, a.Status as [ApplicationStatus], a.DetailsUrl as [ApplicationDetailsUrl], mb.Database.Identity as DatabaseName,

mb.Database.Status as [DatabaseStatus], mb.Database.DetailsUrl as [DatabaseDetailsUrl], mb.DisplayName as UserName, mb.UserLogonName,

mb.Status as [MailboxStatus], mb.DetailsUrl as [MailboxDetailsUrl], mb.TotalItemSize,

CASE WHEN(mb.PercentageOfUsedQuota IS NULL)

THEN 0.00 ELSE mb.PercentageOfUsedQuota END AS PercentageOfUsedQuota ,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.IssueWarningQuota IS NULL)

THEN d.IssueWarningQuota ELSE mb.IssueWarningQuota END AS IssueWarningQuota,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.ProhibitSendQuota IS NULL)

THEN d.ProhibitSendQuota ELSE mb.ProhibitSendQuota END AS ProhibitSendQuota,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.ProhibitSendReceiveQuota IS NULL)

THEN d.ProhibitSendReceiveQuota ELSE mb.ProhibitSendReceiveQuota END AS ProhibitSendReceiveQuota,

mb.ItemCount, mb.AttachmentsSize

FROM Orion.APM.Exchange.Mailbox mb

JOIN Orion.APM.Exchange.Database d ON d.Copies.IsActive = 1 AND d.ID = mb.DatabaseID

JOIN Orion.APM.Exchange.Application a ON a.ApplicationID = d.Copies.ApplicationID

WHERE ( mb.DisplayName NOT LIKE 'testdb1' OR mb.DisplayName NOT LIKE 'Transitsb')

ORDER BY ProhibitSendReceiveQuota DESC

Regards,

Rich

All comments

max348

anyone??

yaquaholic

Hi Max,

Let's have a look at your effort so far, or even the syntax of the mail box name.

Rich

max348

Hi.. thanks for the reply. I am using Out-of-box "user % mailbox quota report" . I want to exclude 2 databases - "testdb1" and "Transitsb". Below are the querry from the report.

SELECT TOP 1000

a.Name as ApplicationName,

a.Status as [ApplicationStatus],

a.DetailsUrl as [ApplicationDetailsUrl],

mb.Database.Identity as DatabaseName,

mb.Database.Status as [DatabaseStatus],

mb.Database.DetailsUrl as [DatabaseDetailsUrl],

mb.DisplayName as UserName,

mb.UserLogonName,

mb.Status as [MailboxStatus],

mb.DetailsUrl as [MailboxDetailsUrl],

mb.TotalItemSize,

CASE WHEN(mb.PercentageOfUsedQuota IS NULL)

THEN 0.00 ELSE mb.PercentageOfUsedQuota END AS PercentageOfUsedQuota ,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.IssueWarningQuota IS NULL)

THEN d.IssueWarningQuota ELSE mb.IssueWarningQuota END AS IssueWarningQuota,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.ProhibitSendQuota IS NULL)

THEN d.ProhibitSendQuota ELSE mb.ProhibitSendQuota END AS ProhibitSendQuota,

CASE WHEN(mb.UseDatabaseQuotaDefaults = True OR mb.ProhibitSendReceiveQuota IS NULL)

THEN d.ProhibitSendReceiveQuota ELSE mb.ProhibitSendReceiveQuota END AS ProhibitSendReceiveQuota,

mb.ItemCount,

mb.AttachmentsSize

FROM Orion.APM.Exchange.Mailbox mb

JOIN Orion.APM.Exchange.Database d ON d.Copies.IsActive = 1 AND d.ID = mb.DatabaseID

JOIN Orion.APM.Exchange.Application a ON a.ApplicationID = d.Copies.ApplicationID

ORDER BY ProhibitSendReceiveQuota DESC

max348

Hi YAQUAHOLIC

Can you help me modify this??

yaquaholic

Hi Max,

Okay, firstly the testdb1 and Transitsb mailboxes, I take it these show up in the report as the UserName field?

If so, then I would add the following in bold, between the last JOIN and the ORDER BY:

FROM Orion.APM.Exchange.Mailbox mb

JOIN Orion.APM.Exchange.Database d ON d.Copies.IsActive = 1 AND d.ID = mb.DatabaseID

JOIN Orion.APM.Exchange.Application a ON a.ApplicationID = d.Copies.ApplicationID

WHERE mb.DisplayName NOT IN ("testdb1", "Transitsb") --filter out "testdb1", "Transitsb"

ORDER BY ProhibitSendReceiveQuota DESC

You may need to add wildcards to the names (which is the % symbol in SQL and SWQL), for example: "%testdb1%" would match any string that exact pattern in it.

I hope it helps,

Rich

max348

Databases Testdb1 and TransitDb shows up in "mb.Database.Identity as DatabaseName".

So do i add field like this ?

WHERE mb.Database.Identity NOT IN ("testdb1", "Transitsb") --filter out "testdb1", "Transitsb"