Hello, I am attempting to parse a csv file, find the matching record by computer name and set a client setting with the values associated with that record.
My csv file has 4 comma seperated fields:
BFIXDBPROD,BFixDBProd,94410943001e3f90a83ff344d3a8619783d913ded5,141877
BFIXREPO,BFixRepo,94424349c7502ef224c1a74b7bb4d802a82ffaa790,141994
.
.
I am attempting find the corresponding record by locating the csv record matching computer name and then set variable SRVID to the 3rd column. Then set client setting based on that.
The the parameter action is failing.
So here is what I have do far:
// Prefetch cmdb-bigfix csv file
prefetch bigfix_update_file sha1:ce9e9b9ea1f27b3da2f828ef059e85bfb624f44c size:79709 http://10.15.100.100/repo/yum/bigfix/bigfix_update_file sha256:fd764aea4bec4830be12d464dca7204488b0ee25db71be78464d51af99d9f2e9
parameter āSRVIDā= "{ ( unique values of (it as trimmed string) of tuple string items 3 of concatenations ā, " of substrings separated by ā,ā of it ) of lines whose( exists (it as trimmed string) whose(it is contained by set of (it as string) of name of bes computers) of following text of last ā,ā of it ) of download file ābigfix_update_fileā }ā
// setting ā_CMDB_Srv_RecIDā="{ parameter āSRVIDā }" on ā{parameter āaction issue dateā of action}ā for client
// setting ā_CMDB_AssetTagā="{ parameter āASSETTAGā }" on ā{parameter āaction issue dateā of action}ā for client
Thanks for any help,
Terry