June 2018 – ControllingTheInter.net

Pulling Data from Workday with powershell for Active Employees.

Grab a copy of Workday Powershell API here at GitHub and place it in your “Program Files\WindowsPowerShell\Modules” folder.

Remove-Variable * -ErrorAction SilentlyContinue; Remove-Module *; $error.Clear(); Clear-Host
function WriteXmlToScreen ([xml]$xml)
{
    $StringWriter = New-Object System.IO.StringWriter;
    $XmlWriter = New-Object System.Xml.XmlTextWriter $StringWriter;
    $XmlWriter.Formatting = "indented";
    $xml.WriteTo($XmlWriter);
    $XmlWriter.Flush();
    $StringWriter.Flush();
    Write-Output $StringWriter.ToString();
}
function Get-XPath($n) {
  if ( $n.GetType().Name -ne 'XmlDocument' ) {
    "{0}/{1}" -f (Get-XPath $n.ParentNode), $n.Name
  }
}
$scriptpath = $MyInvocation.MyCommand.Path
$dir = Split-Path $scriptpath
Push-Location $dir
$user = 'ISU_INT001_Provisioning'
$SecretPassword = 'Pazzsw0rdGoezHere'
$pair = "$($user):$($SecretPassword)"
$where = 'https://services1.myworkday.com/ccx/service/customreport1/[YOUR TENANT]/ISU_INT001_Provisioning/RPT_INT001_Provisioning_Active_Workers_Data_Outbound?format=simplexml'
$encodedCreds = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($pair))
$basicAuthValue = "Basic $encodedCreds"
$Headers = @{
    Authorization = $basicAuthValue
}
[xml]$myxml = Invoke-WebRequest -Uri $where -Headers $Headers
WriteXmlToScreen $myxml
[string]$CreatePipedFile = ""
[string]$ModifyPipedFile = ""
#$nodes = $myxml.SelectNodes('//*')
$nodes = $myxml.SelectNodes('//*')
foreach ($node in $nodes) {
    #if ($node.Name -ne "wd:Report_Data" -AND $node.name -ne "wd:Report_Entry")
    if ($node.Name -ne "wd:Report_Data")
    {
        if ($node.name -eq "wd:Report_Entry")
        {
            &lt;#
            Write-Host "=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-="
            Write-Host "Name: " $node.Name
            Write-Host "Worker:" $node.Worker
            Write-Host "Worker_Type:" $node.Worker_Type
            switch($node.Worker_Type.ToLower())
            {
                "yes"   { $_ = "y" }
                "employee"     {$Worker_Type = "EMP"}
                "contingent worker"     { $Worker_Type = "CONT" }
                default { "You entered No." }
            }
            Write-Host "Emp_ID:" $node.Emp_ID
            Write-Host "Dep-Cd:" $node.Dep_Cd
            Write-Host "Dep_Name:" $node.Dep_Name
            Write-Host "Position_ID:" $node.Position_ID
            Write-Host "Position_Title:" $node.Position_Title
            Write-Host "L_Name:" $node.L_Name
            Write-Host "M_Name:" $node.M_Name
            Write-Host "F_Name:" $node.F_Name
            Write-Host "Entity:" $node.Entity
            Write-Host "Manager_ID:" $node.Manager_ID
            Write-Host "Director_ID:" $node.Director_ID
            Write-Host "Perf_Name:" $node.Pref_Name
            Write-Host "Leaving:" $node.LV_St_dt
            Write-Host "Return:" $node.Est_Ret_frm_leave
            Write-Host "Active:" $node.Active
            Write-Host "SSN: ***-**-****"
            Write-Host "Hire_Date:" $node.Hire_Date
            Write-Host "WorkEmail:" $node.WorkEmail
            Write-Host "`n"
            #&gt;
            #Fix Date without '-'
            #Add leave dates to be added, fix 'AC' value
            #FT10 FT08 etc etc
            #Append hire date to end
            [datetime]$HireDate = $node.Hire_Date
            [datetime]$HireCompDate = $node.Hir_Comp_Dttm
            if (($HireDate -gt (Get-Date) -and $HireDate -lt (Get-Date).AddDays(14)) -or ($HireCompDate -lt (Get-Date).AddDays(1) -and $HireCompDate -gt (Get-Date).AddDays(-14))) #Testing for Newhire / Create
            {
                if ([string]::IsNullOrEmpty($node.WorkEmail))
                {
                    $PipedFile += "BLANK!"
                }
                $CreatePipedFile += "!CREATE_USER|" + $node.Emp_ID + "|" + $node.Dep_Cd + "|" + $node.Position_ID + "|" + $node.F_Name + "|" + $node.M_Name + "|" + $node.L_Name + "|" + $node.Entity + "|" + $node.Director_ID + "|" + $node.Dep_Name + "|" + $node.Position_title + "|" + ($node.Hire_Date -replace '-','') + "|" + ($node.SSN -replace '-','') + "|" + $node.Emp_Type + "|" + $node.WorkEmail + "|" + $node.Worker_Type +"`r`n" #$Worker_Type
            }
            ElseIf ($HireDate -gt (Get-Date).AddDays(14))
            {
                Write-Host "User is in the future!" $node.Emp_ID " - " $HireDate
            }
            else
            {
                if ([string]::IsNullOrEmpty($node.WorkEmail))
                {
                    $PipedFile += "BLANK!"
                }
                $ModifyPipedFile += "!MODIFY_USER|" + $node.Emp_ID + "|" + $node.Dep_Cd + "|" + $node.Dep_Name + "|" + $node.Position_ID + "|" + $node.Position_title + "|" + $node.L_Name + "|" + $node.M_Name + "|" + $node.F_Name + "|" + $node.Entity + "|" + $node.Director_ID + "|" + $node.Pref_Name + "|" + ($node.LV_St_dt -replace '-','') +"|" + ($node.Est_Ret_frm_leave -replace '-','') + "|AC|" + ($node.SSN -replace '-','') + "|" + ($node.Hire_Date -replace '-','') + "|" + $node.Emp_Type + "|" + $node.WorkEmail + "|" + $node.Worker_Type +"`r`n"
            }
            #" =-=-=-=-= " $node.InnerText " | "
        }
        #Get-XPath($node)
        #$sid = $node.attributes['wd:Worker'].value
        #$dispName = $node.attributes['wd:Emp_ID'].value
        #$obj = new-object psobject -prop @{SID=$sid;DISPNAME=$dispName}
        #$objs += $obj
    }
}
#$objs
Pop-Location
Write-Host $CreatePipedFile
Write-Host $ModifyPipedFile
$CreatePipedFile | Set-Content 'C:\RecentHires.txt'
$ModifyPipedFile | Set-Content 'C:\BeenHereAwhile.txt'

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

