Skip to content

Instantly share code, notes, and snippets.

@StaniTr StaniTr/Part2

Created Jan 30, 2015
Embed
What would you like to do?
Basic Queries - Records Insight (cnt logon, logoff, id...)
--all records: 17403
Select count(actionname) as allLogs
from puzzSessions;
--logOFF: 8687
Select count(ActionName) as cntLOFF
from puzzSessions
where ActionName='LOGOFF';
--logON: 8716
Select count(ActionName) as cntLOFF
from puzzSessions
where ActionName='LOGON';
--uniqueID=8717
Select count(distinct Session_ID) as allUniqueIDs
from puzzSessions;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.