Support Portal

Schema & Administrator Guides to Custom Reporting 3

• MailscapeDBSchemaOnly
• ENow Managment System (EMS) Administrator's Cookbook - Create PowerShell-based Custom Reports
• ENow Managment System (EMS) Administrator's Guide to Creating SQL-based Custom Reports

PowerShell Custom Reports - Admin 7

• PS - Exchange Syntax Sample
• PS - Exchange Online Syntax Sample
• PS - Search-AdminAuditLog, SELECT Caller,Rundate,CmdletName,Succeeded,OriginatingServer,ObjectModified
• PS - Get-MailboxDatabase, SELECT Name,LastFullBackup
• PS - GetADUser, SELECT Name,LastLogonDate

View all 7

SQL Custom Reports 17

• SQL - ORDER BY t.LogDate, t.Sender, WHERE t.LogDate BETWEEN @StartDate AND @EndDate AND t.Sent = 1, FROM Traffic t
• SQL - Select Sum(CountSent) AS Messages Sent, Sum(CountReceived) AS Messages Received), SET @PastDays = 30
• SQL - ORDER BY t.LogDate, t.Sender, WHERE t.LogDate BETWEEN @StartDate AND @EndDate, FROM Traffic t INNER JOIN MessageList m ON t.TrafficId = m.TrafficId, SELECT t.LogDate
• SQL - DROP TABLE UserPwdLastSet, ORDER BY PwdLastSet DESC, FROM UserPwdLastSet
• SQL - ORDER BY [Order], SELECT [Year], [Week], [Week Start], [Week End], [Count], GROUP BY YEAR(t.LogDate), DATEPART(WEEK, t.LogDate)

View all 17

PowerShell Custom Reports - Public Folder 4

• PS - Get-PublicFolderStatistics, SELECT Name, ItemCount,LastAccessTime
• PS - Get-PublicFolderStatistics, SELECT Name,LastAccessTime
• PS - Get-PublicFolderStatistics, SELECT Name,ItemCount,TotalItemSize,LastAccessTime,LastModificationTime
• PS - Get-PublicFolderStatistics, SELECT Name,ItemCount,TotalItemSizeMB

PowerShell Custom Reports - ActiveSync 4

• PS - Get-ActiveSyncDevice, SELECT Count, Name
• PS - Get-ActiveSyncDeviceStatistics, Get-CASMailbox, SELECT MailboxServer, DisplayName, EMailAddress,DeviceModel,DeviceID,DeviceFriendlyName,DeviceOS,LastSuccessSync
• PS - Get-ActiveSyncDeviceStatistics, Get-CASMailBox, SELECT DisplayName,EMailAddress,DeviceModel,DeviceID,DeviceFriendlyName,DeviceOS,LastSuccessSync
• PS - Get-ActiveSyncDevice, SELECT Count,Name

PowerShell Custom Reports - Message Tracking 8

• PS - Get-MessageTrackingLog, SELECT Timestamp,MessageID,Sender,Recipients,RecipientCount
• PS - Get-MessageTrackingLog,Get-DistributionGroup, SELECT Name,Count
• PS Script - Get-MessageTrackingLog, Get-MailboxStatistics, Get-Mailbox
• PS - Get-MessageTrackingLog,Get-Mailbox, SELECT Name,Count
• PS - Get-MessageTrackingLog,Get-DistributionGroup, SELECT Name,LastMessageReceived

View all 8

PowerShell Custom Reports - Mailbox 8

• PS - Get-Mailbox, Get-ADUser, SELECT Name,AccountEnabled,MailboxEnabled
• PS - Get-Mailbox, SELECT Name,RetainDeletedItemsFor
• PS - Get-MailboxStatistics,Get-Mailbox, SELECT DisplayName,ItemCountTotalItemSize,TotalDeletedItemSize
• PS - Get-Mailbox, SELECT SamAccountName,DisplayName,InPolicy,OutOfPolicy,TotalDuration,BookableTime,BookedPercentage
• PS - Get-MailboxPermission,Get-Mailbox, SELECT AccessingUser,MailboxAccessed,AccessRights

View all 8

PowerShell Custom Reports - Distribution Lists 2

• PS - Get-Mailbox, Get-DistributionGroup, Get-Recipient, Get-MailContact, SQL - SELECT MailContacts,RecipientCount,DistributionGroups,MailboxCount
• PS - Get-Mailbox, Get-DistributionGroup, Get-Recipient, Get-MailContact, SELECT MailContacts,RecipientCount,DistributionGroups,MailboxCount

PowerShell Custom Reports - CAS 2

• PS Script - Get-CASActiveUsers
• PS - Get-CASMailbox, SELECT Name,OWAEnabled,PopEnabled,IMAPEnabled,ActiveSyncEnabled