Skip to content

Instantly share code, notes, and snippets.

@tidusx18

tidusx18/Query_Edit_Page_Access_History.sql

Created July 29, 2019 15:45
Show Gist options
  • Save tidusx18/6bf26e097354e5c284f9d9da57e466cd to your computer and use it in GitHub Desktop.
Save tidusx18/6bf26e097354e5c284f9d9da57e466cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Query_Edit_Page_Access_History.sql
Select DISTINCT r.timestamp AS timestamp_UTC, DATEADD(hour,-5,r.timestamp) AS timestamp_EST, p.unique_name AS username, u.name ,
r.remote_ip as IP, r.user_agent, r.URL
From requests r
LEFT JOIN pseudonym_dim p ON r.user_id = p.user_id
LEFT JOIN user_dim u ON r.user_id = u.id
Where url like '%courses/52212/quizzes/255725/edit%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment