I have a csv file with the user list and I want to create an alert to monitor the user login failure alert from the user list. How do I use the lookup file, can you please let me know?
You need more than a CSV file to monitor the users. Presuming you are logging user login failures in Splunk, you can filter them using the CSV file like this.
index=foo [ | inputlookup mylookup.csv | fields <<user name field>> | rename <<user name field>> AS <<indexed user name field>> ]