github.com/hhorn76/PowerShell/tree/master/KZbin

Hey, here you can find the code for all the videos: github.com/hhorn76/PowerShell/tree/master/KZbin

Hey, if($string) will just check if the variable has a value. here are some examples: $string = 'TEST' if ($string) { Write-Host "String has a value" } else { Write-Host "String has NO value" } $string = '' if ($string) { Write-Host "String has a value" } else { Write-Host "String has NO value" }

You could use the following: # please replace the xxx with values # create an array of services $arrName = @('spooler','xxx','xxx') # check each service and restart it foreach ($name in $arrName) { if ((Get-Service -Name $name).Status -eq 'Running') { Restart-Service -Name $name } } # wait for 10 seconds Start-Sleep 10 # check each service again and send an email if running foreach ($name in $arrName) { if ((Get-Service -Name $name).Status -eq 'Running') { Send-MailMessage -to xxx -from xxx -SmtpServer xxx } }

@@heikohorn thanks

just load them into the same variable

You have found your guru... what do you need?

@@heikohorn hello there. Do you have an email so I can send you a before and after sample? I can manually make one up to illustrate.. Its not very complex basically breaking out the Debit and Credit column on a bank download, and making both values positive.. This particular bank combines credits and debits having the debits negative ( noobs lol)..

i realize it's kinda randomly asking but do anybody know a good website to stream new movies online ?

@Tanner Emery Flixportal

@Brentley Ford thanks, signed up and it seems like a nice service :) I really appreciate it !

@Tanner Emery happy to help =)

The easiest way to output two text fields is to to use the following syntax: Write-Host "$($obj.Id) - $($obj.Name)" Please note to use the brackets and dollar symbols within the apprentices.

Here are two ways to connect to an Access Database: #Using ADODB.Connection $intOpenStatic=3 $intLockOptimistic=3 $strDb="C:\temp\Database1.accdb" $objConnection=New-Object -ComObject ADODB.Connection #Connection for Access 2007 and earlier $objConnection.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source=$strDb") #Connection for Access 2010 - 2016 $objConnection.Open("Provider = Microsoft.ACE.OLEDB.12.0; Data Source = $strDb") $objRecordSet=New-Object -ComObject ADODB.Recordset $strQuery="Select Field1 from Test" $objRecordSet.Open($strQuery, $objConnection, $intOpenStatic, $intLockOptimistic) $objRecordset.GetRows() $objRecordset.Close() $objConnection.Close() #Using System.Data.SqlClient.SqlConnection $strDb="C:\temp\Database1.accdb" $strQuery="Select * from Test" $objConnection=New-Object System.Data.OleDb.OleDbConnection $objConnection.ConnectionString="Provider=Microsoft.ACE.OLEDB.12.0; Data Source=$strDb" $objConnection.Open() $objCommand=New-Object System.Data.OleDb.OleDbCommand $objCommand.Connection=$objConnection $objCommand.CommandText=$strQuery $objCommand.ExecuteNonQuery() $reader=$objCommand.ExecuteReader() while ($reader.read()) { $reader.GetValue(0)#get the first column } $reader.close() $objConnection.close()

Hi Heiko, Thank you for your reply. I tried for first approach, it's throwing an error as " New-Object-ComObject :The term 'New-Object-ComObject' is not recognized as the name of a cmdlet, function, script file or operable program. I am working on my current assignment as "to send the CSV file data to MS Access 2003 using Power Shell". Please help on this.

Hi Heiko, I am trying with the below code to insert data from csv to ms access 2003 using Power Shell conn1.ps1:- $connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\db1.mdb" $conn=New-Object System.Data.Oledb.OledbConnection($connectstring) $conn.Open() $Users=Import-Csv -Delimiter "," -Path "C:\Users\users.csv" foreach ($User in $Users) { $first=$User.first $last=$User.last $cmd=$conn.CreateCommand() $cmd.CommandText="INSERT INTO Table1('$first','$last')" $cmd.ExecutionNonQuery() } $conn.close() ============================== After executing the above script getting the below error:- Exception calling "Open" with "0" arguments(s) :"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine. +At line:1 char:1 +$conn.open() +------------------- + CategoryInfo :NotSpecified: (:) [], MethodInvocationException +FullQualifiedErrorid:InvlidOperationException ===================================== Please suggest on this how to resolve.

+uma d Is Office 2003 installed on the Computer you are running PowerShell on?

Heiko Horn yes it's installed

+Ashutosh Chaturvedi You are using double quotes to start the String for the Execute parameter, but are closing it with a single quote. Close it with a double quote. If you use a single quote, PowerShell will force the text in quotes to be a sting. If you use a single quote, you could still add variables.

Here is an example: $strTest="Test String" Write-Host "Example $strTest" Will output Example Test String Write-Host 'Example $strTest' Will output Example $strTest Make sure you use either one, depending on the results you would like to have...

github.com/hhorn76/PowerShell

@@KRoc #XPath Predicates /root/node[1] /root/node[last()] /root/node[last()-1] /root/node[position()<3] //node[@attribute] //node[@attribute=value] /root/node[attribute>value] /root/node[attribute->value]/node #Get-Content Get-Content -Path $strXml #Opening XML files Invoke-Expression -Command $strXml Invoke-Item -Path $strXml #Reading Nodes from XML Select-Xml -Path "//node" $xml.root.node.node.attribute $xml.SelectSingleNode("//node[3]") $xml.SelectNodes("root/node/node") #ConverTo-Xml ConvertTo-Xml -InputObject $obj $obj | ConvertTo-Xml #Writing to a XML File $xml.Save($strXmlFilePath) #Export-Clixml $obj | Export-Clixml -Path $strXml #Import-Clixml Import-Clixml -Path $strXmlFilePath #Creating Xml $xml = New-Object -TypeName XML $xmlRoot = $xml.CreateElement($strName) $xml.AppendCild($xmlRoot) $xmlRoot.SetAttribute($strName, $strValue) $xmlL1 = xmlRoot.AppendChild($xml.CreateElement($strName)) #Remove Nodes form XML $nodes = $xml.selectNodes("$strXPath") Foreach ($item in $nodes) { $item.ParentNode.RemoveChild ($item)} #Remove All Nodes from XML $xml.ChildNodes.RemoveAl() #Replace Nodes in XML $oldNode = $xml.SelectSingleNode("//$($strRoot)[last()]") $newNode = $xml.CreateElement($strNode) $newNode.SetAttribute($strAttribute, $strValue) $xml.root.node.ReplaceChild($newNode, $oldNode)

Thanks for this great work. :-)

@@dieknisterkatze4806 #XPath Wildcards * @* node()