CD2 submissions table IP Address & Timezone

Question

We would like to obtain the IP address and timezone information related to the submission. However, this data is not available in the CD2 submissions table. How/where can we source this information?

KeithSmith_au · Answer

I don't know that you are going to be easily able to get the timezone information related to the submission, as all the timestamps are stored in UTC.  Timezones in Canvas are set on users, courses and the like, but I don't think there is anything that looks at the local timezone of wherever the web request is physically coming from (which would never be accurate anyway if a VPN is being used).

If you want the timezone of the user, then you can get that from the time_zone field in the user table.

For the IP address, you are going to have to join data from the web_logs, which will only give the last 30 days - so you will need to extract progressively and save if you really want it.  That is going to be an awfully large amount of data to extract just to get an IP address - and I am not sure what you are really going to do with that, since VPNs make the IP address not really reliable for anything.