[PS] [EX2010] Recoverable Folder Size Report

Recoverable Folder Size Report v1 Crawls all mailboxes and pulls the recoverableitemsquota size Displays top 10 in HTML report Full CSV report is generated E-mails report with full report

# Setup E-mail Parameters
$smtpServer = "host.server.com"
$emailFrom = "from@address.com"
$emailTo = @('<to@address.com>')
$subject = "Top Recoverable Folder Size - $date"
$output = "c:\temp\output.csv"

#Import Exchange 2010 Module
Add-PSSnapin Microsoft.Exchange.Management.Powershell.E2010 -ErrorAction SilentlyContinue

#Setup Variables
[INT] $RQ = 0
[INT] $RW = 0
[INT] $DIQ = "30"
[INT] $DIW = "20"
$Path = "c:\temp\test.html"
#

#Exclusion

#Check if all Database Quota matches default
$Q = @(Get-mailboxdatabase | foreach {$_.recoverableitemsquota.value.tobytes()/1Gb})
foreach ($IQ in $Q) {
If ($IQ -notmatch "$DIQ")
{
write-host $IQ + "is not set to default settings"
$RQ++
}
}
If ($RQ -ge 1) { echo "default is not set for 1 or more mailboxes"}


#Check if all Database Quota matches warning default
$W = @(Get-mailboxdatabase | foreach {$_.RecoverableItemsWarningQuota.value.tobytes()/1Gb})
foreach ($IW in $W) {
If ($IW -notmatch "$DIW")
{
write-host $IW + "is not set to default settings"
$RW++
}
}
If ($RW -ge 1) { echo "storage default is not set for 1 or more mailboxes"}

$sort = @()
$output = "c:\temp\output.csv"

$mailboxes = Get-mailbox -resultsize unlimited
Foreach ($m in $mailboxes)
{
$size = Get-MailboxFolderStatistics $m -FolderScope RecoverableItems | ?{$_.Identity -match "Recoverable Items"}

$sort = New-Object psobject -Property @{
mailbox = $m.alias
mailboxdn = $m.distinguishedname
recoversize = [math]::round($size.folderandsubfoldersize.tobytes() /1Gb, 3)
}
$sort | Export-Csv c:\temp\output.csv -notypeinformation -append
$sort =""
}


$output = "c:\temp\output.csv"
$mailboxesorted = import-csv $output | sort-Object {[INT]$_.recoversize} -Descending | select -First 10

$DiskDetailHTML += "<table>"
$DiskDetailHTML += "<tr><th>Mailbox</th><th>Mailbox Database</th><th>Mailbox ARC</th><th>Litigation Hold</th><th>Recoverablesize</th><th width=""400px"">Usage</th></tr>`n"


#loop through all mailboxes

Foreach ($mbx in $mailboxesorted)
{

$mbxinfo = get-mailbox $mbx.mailboxdn
#grab recoverable folder stats


$stat = Get-MailboxFolderStatistics $mbxinfo -FolderScope RecoverableItems | ?{$_.Identity -match "Recoverable Items"}

#DB
$db = $mbxinfo.database

#ARC
$arcdb = $mbxinfo.archivedatabase

#LIT
$lit = $mbxinfo.litigationholdenabled

#recoveravle folder size to GB
$calcrsize = $stat.folderandsubfoldersize.tobytes()/1GB
$rsize = ($calcrsize).ToString("#.#######")

$alias = $mbxinfo.alias

#percentage
$calcpercent = ($rsize/$diq)
$percent = ($calcpercent).ToString("P") -replace '\s',''
$fpercent = (1-$calcpercent).ToString("P") -replace '\s',''

if ($percent -lt 0.01)
{
#

$DiskDetailHTML += "<TR>
<TD>$alias</TD>
<TD>$db</TD>
<TD>$arcdb</TD>
<TD>$lit</TD>
<TD>$rsize GB</TD>
<TD>

<table width=""100%"">
<tr>

<td width=""100%"" bgcolor=""green"" align=""Center"">$fpercent</td>
</tr>
</table>
</td></tr>`n"

} else {

$DiskDetailHTML += "<TR>
<TD>$alias</TD>
<TD>$db</TD>
<TD>$arcdb</TD>
<TD>$lit</TD>
<TD>$rsize GB</TD>
<TD>

<table width=""100%"">
<tr>
<td width=""$percent"" bgcolor=""Red"" align=""Center"">$percent</td>
<td width=""$fpercent"" bgcolor=""green"" align=""Center"">$fpercent</td>
</tr>
</table>
</td></tr>`n"

#
}
}

