topic Re: How do I convert 'LastPhoneHome' value to time format? in Getting Data In

How do I convert 'LastPhoneHome' value to time format?

pfabrizi — Fri, 23 Mar 2018 13:35:42 GMT

I am building a DB to manage newly installed UF devices as well as the de-installed UF devices. I was wondering I was wondering how to convert the lastphonehome value to a readable time?

Thanks!

I am using the REST API in C#

Re: How do I convert 'LastPhoneHome' value to time format?

niketn — Fri, 23 Mar 2018 14:32:05 GMT

@pfabrizi, you can use C# to convert time from Unix Epoch time to String Time.

In Splunk you can try the following Search

| rest splunk_server=local /services/deployment/server/clients
| fieldformat lastPhoneHomeTime=strftime(lastPhoneHomeTime,"%Y/%m/%d %H:%M:%S.%3N")

Re: How do I convert 'LastPhoneHome' value to time format?

pfabrizi — Fri, 23 Mar 2018 15:14:06 GMT

Thank You, I have it working. appreciate your help.

Re: How do I convert 'LastPhoneHome' value to time format?

niketn — Fri, 23 Mar 2018 15:36:49 GMT

@pfabrizi, that's really great!!! If you figured out solution on your own may be you can add the approach as Answer and accept the same to mark this question as answered.

Happy Weekend 🙂

Re: How do I convert 'LastPhoneHome' value to time format?

pfabrizi — Tue, 27 Mar 2018 10:23:21 GMT

In c#

DateTime LastPhoneHome = DateTime.AddSeconds(lastphonehome).ToLocalTime();