Read a whole csv of hosts and other information and ping the hosts only

[samuelng]

Hi, I have a csv file of hosts names and other information. And I want to use network toolkit to ping the hosts only.
my csv file is stored in an area C:\Splunk\WINDOWS\WMI

index=wmi source="C:\\Splunk\\Windows\\WMI\\IMFS_CMDBRawData.csv"
| fields Name
| lookup ping host as Name
| table Name _raw host sent received packet_loss min_ping max_ping avg_ping jitter return_code raw_output

However, I am only seeing Name and _raw

And this is the error message i receive: Script for lookup table 'ping' returned error code 1. Results may be incorrect.

[p_gurav]

Could you please try this:

index=wmi source="C:\\Splunk\\Windows\\WMI\\IMFS_CMDBRawData.csv"
 | lookup ping host as Name OUTPUTNEW
 | table Name _raw host sent received packet_loss min_ping max_ping avg_ping jitter return_code raw_output