U wilt graag weten, welke JOIN gebruikers op welk moment voor het laatst in JOIN ingelogd zijn geweest? Dit kunt u achterhalen, door volgend script op de database te (laten) uitvoeren.
Wie heeft er na 10 december 2019 geen gebruik meer gemaakt van JOIN? (ORACLE)
SELECT text7, firstname, prefix, surname FROM item WHERE it_parent_key = 'USERMENU' AND itemtype_key = 'USRINFO' AND item_deleted IS NULL AND TEXT7 IS NOT NULL AND BOL6='0' minus SELECT I.text7, I.firstname, I.prefix, I.surname FROM item I, user_var U WHERE I.IT_PARENT_KEY = 'USERMENU' AND I.ITEMTYPE_KEY = 'USRINFO' AND I.ITEM_DELETED IS NULL AND TRIM(U.USER_KEY)=TRIM(I.TEXT7) AND U.SESSION_VARIABLE LIKE 'APPACTIVE-%' AND U.SESSION_VALUE > '20191210';
Wie heeft er na 10 december 2019 geen gebruik meer gemaakt van JOIN? (MSSQL)
SELECT text7, firstname, prefix, surname FROM item WHERE it_parent_key = 'USERMENU' AND itemtype_key = 'USRINFO' AND item_deleted IS NULL AND TEXT7 IS NOT NULL AND BOL6='0' except SELECT I.text7, I.firstname, I.prefix, I.surname FROM item I, user_var U WHERE I.IT_PARENT_KEY = 'USERMENU' AND I.ITEMTYPE_KEY = 'USRINFO' AND I.ITEM_DELETED IS NULL AND TRIM(U.USER_KEY)=TRIM(I.TEXT7) AND U.SESSION_VARIABLE LIKE 'APPACTIVE-%' AND U.SESSION_VALUE > '20191210';
Wie is er sinds 1 januari 2019 actief geweest in JOIN?
SELECT I.text7, I.firstname, I.prefix, I.surname, U.SESSION_VALUE FROM item I, user_var U WHERE I.IT_PARENT_KEY = 'USERMENU' AND I.ITEMTYPE_KEY = 'USRINFO' AND I.ITEM_DELETED IS NULL AND TRIM(U.USER_KEY)=TRIM(I.TEXT7) AND U.SESSION_VARIABLE LIKE 'APPACTIVE-%' AND U.SESSION_VALUE > '20190101' order by U.SESSION_VALUE DESC;
Welk account is voor het laatst actief geweest in JOIN?
SELECT I.text7, u.session_value FROM item I innerjoin(select user_key,max(substring(session_value, 1, 8))as session_value from user_var where SESSION_VARIABLE LIKE'APPACTIVE-%' groupby user_key) u on u.user_key = i.text7 WHERE I.IT_PARENT_KEY ='USERMENU'AND I.ITEMTYPE_KEY ='USRINFO'AND I.ITEM_DELETED ISNULL and bol6 ='0'-- geblokkeerde gebruikers uitsluiten orderby text7;