Powershell | David J Kelly

The other day I came across a curious function. I had a requirement in a script to send an email. Now, when I wrote the script and tested everything was working fine. However when I ran the script from the test schedule, the script executed fine but no email was sent!

After a few hours of searching the system of the exchange host.

Log Name: Application
Source: MSExchangeTransport
Date: 9/5/2016 4:57:57 PM
Event ID: 1025
Task Category: SmtpReceive
Level: Error
Keywords: Classic
User: N/A
Computer: Server.domain.local
Description:
SMTP rejected a (P1) mail from 'importexport@domain.local' with 'Client SERVER' connector and the user authenticated as 'doamin\importexport'. The Active Directory lookup for the sender address returned validation errors. Microsoft.Exchange.Data.ProviderError
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
 <System>
 <Provider Name="MSExchangeTransport" />
 <EventID Qualifiers="49156">1025</EventID>
 <Level>2</Level>
 <Task>1</Task>
 <Keywords>0x80000000000000</Keywords>
 <TimeCreated SystemTime="2016-09-05T16:57:57.000000000Z" />
 <EventRecordID>410601</EventRecordID>
 <Channel>Application</Channel>
 <Computer>SERVER.domain.local</Computer>
 <Security />
 </System>
 <EventData>
 <Data>importexport@domain.local</Data>
 <Data>Client SERVER-01</Data>
 <Data>domain.local\importexport</Data>
 <Data>P1</Data>
 <Data>Microsoft.Exchange.Data.ProviderError</Data>
 </EventData>
</Event>

Log Name: Application

Source: MSExchangeTransport

Date: 9/5/2016 4:57:57 PM

Event ID: 1025

Task Category: SmtpReceive

Level: Error

Keywords: Classic

User: N/A

Computer: Server.domain.local

Description:

SMTP rejected a (P1) mail from '[email protected]' with 'Client SERVER' connector and the user authenticated as 'doamin\importexport'. The Active Directory lookup for the sender address returned validation errors. Microsoft.Exchange.Data.ProviderError

Event Xml:

<Channel>Application</Channel>

<Computer>SERVER.domain.local</Computer>

</System>

<Data>importexport@domain.local</Data>

<Data>Client SERVER-01</Data>

<Data>domain.local\importexport</Data>

<Data>Microsoft.Exchange.Data.ProviderError</Data>

</EventData>

</Event>

Hold the phone! under my account it worked perfectly but under the service account running the task scheduler it failed.

after a few failed attempts I noticed that if I mistyped the username and password while passing the credentials to the using the -Credentials $Creds argument.. it actually work… WFT

so I quickly worked out that if I passed “dummy” credentials the script worked.

To c create a dummy credential I first had to create a secure string. Then I could pass this script type into a new credential object… as so:

$sPassword = New-Object System.Security.SecureString

$creds = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "NT AUTHORITY\ANONYMOUS LOGON", $sPassword

$sPassword = New-Object System.Security.SecureString

$creds = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "NT AUTHORITY\ANONYMOUS LOGON", $sPassword

in just included this at the top of the script when declaring variables.

Send-MailMessage -To "User01 &lt;user01@example.com&gt;" -From "ITGroup &lt;itdept@example.com&gt;" -Cc "User02 &lt;user02@example.com&gt;" -bcc "ITMgr &lt;itmgr@example.com&gt;" -Subject "Don't forget today's meeting!" -Credential $creds

1	Send-MailMessage -To "User01 <[email protected]>" -From "ITGroup <[email protected]>" -Cc "User02 <[email protected]>" -bcc "ITMgr <[email protected]>" -Subject "Don't forget today's meeting!" -Credential $creds

WORKS!

Get-WmiObject win32_service -computer gdc-slo-p-slg01 |select-object @{Label="Server Name"; Expression={$_.__SERVER}}, Name , Startname |ConvertTo-HTML | Out-File "C:\test.htm"

1	Get-WmiObject win32_service -computer gdc-slo-p-slg01 \|select-object @{Label="Server Name"; Expression={$_.__SERVER}}, Name , Startname \|ConvertTo-HTML \| Out-File "C:\test.htm"

Get Services on remote computer and save to file

foreach ($computer in $computerlist ) {
  Write-Host $computer +" - Admin list"
  (Get-LocalGroupMembers $computer).members
  }

foreach ($computer in $computerlist ) {

Write-Host $computer +" - Admin list"

(Get-LocalGroupMembers $computer).members

}

Loads a list of computes and looks who is in the admin group

* get-localGroupMembers is a function:

