I run a script that does some checks on many, many servers.
If an error condition exists, I write out to a file ERR: with the
issue that was found. I'm wanting to be able to create some format
from this that will go into a spreadsheet. Really just looking for
ideas on what would be a good way to parse it that would be acceptable
for Excel. Like maybe grab a unique servername and all it's issues?
This is a cat *.out of the servers.out file created by my script.
srv.srv01.out:ERR: dummy not found for LTAPEDEV in pri srv01
srv.srv01.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
TSM srv01
srv.srv02.out:ERR: dummy not found for LTAPEDEV in pri srv02
srv.srv02.out:ERR: directory /dummy not found on filesystem in pri
srv02
srv.srv02.out:ERR: directory /dummy not found on filesystem in bkp
srv02
srv.srv02.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
TSM srv02
srv.srv03.out:ERR: dummy not found for LTAPEDEV in pri srv03
srv.srv03.out:ERR: directory /dummy not found on filesystem in pri
srv03
srv.srv03.out:ERR: directory /dummy not found on filesystem in bkp
srv03
srv.srv03.out:ERR: Found 127.0.0.1 on TSM Server in resolv.conf for
TSM srv03
