Excel list of users run against jss list

Valued Contributor II

I have an excel sheet of user names and user ids that I need to determine if they have a Mac and if so add them to a group.

There's almost 200 of them, so doing it one by one is not an attractive option. Anybody have any thoughts on how to do this programmatically?


Valued Contributor III

If it's just a one off event I would just export the list of computers from the JSS including the username and then either use a formula in excel to check if each item was present in the list (something like VLOOKUP) otherwise script recursively through the names checking the files against each other and spitting out a list of positives or negatives as required. I have done something similar to find Macs that had a Windows partition.