<span class="powerShell__keyword">function</span> Get<span class="powerShell__operator">-</span>LocalGroupMembers  
{  
    <span class="powerShell__keyword">param</span>(  
        [parameter(Mandatory=<span class="powerShell__variable">$true</span>,ValueFromPipeline=<span class="powerShell__variable">$true</span>,ValueFromPipelineByPropertyName=<span class="powerShell__variable">$true</span>)]  
        [Alias(<span class="powerShell__string">"Name"</span>)]  
        [string]<span class="powerShell__variable">$ComputerName</span>,  
        [string]<span class="powerShell__variable">$GroupName</span> = <span class="powerShell__string">"Administrators"</span>  
    )  
      
    <span class="powerShell__keyword">begin</span> {}  
      
    <span class="powerShell__keyword">process</span>  
    {  
        <span class="powerShell__com"># If the account name of the computer object was passed in, it will </span> 
        <span class="powerShell__com"># end with a $. Get rid of it so it doesn't screw up the WMI query. </span> 
        <span class="powerShell__variable">$ComputerName</span> = <span class="powerShell__variable">$ComputerName</span>.Replace(<span class="powerShell__string">"`$"</span>, <span class="powerShell__string">''</span>)  
  
        <span class="powerShell__com"># Initialize an array to hold the results of our query. </span> 
        <span class="powerShell__variable">$arr</span> = @()  
  
        <span class="powerShell__com"># Get hostname of remote system.  $computername could reference cluster/alias name.  Need real hostname for subsequent WMI query.</span> 
        <span class="powerShell__variable">$hostname</span> = (<span class="powerShell__cmdlets">Get-WmiObject</span> <span class="powerShell__operator">-</span>ComputerName <span class="powerShell__variable">$ComputerName</span> <span class="powerShell__operator">-</span>Class Win32_ComputerSystem).Name 
 
        <span class="powerShell__variable">$wmi</span> = <span class="powerShell__cmdlets">Get-WmiObject</span> <span class="powerShell__operator">-</span>ComputerName <span class="powerShell__variable">$ComputerName</span> <span class="powerShell__operator">-</span>Query <span class="powerShell__string">"SELECT * FROM Win32_GroupUser WHERE GroupComponent=`"</span>Win32_Group.Domain=<span class="powerShell__string">'$Hostname'</span>,Name=<span class="powerShell__string">'$GroupName'</span>`<span class="powerShell__string">""</span>  
  
        <span class="powerShell__com"># Parse out the username from each result and append it to the array. </span> 
        <span class="powerShell__keyword">if</span> (<span class="powerShell__variable">$wmi</span> <span class="powerShell__operator">-</span>ne <span class="powerShell__variable">$null</span>)  
        {  
            <span class="powerShell__keyword">foreach</span> (<span class="powerShell__variable">$item</span> <span class="powerShell__keyword">in</span> <span class="powerShell__variable">$wmi</span>)  
            {  
                <span class="powerShell__variable">$data</span> = <span class="powerShell__variable">$item</span>.PartComponent <span class="powerShell__operator">-</span>split <span class="powerShell__string">"\,"</span> 
                <span class="powerShell__variable">$domain</span> = (<span class="powerShell__variable">$data</span>[0] <span class="powerShell__operator">-</span>split <span class="powerShell__string">"="</span>)[1] 
                <span class="powerShell__variable">$name</span> = (<span class="powerShell__variable">$data</span>[1] <span class="powerShell__operator">-</span>split <span class="powerShell__string">"="</span>)[1] 
                <span class="powerShell__variable">$arr</span> <span class="powerShell__operator">+</span>= (<span class="powerShell__string">"$domain\$name"</span>).Replace(<span class="powerShell__string">""</span><span class="powerShell__string">""</span>,<span class="powerShell__string">""</span>) 
                [Array]::<span class="powerShell__alias">Sort</span>(<span class="powerShell__variable">$arr</span>) 
            }  
        }  
  
        <span class="powerShell__variable">$hash</span> = @{ComputerName=<span class="powerShell__variable">$ComputerName</span>;Members=<span class="powerShell__variable">$arr</span>}  
        <span class="powerShell__keyword">return</span> <span class="powerShell__variable">$hash</span>  
    }  
      
    <span class="powerShell__keyword">end</span>{}  
}

function Get-LocalGroupMembers

{

param(

[parameter(Mandatory=$true,ValueFromPipeline=$true,ValueFromPipelineByPropertyName=$true)]

[Alias("Name")]

[string]$ComputerName,

[string]$GroupName = "Administrators"

)

begin {}

process

{

# If the account name of the computer object was passed in, it will

# end with a $. Get rid of it so it doesn't screw up the WMI query.

$ComputerName = $ComputerName.Replace("`$", '')

# Initialize an array to hold the results of our query.

$arr = @()

# Get hostname of remote system. $computername could reference cluster/alias name. Need real hostname for subsequent WMI query.

$hostname = (Get-WmiObject -ComputerName $ComputerName -Class Win32_ComputerSystem).Name

$wmi = Get-WmiObject -ComputerName $ComputerName -Query "SELECT * FROM Win32_GroupUser WHERE GroupComponent=`"Win32_Group.Domain='$Hostname',Name='$GroupName'`""

# Parse out the username from each result and append it to the array.

if ($wmi -ne $null)

{

foreach ($item in $wmi)

{

$data = $item.PartComponent -split "\,"

$domain = ($data[0] -split "=")[1]

$name = ($data[1] -split "=")[1]

$arr += ("$domain\$name").Replace("""","")

[Array]::Sort($arr)

}

$hash = @{ComputerName=$ComputerName;Members=$arr}

return $hash

}

end{}

}

Found Here

https://gallery.technet.microsoft.com/scriptcenter/List-local-group-members-c25dbcc4

David J Kelly

Tag Archives: Powershell

Powershell send-mailmessage from task scheduler

Powershell Query Services on Remote Computer

More System and Enterprise Architecture…