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

[pfabrizi]

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#

[pfabrizi · Accepted solution]

In c#

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

[niketn]

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

[pfabrizi]

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

[niketn]

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