#Define static HTML
$HeaderHTML = @"
<html>
<head>
<style type='text/css'>
body { background-color:#DCDCDC;
}
table { border:1px solid gray;
font:normal 12px verdana, arial, helvetica, sans-serif;
border-collapse: collapse;
padding-left:30px;
padding-right:30px;
}
th { color:black;
text-align:left;
border: 1px solid black;
font:normal 16px verdana, arial, helvetica, sans-serif;
font-weight:bold;
background-color: #6495ED;
padding-left:6px;
padding-right:6px;
}
td { border: 1px solid black;
padding-left:6px;
padding-right:6px;
}
a.detail { cursor:pointer;
color:#1E90FF;
text-decoration:underline;
}
</style>
</head>
<body>
<h1>Recoverable Folder Size Report</h1>
<p>

"@

#Define Footer HTML
$FooterHTML = @"
</table>
</div>
</body>
</html>
"@


#Combine all the HTML fragments and save to a file
$HTML = $HeaderHTML + $DiskDetailHTML + $FooterHTML
$HTML | Out-File $Path
#>

Send-MailMessage -From $emailFrom -To $emailTo -Subject $Subject -Attachment $output -Body $HTML -BodyAsHtml -SmtpServer $smtpServer -EA Stop 2>> $errorlog

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

# Setup E-mail Parameters

$smtpServer = "host.server.com"

$emailFrom = "from@address.com"

$emailTo = @('<to@address.com>')

$subject = "Top Recoverable Folder Size - $date"

$output = "c:\temp\output.csv"

#Import Exchange 2010 Module

Add-PSSnapin Microsoft.Exchange.Management.Powershell.E2010 -ErrorAction SilentlyContinue

#Setup Variables

[INT] $RQ = 0

[INT] $RW = 0

[INT] $DIQ = "30"

[INT] $DIW = "20"

$Path = "c:\temp\test.html"

#

#Exclusion

#Check if all Database Quota matches default

$Q = @(Get-mailboxdatabase | foreach {$_.recoverableitemsquota.value.tobytes()/1Gb})

foreach ($IQ in $Q) {

If ($IQ -notmatch "$DIQ")

{

write-host $IQ + "is not set to default settings"

$RQ++

}

If ($RQ -ge 1) { echo "default is not set for 1 or more mailboxes"}

#Check if all Database Quota matches warning default

$W = @(Get-mailboxdatabase | foreach {$_.RecoverableItemsWarningQuota.value.tobytes()/1Gb})

foreach ($IW in $W) {

If ($IW -notmatch "$DIW")

{

write-host $IW + "is not set to default settings"

$RW++

}

If ($RW -ge 1) { echo "storage default is not set for 1 or more mailboxes"}

$sort = @()

$output = "c:\temp\output.csv"

$mailboxes = Get-mailbox -resultsize unlimited

Foreach ($m in $mailboxes)

{

$size = Get-MailboxFolderStatistics $m -FolderScope RecoverableItems | ?{$_.Identity -match "Recoverable Items"}

$sort = New-Object psobject -Property @{

mailbox = $m.alias

mailboxdn = $m.distinguishedname

recoversize = [math]::round($size.folderandsubfoldersize.tobytes() /1Gb, 3)

}

$sort | Export-Csv c:\temp\output.csv -notypeinformation -append

$sort =""

}

$output = "c:\temp\output.csv"

$mailboxesorted = import-csv $output | sort-Object {[INT]$_.recoversize} -Descending | select -First 10

$DiskDetailHTML += "<table>"

$DiskDetailHTML += "<tr><th>Mailbox</th><th>Mailbox Database</th><th>Mailbox ARC</th><th>Litigation Hold</th><th>Recoverablesize</th><th width=""400px"">Usage</th></tr>`n"

#loop through all mailboxes

Foreach ($mbx in $mailboxesorted)

{

$mbxinfo = get-mailbox $mbx.mailboxdn

#grab recoverable folder stats

$stat = Get-MailboxFolderStatistics $mbxinfo -FolderScope RecoverableItems | ?{$_.Identity -match "Recoverable Items"}

#DB

$db = $mbxinfo.database

#ARC

$arcdb = $mbxinfo.archivedatabase

#LIT

$lit = $mbxinfo.litigationholdenabled

#recoveravle folder size to GB

$calcrsize = $stat.folderandsubfoldersize.tobytes()/1GB

$rsize = ($calcrsize).ToString("#.#######")

$alias = $mbxinfo.alias

#percentage

$calcpercent = ($rsize/$diq)

$percent = ($calcpercent).ToString("P") -replace '\s',''

$fpercent = (1-$calcpercent).ToString("P") -replace '\s',''

if ($percent -lt 0.01)

{

#

$DiskDetailHTML += "<TR>

<TD>$alias</TD>

<TD>$arcdb</TD>

<TD>$rsize GB</TD>

<TD>

<tr>

<td width=""100%"" bgcolor=""green"" align=""Center"">$fpercent</td>

</tr>

</table>

</td></tr>`n"

} else {

$DiskDetailHTML += "<TR>

<TD>$alias</TD>

<TD>$arcdb</TD>

<TD>$rsize GB</TD>

<TD>

<tr>

<td width=""$percent"" bgcolor=""Red"" align=""Center"">$percent</td>

<td width=""$fpercent"" bgcolor=""green"" align=""Center"">$fpercent</td>

</tr>

</table>

</td></tr>`n"

#

}

#Define static HTML

$HeaderHTML = @"

<html>

<head>

body { background-color:#DCDCDC;

}

table { border:1px solid gray;

font:normal 12px verdana, arial, helvetica, sans-serif;

border-collapse: collapse;

padding-left:30px;

padding-right:30px;

}

th { color:black;

text-align:left;

border: 1px solid black;

font:normal 16px verdana, arial, helvetica, sans-serif;

font-weight:bold;

background-color: #6495ED;

padding-left:6px;

padding-right:6px;

}

td { border: 1px solid black;

padding-left:6px;

padding-right:6px;

}

a.detail { cursor:pointer;

color:#1E90FF;

text-decoration:underline;

}

</style>

</head>

<body>

<h1>Recoverable Folder Size Report</h1>

<p>

"@

#Define Footer HTML

$FooterHTML = @"

</table>

</div>

</body>

</html>

"@

#Combine all the HTML fragments and save to a file

$HTML = $HeaderHTML + $DiskDetailHTML + $FooterHTML

$HTML | Out-File $Path

#>

Send-MailMessage -From $emailFrom -To $emailTo -Subject $Subject -Attachment $output -Body $HTML -BodyAsHtml -SmtpServer $smtpServer -EA Stop 2>> $errorlog

[EX2010][PS] Recover mail items from Exchange

How do I recover an item after its been deleted? So long as the recoverable items purge duration has not exceeded, you can run the below command to pull e-mails. For more specific searchquery, reference Advanced Query Syntax (AQS).

#type search example

Search-mailbox -identity <guid> -SearchQuery 'kind:<type>' -SearchDumpsterOnly -TargetMailbox "<destination mailbox>" -TargetFolder "<destination folder>" -loglevel full


$multiple criteria search example:

Search-mailbox -identity <guid> -SearchQuery 'kind:<type> AND subject "<subject>"' -SearchDumpsterOnly -TargetMailbox "<destination mailbox>" -TargetFolder "<destination folder>" -loglevel full

1

2

3

4

5

6

7

8

#type search example

Search-mailbox -identity <guid> -SearchQuery 'kind:<type>' -SearchDumpsterOnly -TargetMailbox "<destination mailbox>" -TargetFolder "<destination folder>" -loglevel full

$multiple criteria search example:

Search-mailbox -identity <guid> -SearchQuery 'kind:<type> AND subject "<subject>"' -SearchDumpsterOnly -TargetMailbox "<destination mailbox>" -TargetFolder "<destination folder>" -loglevel full

Email Meetings Tasks Notes Docs Journals Contacts IM

[PS] Enable TLS 1.2 as default in Powershell

epic August 5, 2019 Powershell Comment »

Check Supported protocol [Net.ServicePointManager]::SecurityProtocol [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 Change Net Frame to use TLS 1.2 Set-ItemProperty -Path ‘HKLM:\SOFTWARE\Wow6432Node\Microsoft\.NetFramework\v4.0.30319’ -Name ‘SchUseStrongCrypto’ -Value ‘1’ -Type DWord Set-ItemProperty -Path ‘HKLM:\SOFTWARE\Microsoft\.NetFramework\v4.0.30319’ -Name ‘SchUseStrongCrypto’ -Value ‘1’ -Type DWord

[EX2010] Litigation Hold (Legal Hold)

epic July 20, 2019 Exchange Powershell Comment »

Litigation Hold (Legal Hold) Used to preserve mailbox and electronically stored information in anticipation of legal proceedings, investigations, and unspecified reasons. Organizations may be required to inform when a user is placed on litigation hold. Specifications: Requires Discovery Management or Legal Hold Mgmt (RBAC) to place a mailbox in legal hold Option to enable or →

[PS] Write powershell errors to a text file

epic June 19, 2019 Powershell Comment »

Method 1: Try, Catch, Finally Try: Try to execute a command Catch: Catches any errors, triggers only for Terminating Errors, so you may need to set a ErrorAction -Stop (EA) for errors that are not terminating. Finally: Runs regardless if a error occurs.

Try { Set-Mailbox -Identity  -PrimarySmtpAddress  -EA STOP }
Catch { $_ | Out-File C:\errors.txt -Append }
Finally { Echo "runs no matter what"}

1

2

3

Try { Set-Mailbox -Identity -PrimarySmtpAddress -EA STOP }

Catch { $_ | Out-File C:\errors.txt -Append }

Finally { Echo "runs no matter what"}

Method 2: Output error directly to error log

Set-Mailbox -PrimarySmtpAddress <primarysmtpaddress> 2>> C:\errors.txt

1	Set-Mailbox -PrimarySmtpAddress <primarysmtpaddress> 2>> C:\errors.txt

Method 3: →

[EXCH] The Cluster service cannot be started. Event ID 1090

epic June 17, 2019 Exchange Powershell Comment »

The Cluster service cannot be started. An attempt to read configuration data from the Windows registry failed with error '2'. Please use the Failover Cluster Management snap-in to ensure that this machine is a member of a cluster. If you intend to add this machine to an existing cluster use the Add Node Wizard. Alternatively, if this machine has been configured as a member of a cluster, it will be necessary to restore the missing configuration data that is necessary for the Cluster Service to identify that it is a member of a cluster. Perform a System State Restore of this machine in order to restore the configuration data.

1

The Cluster service cannot be started. An attempt to read configuration data from the Windows registry failed with error '2'. Please use the Failover Cluster Management snap-in to ensure that this machine is a member of a cluster. If you intend to add this machine to an existing cluster use the Add Node Wizard. Alternatively, if this machine has been configured as a member of a cluster, it will be necessary to restore the missing configuration data that is necessary for the Cluster Service to identify that it is a member of a cluster. Perform a System State Restore of this machine in order to restore the configuration data.

Check the Status of Mailbox Servers by running Get-DatabaseAvaliabilityGroup | FL Inspect servers in stopped and started state If a mailbox is in a stopped state, you can attempt to stop the individual server by running: Stop-DatabaseAvaliabilityGroup -identity <cluster> -mailboxserver <mailbox server> Check the status of the Fail-over Cluster Service Manager Launch Fail-over Cluster →

[O365][PS] Exchange Online Powershell Module and connecting to Exchange Online

epic May 16, 2019 Exchange Office365 Powershell Comment »

Example 1:

Import-Module (Get-ChildItem -Path $($env:LOCALAPPDATA+"\Apps\2.0\") -Filter '*ExoPowershellModule.dll' -Recurse | Foreach{(Get-ChildItem -Path $_.Directory -Filter CreateExoPSSession.ps1)} | Sort-Object LastWriteTime | Select-Object -Last 1).FullName
$User = "epic@onmicrosoft.com"
$PasswordFile = "c:\o365\Password.txt"
$KeyFile = "c:\o365\AES.key"
$key = Get-Content $KeyFile
$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential `
 -ArgumentList $User, (Get-Content $PasswordFile | ConvertTo-SecureString -Key $key)
$proxysettings = New-PSSessionOption -ProxyAccessType IEConfig
connect-exopssession -pssessionoption $proxysettings -credential $MyCredential

1

2

3

4

5

6

7

8

9

Import-Module (Get-ChildItem -Path $($env:LOCALAPPDATA+"\Apps\2.0\") -Filter '*ExoPowershellModule.dll' -Recurse | Foreach{(Get-ChildItem -Path $_.Directory -Filter CreateExoPSSession.ps1)} | Sort-Object LastWriteTime | Select-Object -Last 1).FullName

$User = "epic@onmicrosoft.com"

$PasswordFile = "c:\o365\Password.txt"

$KeyFile = "c:\o365\AES.key"

$key = Get-Content $KeyFile

$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential `

-ArgumentList $User, (Get-Content $PasswordFile | ConvertTo-SecureString -Key $key)

$proxysettings = New-PSSessionOption -ProxyAccessType IEConfig

connect-exopssession -pssessionoption $proxysettings -credential $MyCredential

Example 2:

$targetdir = (dir $env:LOCALAPPDATA”\Apps\2.0\” -Include CreateExoPSSession.ps1,Microsoft.Exchange.Management.ExoPowershellModule.dll -Recurse | Group Directory | ? {$_.Count -eq 2}).Values | sort LastWriteTime -Descending | select -First 1 | select -ExpandProperty FullName
import-Module $targetdir\CreateExoPSSession.ps1
$User = "elau@onmicrosoft.com"
$PasswordFile = "c:\o365\Password.txt"
$KeyFile = "c:\o365\AES.key"
$key = Get-Content $KeyFile
$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $User, (Get-Content $PasswordFile | ConvertTo-SecureString -Key $key)
$proxysettings = New-PSSessionOption -ProxyAccessType IEConfig
connect-exopssession -pssessionoption $proxysettings -credential $MyCredential

1

2

3

4

5

6

7

8

9

$targetdir = (dir $env:LOCALAPPDATA”\Apps\2.0\” -Include CreateExoPSSession.ps1,Microsoft.Exchange.Management.ExoPowershellModule.dll -Recurse | Group Directory | ? {$_.Count -eq 2}).Values | sort LastWriteTime -Descending | select -First 1 | select -ExpandProperty FullName

import-Module $targetdir\CreateExoPSSession.ps1

$User = "elau@onmicrosoft.com"

$PasswordFile = "c:\o365\Password.txt"

$KeyFile = "c:\o365\AES.key"

$key = Get-Content $KeyFile

$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $User, (Get-Content $PasswordFile | ConvertTo-SecureString -Key $key)

$proxysettings = New-PSSessionOption -ProxyAccessType IEConfig

connect-exopssession -pssessionoption $proxysettings -credential $MyCredential

Troubleshooting Errors: New-ExoPSSession : user_realm_discovery_failed: User realm discovery failed

New-ExoPSSession : user_realm_discovery_failed: User realm discovery failed
At C:\Users\adm_elau\AppData\Local\Apps\2.0\806D2EJM.EAP\C421GW28.ARQ\micr..tion_1975b8453054a2b5_0010.0000_b9d3168c8e461adc\CreateExoPSSession.ps1:301 char:30
+ ... PSSession = New-ExoPSSession -UserPrincipalName $UserPrincipalName.Va ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [New-ExoPSSession], AdalServiceException
    + FullyQualifiedErrorId : Microsoft.IdentityModel.Clients.ActiveDirectory.AdalServiceException,Microsoft.Exchange.Management.ExoPowershellSnapin.NewExoPSSession

1

2

3

4

5

6

New-ExoPSSession : user_realm_discovery_failed: User realm discovery failed

At C:\Users\adm_elau\AppData\Local\Apps\2.0\806D2EJM.EAP\C421GW28.ARQ\micr..tion_1975b8453054a2b5_0010.0000_b9d3168c8e461adc\CreateExoPSSession.ps1:301 char:30

+ ... PSSession = New-ExoPSSession -UserPrincipalName $UserPrincipalName.Va ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : NotSpecified: (:) [New-ExoPSSession], AdalServiceException

+ FullyQualifiedErrorId : Microsoft.IdentityModel.Clients.ActiveDirectory.AdalServiceException,Microsoft.Exchange.Management.ExoPowershellSnapin.NewExoPSSession

Check proxy settings in IE New-ExoPSSession: The SSL certificate could not be checked for revocation.

New-ExoPSSession : [outlook.office365.com] Connecting to remote server outlook.office365.com failed with the following error message : The server certificate on the destination computer (outlook.office365.com:443) has the following errors: 
The SSL certificate could not be checked for revocation. The server used to check for revocation might be unreachable. For more information, see the about_Remote_Troubleshooting Help topic.
At line:1 char:12
+ $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ht ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OpenError: (System.Manageme....RemoteRunspace:RemoteRunspace) [New-PSSession], PSRemotingTransportException
    + FullyQualifiedErrorId : 12175,PSSessionOpenFailed

1

2

3

4

5

6

7

New-ExoPSSession : [outlook.office365.com] Connecting to remote server outlook.office365.com failed with the following error message : The server certificate on the destination computer (outlook.office365.com:443) has the following errors:

The SSL certificate could not be checked for revocation. The server used to check for revocation might be unreachable. For more information, see the about_Remote_Troubleshooting Help topic.

At line:1 char:12

+ $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri ht ...

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : OpenError: (System.Manageme....RemoteRunspace:RemoteRunspace) [New-PSSession], PSRemotingTransportException

+ FullyQualifiedErrorId : 12175,PSSessionOpenFailed

Set winhttpbyusingsetproxycommand: Show: netsh winhttp show proxy Set Proxy: netsh winhttp set proxy <proxy url or ip>:<port> Reset Proxy: netsh winhttp reset proxy →

[PS] Creating a Key File and Password File

epic May 16, 2019 Powershell Comment »

Creating a Key File and Password File With PowerShell, we can generate a 256-bit AES encryption key: Creating the AES.key

 $KeyFile = "C:\o365\AES.key"
$Key = New-Object Byte[] 32   # You can use 16, 24, or 32 for AES
[Security.Cryptography.RNGCryptoServiceProvider]::Create().GetBytes($Key)
$Key | out-file $KeyFile

1

2

3

4

$KeyFile = "C:\o365\AES.key"

$Key = New-Object Byte[] 32 # You can use 16, 24, or 32 for AES

[Security.Cryptography.RNGCryptoServiceProvider]::Create().GetBytes($Key)

$Key | out-file $KeyFile

Creating the password file

$PasswordFile = "Password.txt"
$KeyFile = "AES.key"
$Key = Get-Content $KeyFile
$Password = "P@ssword1" | ConvertTo-SecureString -AsPlainText -Force
$Password | ConvertFrom-SecureString -key $Key | Out-File $PasswordFile

1

2

3

4

5

$PasswordFile = "Password.txt"

$KeyFile = "AES.key"

$Key = Get-Content $KeyFile

$Password = "P@ssword1" | ConvertTo-SecureString -AsPlainText -Force

$Password | ConvertFrom-SecureString -key $Key | Out-File $PasswordFile

Using the key and password file

$User = "username"$PasswordFile = "c:\o365\Password.txt"$KeyFile = "c:\o365\AES.key"$key = Get-Content $KeyFile$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential ` -ArgumentList $User, (Get-Content $PasswordFile | ConvertTo-SecureString -Key $key)

1	$User = "username"$PasswordFile = "c:\o365\Password.txt"$KeyFile = "c:\o365\AES.key"$key = Get-Content $KeyFile$MyCredential = New-Object -TypeName System.Management.Automation.PSCredential ` -ArgumentList $User, (Get-Content $PasswordFile \| ConvertTo-SecureString -Key $key)

[PS] Working with Variables

epic May 10, 2019 Powershell Variables Comment »

Variables uses the $ (Dollar Sign). Takes text, integers, and store output from cmdlets. Examples: Storing strings $Var=”Hello” Storing integars $Var=”5″ $Var=”1.0″ Storing output from cmdlets $Var=Get-Services bits (Grabs a Service Controller Object) – $Var.status would output status – $Var.stop() would stop bits services – $Var.refresh() refreshes the storage Storing using user input $Var=Read-host “Enter →

[PS] List of Aliases Used in PowerShell

epic May 9, 2019 Powershell Comment »

HTML TABLE HelpUri ResolvedCommandName DisplayName ReferencedCommand ResolvedCommand Definition Options Description OutputType Name CommandType Visibility ModuleName Module RemotingCapability Parameters ParameterSets http://go.microsoft.com/fwlink/?LinkID=113300 ForEach-Object % -> ForEach-Object ForEach-Object ForEach-Object ForEach-Object ReadOnly, AllScope System.Collections.ObjectModel.ReadOnlyCollection1[System.Management.Automation.PSTypeName] % Alias Public None System.Collections.Generic.Dictionary2[System.String,System.Management.Automation.ParameterMetadata] http://go.microsoft.com/fwlink/?LinkID=113423 Where-Object ? -> Where-Object Where-Object Where-Object Where-Object ReadOnly, AllScope System.Collections.ObjectModel.ReadOnlyCollection1[System.Management.Automation.PSTypeName] ? Alias Public None System.Collections.Generic.Dictionary2[System.String,System.Management.Automation.ParameterMetadata]

Powershell

[PS] [EX2010] Recoverable Folder Size Report

[EX2010][PS] Recover mail items from Exchange

[PS] Enable TLS 1.2 as default in Powershell

[EX2010] Litigation Hold (Legal Hold)

[PS] Write powershell errors to a text file

[EXCH] The Cluster service cannot be started. Event ID 1090

[O365][PS] Exchange Online Powershell Module and connecting to Exchange Online

[PS] Creating a Key File and Password File

[PS] Working with Variables

[PS] List of Aliases Used in PowerShell

Recent Posts

Recent Comments

Refresh Tokens

[EXO][PS] Audit Log Search for Sign Mailbox

[EXO][PS] Identify if user is part of a big AD Group

[EXO][PS] Find all the Distribution Groups a user is a member of.

[EXO] Setting up Room Finder in a Hybrid Environment