I tried this query again this morning and it now works in the dropdown:
host=XXXX sourcetype=XXXX | eval mostRecent=strftime(_time, "%B %d, %Y %I:%M%p")
| eval BuildAndDate = BuildID+" "+mostRecent
| stats count by source,BuildAndDate
I can't really pinpoint what exactly the solution was, but before now I deleted the BuildID field in Field Extractions, and re-extracted it from the xml file. I still tested out the query above after doing this but it did not work, but it surprisingly works this morning. The dropdown now produces the BuildAndDate field values as expected, and the new dashboard is being generated when a value is selected from the dropdown.
Side note: At some point I opened two tabs of the Search & Reporting app and ran the following query:
host=WP3L2M6VNX1 sourcetype=SAMBAXMLTEST | eval mostRecent=strftime(_time, "%B %d, %Y %I:%M%p")
| eval BuildAndDate = BuildID+" "+mostRecent
| stats count by source,BuildAndDate
In one of the tabs, the BuildID field did not show up in the fields area (it was also absent is the More fields area), while in the other tab, the BuildID field showed up. Both queries were ran using the same criteria (All time) & Verbose Mode. It was strange to see that the same query ran in the same app worked in one tab and not the other. It seems part of the app was not detecting the extracted field (don't know if that's possible), but I think this may be related to the dropdown issue.
Thanks so much @maciep for your assistance. 🙂 I believe you helped me drilldown to the potential cause of the issue.
Thanks @Sukisen1981 for the suggestion.
... View more