I have 100 rows in DataBase.
I use Splunk DB connect app to pull data to splunk.
I see 98 rows indexed in Splunk.
How should I identify the missing 2 rows. (Assuming each row has a unique ID column in it) ?
Can you connect direct to the db outside of splunk with a client? If so, export the results to csv from splunk, and do the same from your client, and do a diff on the two csvs.