topic Re: How to convert the value into months , days in Splunk Search

How to convert the value into months , days

jaibalaraman — Wed, 23 Oct 2024 00:01:55 GMT

I am building dashboard for UPS monitoring and i would like to convert a specific metric which is battery age.

Which give us some information about last battery changed however i would like to see the result in month , days like below

Expected outcome - 1 month 20 days.

current outcome below image

Spl query -

index="ups" indexed_is_service_aggregate=1 kpi=BatteryAge| lookup service_kpi_lookup _key as itsi_service_id OUTPUT title AS service_name | search service_name="MainUPS" |stats latest(alert_value) AS BatteryAge

Can anyone help me on this

Re: How to convert the value into months , days

MuS — Wed, 23 Oct 2024 20:46:54 GMT

Hi there,

try this :

| makeresults | eval alert_value=1060, BatteryAge=strftime(alert_value, "%m months %d days")

this will return:

but not sure you then can use it in a single value panel. Just give it a try.

Hope this helps ...

Cheers, MuS

Update:

This is based on the simple assumption every month has 4 weeks, because I'm not a mathematician nor scientist 😉

| makeresults | eval alert_value=1060, secs=alert_value*86400, months=round(secs/604800), days=round(alert_value - ((secs- (secs/604800)) / 60 /60 /24)) , alert_value = months ." months ". days ." days"

Re: How to convert the value into months , days

jaibalaraman — Wed, 23 Oct 2024 03:31:00 GMT

Hi Mus
Thanks for help

However when i run the query i am getting an error message
Error in 'makeresults' command: This command must be the first command of a search.

Re: How to convert the value into months , days

MuS — Wed, 23 Oct 2024 03:36:05 GMT

Just noticed that will not work 🙄 will ned some loop hooping to get months and then days ....

Re: How to convert the value into months , days

MuS — Wed, 23 Oct 2024 03:37:18 GMT

ah yes, this example needs to run on its own and will create sample events. but see my other reply this needs more logic

Re: How to convert the value into months , days

ITWhisperer — Wed, 23 Oct 2024 08:12:55 GMT

What unit of time is your BatteryAge in, seconds, hours, days?

How long is a month?

If your current day is the 5th of the month and the age equates to 40 days, what result would you expect?