List "missing" rows from csv RRS feed

  • Question

  • I have two csv files. One with a report from AD, containing user accounts created during last month, second is manually kept database, that should theoretically contain the same information, with some additional data needed for accounting. Each time anyone creates an account in AD, he should make an entry in the database as well. Since the database is kept manually, we need to check monthly, if all accounts, that were actually created, are also in the database, which we use to charge our customers. I imported the files to powershell, and now I need to list users, which are in the AD report, but are missing in the database. Column "UserPrincipalName" from AD report contains the same values as "login" column in database, so these columns can be used for the comparison.
    • Moved by Bill_Stewart Thursday, January 25, 2018 10:26 PM Unanswerable drive-by question
    Wednesday, November 15, 2017 3:18 PM