Well I think this is a perfect question for Splunk! you have 2 different sources: Albert and Bernard and you need to figure out a way of correlating the information of these two sources so I decided to give it a try and this is what I got:
1)First I created a CSV file with the dates Cheryl provided as input for them:
Month,Day
5,15
5,16
5,19
6,17
6,18
7,14
7,16
8,14
8,15
8,17
2)The first clue is that Albert (who only knows the Month) Knows that Bernard doesn't know. This means that we need to discard months with a unique day otherwise Bernard would know. This translate to splunk to:
|inputlookup dates.csv|stats count by Day |where count=1 | lookup dates.csv Day OUTPUT Month|fields Month
this will give us the Months we need to discard (May,June)
3)Now we can get a reduced list of the potential valid dates once we remove the dates from May and June:
|inputlookup dates.csv
|search NOT [|inputlookup dates.csv|stats count by Day |where count=1 | lookup dates.csv Day OUTPUT Month|fields Month]
4)From that reduced list Bernard was able to figure out the month because the Day he knew appeared only once in either July or Aug:
So we want this additionally reduced list:
|inputlookup dates.csv
|search NOT [|inputlookup dates.csv|stats count by Day |where count=1 | lookup dates.csv Day OUTPUT Month|fields Month]
|stats values(Month) AS Month,count by Day| where count=1
Now we have reduced the list to three potential dates: 7/16, 8/15 and 8/17
4)If Albert was able to figure out the date because the month he knew only gave him 1 option, so we need to get the month with only one possible date:
|inputlookup dates.csv
|search NOT [|inputlookup dates.csv|stats count by Day |where count=1 | lookup dates.csv Day OUTPUT Month|fields Month]
|stats values(Month) AS Month,count by Day| where count=1
|stats values(Day) as Day,count by Month |where count=1
So Cheryl's Bday is July 16th
is this the best way to correlate the information?
Best Regards
... View more