normansolutions/OnlineUsersSection1.sql

Last active January 2, 2016 11:49

Star 0 You must be signed in to star a gist
Fork 0 You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/normansolutions/8299545.js"></script>
Save normansolutions/8299545 to your computer and use it in GitHub Desktop.

Download ZIP

For use on blog post: http://www.normansolutions.co.uk/post/creating-a-firefly-online-users-feature

Raw

OnlineUsersSection1.sql

SELECT TOP 500 UPPER(REPLACE(REPLACE(user_identity, '@STMARYS.EU', ''), 'ST-MARYS\\', '')) as Online, guid, date FROM hits h INNER JOIN tokens t ON (h.user_guid COLLATE DATABASE_DEFAULT = t.guid COLLATE DATABASE_DEFAULT) WHERE AND t.user_identity NOT like('%_1')AND t.user_identity NOT like('%_2') ORDER BY [date] DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment