Import-Module ActiveDirectory $layout = "" $d = [DateTime]::Today.AddDays(-90) $stale = Get-ADComputer -Filter 'PasswordLastSet -le $d' -SearchBase "OU=WhereIStoreComputers,DC=pipe2,DC=Text,DC=com" -properties PasswordLastSet $liststale = $stale | Sort Name | ConvertTo-HTML -Head $layout Name, DistinguishedName, PasswordLastSet -Body "

The Following Machines Have Not Contacted the Domain in the Past 90 Days:

" $countstale = $stale | group-object computer | ConvertTo-HTML -Head $layout Count -Body "

Total Stale Machine Count

" $messageParameters = @{ Subject = "Stale Computer Report from $env:ComputerName.$env:USERDNSDOMAIN - $((Get-Date).ToShortDateString())" Body = $countstale, $liststale | Out-String From = "StaleMachines@pipe2text.com" To = "BC@pipe2text.com" SmtpServer = "smtp.pipe2.text.com" } Send-MailMessage @messageParameters -BodyAsHtml