Getting Data In
Highlighted

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

Path Finder

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#

Tags (3)
0 Karma
Highlighted

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

Legend

@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")



| eval message="Happy Splunking!!!"


0 Karma
Highlighted

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

Path Finder

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

0 Karma
Highlighted

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

Legend

@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 🙂




| eval message="Happy Splunking!!!"


0 Karma
Highlighted

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

Path Finder

In c#

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

View solution in original post

0 Karma