Remove-Variable * -ErrorAction SilentlyContinue; Remove-Module *; $error.Clear(); Clear-Host

function WriteXmlToScreen ([xml]$xml)

{

$StringWriter = New-Object System.IO.StringWriter;

$XmlWriter = New-Object System.Xml.XmlTextWriter $StringWriter;

$XmlWriter.Formatting = "indented";

$xml.WriteTo($XmlWriter);

$XmlWriter.Flush();

$StringWriter.Flush();

Write-Output $StringWriter.ToString();

}

function Get-XPath($n) {

if ( $n.GetType().Name -ne 'XmlDocument' ) {

"{0}/{1}" -f (Get-XPath $n.ParentNode), $n.Name

}

$scriptpath = $MyInvocation.MyCommand.Path

$dir = Split-Path $scriptpath

Push-Location $dir

$user = 'ISU_INT001_Provisioning'

$SecretPassword = 'Pazzsw0rdGoezHere'

$pair = "$($user):$($SecretPassword)"

$where = 'https://services1.myworkday.com/ccx/service/customreport1/[YOUR TENANT]/ISU_INT001_Provisioning/RPT_INT001_Provisioning_Active_Workers_Data_Outbound?format=simplexml'

$encodedCreds = [System.Convert]::ToBase64String([System.Text.Encoding]::ASCII.GetBytes($pair))

$basicAuthValue = "Basic $encodedCreds"

$Headers = @{

Authorization = $basicAuthValue

}

[xml]$myxml = Invoke-WebRequest -Uri $where -Headers $Headers

WriteXmlToScreen $myxml

[string]$CreatePipedFile = ""

[string]$ModifyPipedFile = ""

#$nodes = $myxml.SelectNodes('//*')

$nodes = $myxml.SelectNodes('//*')

foreach ($node in $nodes) {

#if ($node.Name -ne "wd:Report_Data" -AND $node.name -ne "wd:Report_Entry")

if ($node.Name -ne "wd:Report_Data")

{

if ($node.name -eq "wd:Report_Entry")

{

Write-Host "=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-="

Write-Host "Name: " $node.Name

Write-Host "Worker:" $node.Worker

Write-Host "Worker_Type:" $node.Worker_Type

switch($node.Worker_Type.ToLower())

{

"yes" { $_ = "y" }

"employee" {$Worker_Type = "EMP"}

"contingent worker" { $Worker_Type = "CONT" }

default { "You entered No." }

}

Write-Host "Emp_ID:" $node.Emp_ID

Write-Host "Dep-Cd:" $node.Dep_Cd

Write-Host "Dep_Name:" $node.Dep_Name

Write-Host "Position_ID:" $node.Position_ID

Write-Host "Position_Title:" $node.Position_Title

Write-Host "L_Name:" $node.L_Name

Write-Host "M_Name:" $node.M_Name

Write-Host "F_Name:" $node.F_Name

Write-Host "Entity:" $node.Entity

Write-Host "Manager_ID:" $node.Manager_ID

Write-Host "Director_ID:" $node.Director_ID

Write-Host "Perf_Name:" $node.Pref_Name

Write-Host "Leaving:" $node.LV_St_dt

Write-Host "Return:" $node.Est_Ret_frm_leave

Write-Host "Active:" $node.Active

Write-Host "SSN: ***-**-****"

Write-Host "Hire_Date:" $node.Hire_Date

Write-Host "WorkEmail:" $node.WorkEmail

Write-Host "`n"

#Fix Date without '-'

#Add leave dates to be added, fix 'AC' value

#FT10 FT08 etc etc

#Append hire date to end

[datetime]$HireDate = $node.Hire_Date

[datetime]$HireCompDate = $node.Hir_Comp_Dttm

if (($HireDate -gt (Get-Date) -and $HireDate -lt (Get-Date).AddDays(14)) -or ($HireCompDate -lt (Get-Date).AddDays(1) -and $HireCompDate -gt (Get-Date).AddDays(-14))) #Testing for Newhire / Create

{

if ([string]::IsNullOrEmpty($node.WorkEmail))

{

$PipedFile += "BLANK!"

}

}

ElseIf ($HireDate -gt (Get-Date).AddDays(14))

{

Write-Host "User is in the future!" $node.Emp_ID " - " $HireDate

}

else

{

if ([string]::IsNullOrEmpty($node.WorkEmail))

{

$PipedFile += "BLANK!"

}

}

#" =-=-=-=-= " $node.InnerText " | "

}

#Get-XPath($node)

#$sid = $node.attributes['wd:Worker'].value

#$dispName = $node.attributes['wd:Emp_ID'].value

#$obj = new-object psobject -prop @{SID=$sid;DISPNAME=$dispName}

#$objs += $obj

}

#$objs

Pop-Location

Write-Host $CreatePipedFile

Write-Host $ModifyPipedFile

$CreatePipedFile | Set-Content 'C:\RecentHires.txt'

$ModifyPipedFile | Set-Content 'C:\BeenHereAwhile.txt'

Judgement of Acquittal

So after a good 8 month wait, here are the results! Previous Post: http://controllingtheinter.net/2018/06/18/waiting-on-results-from-appeal/

Getting 3TX and 1 RX out of a Wemos D1 Mini Pro and the NONOS-SDK

So last night, I wanted to see if I could create three TX’s out of the Wemos D1. I was able to accomplish this using the TX/RX swapped to D7/D8, Pin D4 for UART1_TX_BK and USB-COM using TX (After swap is RTS / GPIO1). and Voila! Done. Something to note, With this change I then …

Continue reading “Getting 3TX and 1 RX out of a Wemos D1 Mini Pro and the NONOS-SDK”

Pushing Powershell remotely with DSC

Using the following code I was able to push Firewall settings to multiple machines.

#https://gallery.technet.microsoft.com/scriptcenter/xNetworking-Module-818b3583
Configuration ScriptTest
{
    param
    (
        [string[]] $NodeName = 'Localhost'
    )
    Import-DscResource –ModuleName 'PSDesiredStateConfiguration'
    Node $NodeName
    {
        Script EnableFirewall
        {
            # Must return a hashtable with at least one key
            # named 'Result' of type String
            GetScript = {
                Return @{
                    Result = [string]$(netsh advfirewall show allprofiles)
                }
            }
            # Must return a boolean: $true or $false
            TestScript = {
                If ((netsh advfirewall show allprofiles) -like "State*off*") {
                    Write-Verbose "One or more firewall profiles are off"
                    Return $false
                } Else {
                    Write-Verbose "All firewall profiles are on"
                    Return $false #return false as well to always run the SetScript on the remote server
                }
            }
            # Returns nothing
            SetScript = {
                Write-Verbose "Setting all firewall profiles to on"
                #netsh advfirewall set allprofiles state on
                Remove-NetFirewallRule -All
            }
        }
    }
    }
}
Configuration DSCFirewallRule
{
    param
    (
        [string[]] $NodeName = 'Localhost'
    )
    Import-DSCResource -ModuleName xNetworking
    Node $NodeName
    {
        xFirewall Firewall1
        {
            Access      = 'Block'
            Name        = 'NotePadFirewallRule'
            DisplayName = 'Firewall Rule for Notepad.exe'
            Ensure      = 'Present'
            Profile     = ('Domain', 'Private')
            Direction   = 'OutBound'
            RemotePort  = ('8080', '8081')
            LocalPort   = ('9080', '9081')
            Protocol    = 'TCP'
            Description = 'Firewall Rule for Notepad.exe'
            Service = 'WinRM'
            State = 'Enabled'
        }
        xFirewall Firewall2
        {
            Access      = 'Allow'
            Name        = 'NotePad++FirewallRule'
            DisplayName = 'Firewall Rule for Notepad++.exe'
            Ensure      = 'Present'
            Profile     = ('Domain', 'Private')
            Direction   = 'OutBound'
            RemotePort  = ('8082', '8084')
            LocalPort   = ('9086', '9085')
            Protocol    = 'TCP'
            Description = 'Firewall Rule for Notepad++.exe'
            Service = 'WinRM'
            State = 'Enabled'
        }
    }
}
#You only need to create checksums for PULL HTTP(s) methods
New-DSCCheckSum –ConfigurationPath .\SimpleMetaConfigurationForPull –OutPath .\ScriptTest -Verbose -Force
New-DSCCheckSum –ConfigurationPath .\SimpleMetaConfigurationForPull –OutPath .\DSCFirewallRule -Verbose -Force
ScriptTest –nodename ‘LocalHost’,‘server1’,’server2’,’server3’ #Creates a folder with that name
DSCFirewallRule –nodename ‘LocalHost’,‘server1’,’server2’,’server3’ #Creates a folder with that name
#Push the configuration to the Target nodes, Comment this out if your just generating the MOF(s) for a pull method.
Start-DscConfiguration -Path .\ScriptTest -Wait -Force -Verbose #Clears Firewall Rules
Start-DscConfiguration -Path .\DSCFirewallRule -Wait -Force -Verbose #Sets them

#https://gallery.technet.microsoft.com/scriptcenter/xNetworking-Module-818b3583

Configuration ScriptTest

{

param

(

[string[]] $NodeName = 'Localhost'

)

Import-DscResource –ModuleName 'PSDesiredStateConfiguration'

Node $NodeName

{

Script EnableFirewall

{

# Must return a hashtable with at least one key

# named 'Result' of type String

GetScript = {

Return @{

Result = [string]$(netsh advfirewall show allprofiles)

}

# Must return a boolean: $true or $false

TestScript = {

If ((netsh advfirewall show allprofiles) -like "State*off*") {

Write-Verbose "One or more firewall profiles are off"

Return $false

} Else {

Write-Verbose "All firewall profiles are on"

Return $false #return false as well to always run the SetScript on the remote server

}

# Returns nothing

SetScript = {

Write-Verbose "Setting all firewall profiles to on"

#netsh advfirewall set allprofiles state on

Remove-NetFirewallRule -All

}

Configuration DSCFirewallRule

{

param

(

[string[]] $NodeName = 'Localhost'

)

Import-DSCResource -ModuleName xNetworking

Node $NodeName

{

xFirewall Firewall1

{

Access = 'Block'

Name = 'NotePadFirewallRule'

DisplayName = 'Firewall Rule for Notepad.exe'

Ensure = 'Present'

Profile = ('Domain', 'Private')

Direction = 'OutBound'

RemotePort = ('8080', '8081')

LocalPort = ('9080', '9081')

Protocol = 'TCP'

Description = 'Firewall Rule for Notepad.exe'

Service = 'WinRM'

State = 'Enabled'

}

xFirewall Firewall2

{

Access = 'Allow'

Name = 'NotePad++FirewallRule'

DisplayName = 'Firewall Rule for Notepad++.exe'

Ensure = 'Present'

Profile = ('Domain', 'Private')

Direction = 'OutBound'

RemotePort = ('8082', '8084')

LocalPort = ('9086', '9085')

Protocol = 'TCP'

Description = 'Firewall Rule for Notepad++.exe'

Service = 'WinRM'

State = 'Enabled'

}

#You only need to create checksums for PULL HTTP(s) methods

New-DSCCheckSum –ConfigurationPath .\SimpleMetaConfigurationForPull –OutPath .\ScriptTest -Verbose -Force

New-DSCCheckSum –ConfigurationPath .\SimpleMetaConfigurationForPull –OutPath .\DSCFirewallRule -Verbose -Force

ScriptTest –nodename ‘LocalHost’,‘server1’,’server2’,’server3’ #Creates a folder with that name

DSCFirewallRule –nodename ‘LocalHost’,‘server1’,’server2’,’server3’ #Creates a folder with that name

#Push the configuration to the Target nodes, Comment this out if your just generating the MOF(s) for a pull method.

Start-DscConfiguration -Path .\ScriptTest -Wait -Force -Verbose #Clears Firewall Rules

Start-DscConfiguration -Path .\DSCFirewallRule -Wait -Force -Verbose #Sets them

Now the following script above will create .MOF files that will then Now we have to create a Pull Server. Well have to do it like this for Server 2008R2 Src: https://davewyatt.wordpress.com/2014/06/07/how-to-install-a-dsc-pull-server-on-windows-2008-r2/ Or for Server 2012

configuration CreatePullServer
{
    param
    (
        [string[]]$ComputerName = 'localhost'
    )
Import-DSCResource -ModuleName xPSDesiredStateConfiguration
Node $ComputerName
{
    WindowsFeature DSCServiceFeature
    {
        Ensure = "Present"
        Name   = "DSC-Service"
    }
    xDscWebService PSDSCPullServer
    {
        Ensure = "Present"
        EndpointName = "PSDSCPullServer"
                Port = 8080
                PhysicalPath = "$env:SystemDrive\inetpub\wwwroot\PSDSCPullServer"
                CertificateThumbPrint = "AllowUnencryptedTraffic"
                ModulePath = "$env:PROGRAMFILES\WindowsPowerShell\DscService\Modules"
                ConfigurationPath = "$env:PROGRAMFILES\WindowsPowerShell\DscService\Configuration"
                State = "Started"
                DependsOn = "[WindowsFeature]DSCServiceFeature"
        }
    xDscWebService PSDSCComplianceServer
        {
            Ensure = "Present"
            EndpointName = "PSDSCComplianceServer"
            Port = 9080
            PhysicalPath = "$env:SystemDrive\inetpub\wwwroot\PSDSCComplianceServer"
            CertificateThumbPrint = "AllowUnencryptedTraffic"
            State = "Started"
            IsComplianceServer = $true
            DependsOn = ("[WindowsFeature]DSCServiceFeature",
                                       "[xDSCWebService]PSDSCPullServer")
        }
    }
}
CreatePullServer

configuration CreatePullServer

{

param

(

[string[]]$ComputerName = 'localhost'

)

Import-DSCResource -ModuleName xPSDesiredStateConfiguration

Node $ComputerName

{

WindowsFeature DSCServiceFeature

{

Ensure = "Present"

Name = "DSC-Service"

}

xDscWebService PSDSCPullServer

{

Ensure = "Present"

EndpointName = "PSDSCPullServer"

Port = 8080

PhysicalPath = "$env:SystemDrive\inetpub\wwwroot\PSDSCPullServer"

CertificateThumbPrint = "AllowUnencryptedTraffic"

ModulePath = "$env:PROGRAMFILES\WindowsPowerShell\DscService\Modules"

ConfigurationPath = "$env:PROGRAMFILES\WindowsPowerShell\DscService\Configuration"

State = "Started"

DependsOn = "[WindowsFeature]DSCServiceFeature"

}

xDscWebService PSDSCComplianceServer

{

Ensure = "Present"

EndpointName = "PSDSCComplianceServer"

Port = 9080

PhysicalPath = "$env:SystemDrive\inetpub\wwwroot\PSDSCComplianceServer"

CertificateThumbPrint = "AllowUnencryptedTraffic"

State = "Started"

IsComplianceServer = $true

DependsOn = ("[WindowsFeature]DSCServiceFeature",

"[xDSCWebService]PSDSCPullServer")

}

CreatePullServer

After the pull …

Continue reading “Pushing Powershell remotely with DSC”

Create a Dedicated Debug port on the ESP8266 NONOS SDK

So, The Wemos D1 Mini pro is the board I use to program the NONOS SDK right now currently. The downside is it only exposes one UART interface (UART0) and with that comes some minor issues. 1: If you connect an FTDI chip to this port the TX line from the FTDI is always HIGH …

Continue reading “Create a Dedicated Debug port on the ESP8266 NONOS SDK”