Hi,
I would like to run a simple query against a database using splunk.
I would like to run the query as part of a dashboard.
The query is as follows:
| dbquery "DATEBASE_NAME" limit=1000 "select tr.* from schema.table tr where tr.date = '27-AUG-2014'
I would like the query to run against the date in question. So it would be like:
| dbquery "DATEBASE_NAME" limit=1000 "select tr.* from schema.table tr where tr.date = sysdate
I am having trouble defining the date as the dbquery needs to be the first item on the search line.
Can anyone help?
Thanks,
... View more