The data I have uploaded contains 5 CSV files (mentioned) Apartments.csv, Buildings.csv, Maintenance.csv, Energy Consumption.csv, and Security Events.csv. I used the Splunk web interface and the Add Data feature to upload data. The search query used to search data within the index is index="SC_POC1" If I search for data in the index, then it shows data from the last uploaded table by default. As in the screenshot attached, the search query shows only data on Energy Consumption, however index "SC_POC1" contains data of all the 5 csvs. I can search for the other data like Apartments, Buildings by specifying in the query like index="SC_POC1" source="Apartments.csv", but then it will show only Apartments data. I want to show all the data (events) in the index. For this, I used joins on the tables so that I could search for the entire data of the index. but it also did not work. I want to know if there is a better way to do this. (I am using Splunk Enterprise)
... View more