(imported topic written by ahousten91)
We’d like to add a new setting to every client called “Full Name” that has a unique value for each client. My thought is that one way to populate that setting would be from a spreadsheet that maps Computer Name (as shown in the Console) to this new property. I know how to do the first part: create the new setting on all the clients. Is there is a way to do the 2nd part? If not, is there a better way to do this?
(imported comment written by jgstew)
I’m confused, what are you trying to accomplish?
You want to set a setting called “Full Name” equal to the existing computer name? You can do this with a fixlet/task.
The relevance:
not exists setting “FullName” whose (value of it = computer name) of client
The actionscript:
setting “FullName”="{computer name}" on “{parameter “action issue date” of action}” for client
You can then deploy the fixlet to all computers.
(imported comment written by ahousten91)
No. I’m trying to create a new Computer Setting on all clients called “Full Name”. I know how to do that. The Setting Value is unique for each client. That unique value is found on a spreadsheet that shows it relative to the retrieved value called “Computer Name”
(imported comment written by jgstew)
Okay, I think I understand this better.
If you turn your spreadsheet into a CSV file with ComputerName,FullName or FullName,ComputerName you could do something like the following. I am assuming FullName,ComputerName below.
Inside the CSV file would look something like:
FullName1,ComputerName1
FullName2, ComputerName2
FullName3, ComputerName3
I have not tested this at all, FYI.
Relevance:
not exists setting “FullName” of client
Actionscript:
prefetch FullName.csv sha1:??? size:??? http://server/FullName.csv
// This line will prevent setting “FullName” if the computer name is not found, or if multiple possible matches are found.
// The relevance could be refined to use “=” and trimmed string to be more precise.
continue if{1 = number of lines whose(following text of first “,” of it contains computer name) of file “FullName.csv” of folder “__Download” of client folder}
setting “FullName”="{(it as trimmed string) of preceding text of first “,” of lines whose(following text of first “,” of it contains computer name) of file “FullName.csv” of folder “__Download” of client folder}" on “{parameter “action issue date” of action}” for client