Hello, I’m looking for a way to be able to set endpoint group assignments via the entries in an excel spreadsheet (or .csv). The spreadsheet would have the hostname in one column and the group assignment name in the other column,
Here’s the scenario:
We need to patch some AWS machines that are TURNED OFF the majority of the time, and can’t be powered on except for a patch window (4 hours a month)
The Challenge:
We cannot use a local file or setting on the machine (which works perfectly BTW), as a large number of these will be turned off except for patch windows or when needed (AWS machines). They would only be able to receive updates to the file or group assignment when online. We’d like to have the group assignment set so that when the machine does come online, it just drops into the group needed…based off the single spreadsheet/.csv file.
Theoretically the machines group assignments could change daily. Realistically, we will have approx. 10 out of 2000 servers change group memberships monthly (which will be updated on that single spreadsheet/.csv file.)
Our Goal:
Client is wanting to see if possible to base BigFix group assignment off an external Excel or .csv file, that would be stored on a remote system/endpoint/server/webshare.
I’ve used the method of creating a setting, based off of line in a text file that is on the local machine, to determine group membership, but haven’t figured out how to do it this way yet.
Has anyone tried this, or know how this might be accomplished?
We’d prefer automatic groups, but would use manual if we had to. Any advice is appreciated!
Thank you,