We are trying to understand how frequent our users access UFT mobile, and have pulled information from the lastLoginTime field; however the data appears to be encrypted and is unreadable. Here is what we see: lastLoginTime 1549663156236 1575007407594 1548464913203 1566792284724 1548638486289 1548651040372 154864568797 How do we decrypt this information to better understand the information? Any assistance you can provide will be greatly appreciated. Thank you.

Hello, Those times are provided in milliseconds so you can either use a website like https://www.epochconverter.com/ to help you get the information if it is only a few values that you need to convert. Another alternative, would be pasting the information in Excel and using a formula to convert the information. Example: (Cell_with_milliseconds / 86400000) 25569 i.e. assuming that the value is in column A, you can add this formula on column B: (A1 / 86400000) 25569 Alternatively for time zone, you can change the formula to =((Cell_with_milliseconds (TimezoneOffset*3600000))/86400000) 25569, so for pacific time, you would enter -8 in for TimezoneOffset Example: ((A1 (-8*3600000))/86400000) 25569 NOTE : You still need to select the column with the formula and change the format to date/time so it doesn't display a number. I hope that helps!

UFT Digital Lab (formerly UFT Mobile) User Discussions

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to decrypt users' last login time

CEBohall3 over 4 years ago

We are trying to understand how frequent our users access UFT mobile, and have pulled information from the lastLoginTime field; however the data appears to be encrypted and is unreadable. Here is what we see:

lastLoginTime
1549663156236
1575007407594
1548464913203
1566792284724
1548638486289
1548651040372
154864568797

How do we decrypt this information to better understand the information? Any assistance you can provide will be greatly appreciated.

Thank you.

Tags:

PostGRE SQL

UFT Mobile

Top Replies

l_rolfe over 4 years ago +2 verified

Hello, Those times are provided in milliseconds so you can either use a website like https://www.epochconverter.com/ to help you get the information if it is only a few values that you need to convert…

Verified Answer

0 l_rolfe over 4 years ago

Hello,

Those times are provided in milliseconds so you can either use a website like https://www.epochconverter.com/ to help you get the information if it is only a few values that you need to convert.

Another alternative, would be pasting the information in Excel and using a formula to convert the information.

Example:

(Cell_with_milliseconds / 86400000) 25569
i.e. assuming that the value is in column A, you can add this formula on column B:
(A1 / 86400000) 25569

Alternatively for time zone, you can change the formula to =((Cell_with_milliseconds (TimezoneOffset*3600000))/86400000) 25569, so for pacific time, you would enter -8 in for TimezoneOffset
Example:
((A1 (-8*3600000))/86400000) 25569

NOTE: You still need to select the column with the formula and change the format to date/time so it doesn't display a number.

I hope that helps!
Cancel
Vote Up +2 Vote Down

Cancel
0 CEBohall3 over 4 years ago in reply to l_rolfe

This worked perfectly. Thank you!
Cancel
Vote Up 0 Vote Down

Cancel

Menu

UFT Digital Lab (formerly UFT Mobile) User Discussions

Verified Answers

How to decrypt users' last login time

Tags:

Top Replies

Verified Answer

Resources