Getting Data In

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

pfabrizi
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
1 Solution

pfabrizi
Path Finder

In c#

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

View solution in original post

0 Karma

pfabrizi
Path Finder

In c#

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

View solution in original post

0 Karma

niketnilay
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")
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma

pfabrizi
Path Finder

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

0 Karma

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

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!