Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save DWSR/e50bd3e47d8ed3edd10a4a7495bf31d3 to your computer and use it in GitHub Desktop.
Save DWSR/e50bd3e47d8ed3edd10a4a7495bf31d3 to your computer and use it in GitHub Desktop.
$SSO=get-content '.\Take out list (jay).txt'
$csv=import-csv .\MobileIron_Report_May_9_2017.csv
$CSV | ?{$SSO -contains $CSV."User ID"}
#Sample excel db
User ID Display Name
200000058 Monfiglio, Carlos (SSGA, Non-GE)
200000385 Golden, Hugh (SSGA, Non-GE)
#Sample SSO txt
200002724
200003841
200017477
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment