Skip to content

Instantly share code, notes, and snippets.

Created May 10, 2017 13:56
Show Gist options
  • Save anonymous/6306d311285b37603563810f4b375028 to your computer and use it in GitHub Desktop.
Save anonymous/6306d311285b37603563810f4b375028 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