cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
aviado
Engaged Sweeper

Hello everyone,

I'm seeking assistance in creating a comprehensive report within Lansweeper that displays a list of all Exchange mailboxes along with their respective mailbox storage details. Specifically, I aim to generate a report that not only lists the total mailbox space for each user but also highlights their current usage, indicating the amount used and the percentage of free space remaining.

For instance, the report should showcase details like:

  • User: Username
  • Total Mailbox Space: Total Size
  • Used Space: Amount Used
  • Percentage of Free Space: [Percentage Remaining]

This information would be incredibly beneficial for monitoring mailbox usage and managing storage efficiently. Any guidance or assistance on how to construct such a report within Lansweeper would be greatly appreciated.

Thank you!

aviado_0-1703406720055.png

 

2 REPLIES 2
Mister_Nobody
Honored Sweeper
Select Top 1000000 'globe-green.png' As Icon,
  tblExchangeMailbox.DisplayName,
  tblExchangeMailbox.Alias,
  tblExchangeMailbox.RecipientType,
  tblExchangeMailbox.RecipientTypeDetails,
  addresses.email As EmailAddress,
  tblExchangeServer.AssetId As ServerAssetId,
  tblExchangeServer.Name As ExchangeServer,
  tblExchangeMailboxStatistics.TotalItemSize
From tblExchangeMailbox
  Left Outer Join (Select Min(tblExchangeMailboxAddress.Address) As email,
      tblExchangeMailboxAddress.MailboxId
    From tblExchangeMailboxAddress
    Group By tblExchangeMailboxAddress.MailboxId) addresses On
      addresses.MailboxId = tblExchangeMailbox.MailboxId
  Inner Join tblExchangeServer On tblExchangeServer.ServerId =
      tblExchangeMailbox.ServerId
  Inner Join tblExchangeMailboxStatistics On tblExchangeMailbox.MailboxId =
      tblExchangeMailboxStatistics.MailboxId
Order By tblExchangeMailbox.DisplayName
Mister_Nobody
Honored Sweeper
Select Top 1000000 'globe-green.png' As Icon,
  tblExchangeMailbox.*,
  tblExchangeMailboxAddress.Address
From tblExchangeMailbox
  Inner Join tblExchangeMailboxAddress On tblExchangeMailbox.MailboxId =
      tblExchangeMailboxAddress.MailboxId