I am trying to create a fairly static dashboard that shows a license day count down timer. I have the following CSV file with the following fields
Application Service, License Expiry Date
For example, the data looks like this (date,month, year)
ApplicationX, 31/12/2018
ApplicationY, 01/01/2019
What I am trying to do in SPLUNK is show a dashboard that looks like this:
ApplicationX | Number of Days to Expiry
The file is monitored for any changes.
This is the code I have written:
index="app_licensing"
| eval timenow=now()
| eval CurrentDate=strftime(now(),"%d-%m-%Y")
| eval Expiry=strptime("License Expiration Date", "%d-%m-%Y")
| eval "Expiry Time Left"=CurrentDate-Expiry
| table "Application Service", "Expiry Time Left"
OR
index="app_licensing"
| eval timenow=now()
| eval CurrentDate=strftime(now(),"%d-%m-%Y")
| eval Expiry=strptime("License Expiration Date", "%d-%m-%Y")
| eval "Expiry Time Left"=CurrentDate-Expiry
| stats count by "Application Service", "Expiry Time Left"
However, when this gets displayed, I do not see anything in the "Expiry Time Left" column or any data in the second stanza. Where have I gone wrong?
... View more