PowerShell Custom Reports - Admin

PS - Exchange Syntax Sample
SELECT FROM OpenExchangePSQuery(     POWERSHELL, '                  ', POWERSHELL )
Mon, 10 Jul, 2017 at 7:50 PM
PS - Exchange Online Syntax Sample
SELECT Name FROM openpsquery ( POWERSHELL, ' $Mailboxes = Get-Mailbox -ResultSize 10; $Mailboxes; ' )
Mon, 10 Jul, 2017 at 7:50 PM
PS - Search-AdminAuditLog, SELECT Caller,Rundate,CmdletName,Succeeded,OriginatingServer,ObjectModified
SELECT Caller,RunDate,CmdletName,Succeeded,OriginatingServer,ObjectModified FROM OpenExchangePSQuery(     POWERSHELL, '         Search-AdminAuditLog -Cm...
Thu, 29 Jun, 2017 at 4:20 PM
PS - Get-MailboxDatabase, SELECT Name,LastFullBackup
SELECT Name,LastFullBackup FROM OpenExchangePSQuery(     POWERSHELL, '     Get-MailboxDatabase -Status | Select Name,LastFullBackup               ',...
Thu, 29 Jun, 2017 at 4:48 PM
PS - GetADUser, SELECT Name,LastLogonDate
SELECT Name,LastLogonDate FROM OpenExchangePSQuery(     POWERSHELL, '     Import-Module ActiveDirectory                  Get-ADUser -FIlter * -Prope...
Thu, 29 Jun, 2017 at 6:01 PM
PS - SearchMailboxAuditLog, SELECT LastAccessed,MailboxOwnerUPN,LogonUserDisplayName,Operation,OperationResult,ClientInfoString,ItemSubject
SELECT LastAccessed,MailboxOwnerUPN,LogonUserDisplayName,Operation,OperationResult,ClientInfoString,ItemSubject FROM OpenExchangePSQuery(     POWERSHELL, ...
Thu, 29 Jun, 2017 at 7:41 PM
PS - Get-EventLog, Get-Date, SELECT EventIndex,Time,EntryType,Source,InstanceID
SELECT EventIndex,Time,EntryType,Source,InstanceID FROM OpenExchangePSQuery(     POWERSHELL, '     $TimeAgo = (Get-Date).addMinutes(-1) $servers = "...
Fri, 7 Jul, 2017 at 10:08 PM