powershelldatasetcomparehtml-email
Powershell Compare Datatables and Send Email
I need to find discrepancies from tables in two different SQL databases. The two tables have the same headers and look like below. If the sales of a same site, same store and same register in one database source are different with the other, then insert rows that have differences into email body and send it.
Email body should look like this
I tried Compare-Object and write to csv file to see if it works but unfortunately it did not save the differences in the csv file.
Compare-Object -ReferenceObject $table1 -DifferenceObject $table2 -Property $headers -PassThru | Select-Object * -ExcludeProperty SideIndicator | Export-Csv "$OuputFile diff.csv" -NoTypeInformation
Would you please help?
Thank you.
Solution
Below code works for me
> $csvXStore = import-csv -Path "$OuputFile XStore.csv" $csvXBR =
> import-csv -Path "$OuputFile XBR.csv"
>
>
> $diff = Compare-Object -Ref $csvXStore -Diff $csvXBR -Property Date,
> Store, Register, Sales, test -PassThru |
> # Where-Object SideIndicator -eq '<=' |
> Select-Object -Property * -ExcludeProperty SideIndicator
- Optimizing a PowerShell Script
- Powershell hashmap: nested filtering
- How to `Import-Module` in PowerShell to parent session/process?
- `Invoke-Conda` cannot catch any arguments after powershell 7.5.0 update
- close and 'save as' for 100 of MS Paint files at once?
- Powershell profile.ps1 cannot be loaded because its operation is blocked by software restriction policies
- How can I capture the value of an untranslated SID in a Try/Catch code block?
- PowerShell .Count returns 1 on empty array
- How can I filter out text twice in Powershell?
- SharePoint | Delete Version History using PnP PowerShell
- WinRM cannot complete the operation. Verify that the specified computer name is valid
- Using start-process in a loop, where some programs will have arguments and some don't; Way to not have if $Arguments -ne $null
- How can I set left/right column justification in Powershell's "format-table"
- Invalid operands found for operator -eq
- Detect when user cancels $host.ui.promptforchoice prompt
- How can I make sure Powershell will correctly render all non-latin characters into the output?
- How can I choose between $MyInvocation.ScriptName and $MyInvocation.PSCommandPath in PowerShell?
- Azure pipeline template: dynamically retrieve and story keyvault secrets
- Maintaining property order with get-member
- PowerShell - Return an array of all possible properties for an ADObject
- List objects vs. Arrays in PowerShell
- Run Invoke-Command in remote computer as administrator
- Authenticate to Azure with certificate from Linux
- How to recursively append to file name in powershell?
- Mapped network drives are not showing in My Computer
- Delete files in a folder except a list of extensions I specify
- How to open 'This PC' using CMD or Powershell?
- transfer the files from sub folder and sub folders recursively without specifying the folder name
- Im creating a VM using terraform code in GCP. I would like to inject a script that runs when the vm is created upon startup
- Remove-ItemProperty does not seem to work with -LiteralPath