SAK-394
- Thomas Amsler
- Jon Gorrono (Unlicensed)
Owned by Thomas Amsler
JIRA: SAK-394
- Environment: http://smartsite-test.ucdavis.edu
- Code Base sakai_2-3-x-test-006
- Course: EME 106 001 FQ 2006
- Site Id: 20061022389
- Provider Id: 2006-10-22389
- Data from sakai external database
- REALM_KEY : 6073
- query : select R.*, M.EID from SAKAI_REALM_RL_GR R, SAKAI_USER_ID_MAP M where R.USER_ID=M.USER_ID and REALM_KEY = '6073';
REALM_KEY USER_ID ROLE_KEY ACTIVE PROVIDED EID ------------ ------------------------------------ ----------- --------- ----------- -------- 6073 aozzoa 8 1 0 aozzoa 6073 lucky77 8 1 0 lucky77 6073 petergw 8 1 0 petergw 6073 japaveli 8 1 0 japaveli 6073 schetrit 8 1 0 schetrit 6073 warspark 8 1 0 warspark 6073 wayway 8 1 0 wayway 6073 cjcaball 8 1 0 cjcaball 6073 domc43 8 1 0 domc43 6073 rdgilmou 8 1 0 rdgilmou 6073 remyop 8 1 0 remyop 6073 yuricky1 8 1 0 yuricky1 6073 bcherdt 8 1 0 bcherdt 6073 nparsels 8 1 0 nparsels 6073 kevinjm 8 1 0 kevinjm 6073 garety 8 1 0 garety 6073 gpilot 8 1 0 gpilot 6073 knguyen1 8 1 0 knguyen1 6073 brettsuo 8 1 0 brettsuo 6073 djgarcia 8 1 0 djgarcia 6073 dsbaker 8 1 0 dsbaker 6073 johker 8 1 0 johker 6073 hkpang 8 1 0 hkpang 6073 dbatten 8 1 0 dbatten 6073 jaduffey 8 1 0 jaduffey 6073 kaze211 8 1 0 kaze211 6073 michie1 8 1 0 michie1 6073 mmmwong 8 1 0 mmmwong 6073 scottmr2 8 1 0 scottmr2 6073 apserra 8 1 0 apserra 6073 vsauluck 8 1 0 vsauluck 6073 7f6b535c-f6e0-4b5d-806a-d8ff92152cdb 8 1 0 shosey3 6073 a291e72c-99b8-4a13-0091-aaaf107d26b4 5 1 0 farouki 6073 fb6f5268-a7dc-426a-00ac-4d87cebe1eef 8 1 0 d23rx8 34 record(s) selected [Fetch MetaData: 13/ms] [Fetch Data: 95/ms] [Executed: 2/4/07 10:39:32 AM PST ] [Execution: 104/ms]
- Screen captures from SiteInfo Tool
EME 106 001 FQ2006 SiteInfo 3EME 106 001 FQ2006 SiteInfo 2EME 106 001 FQ2006 SiteInfo 1 - Users with newly assigned Sakai internal IDs
select R.*, M.EID from SAKAI_REALM_RL_GR R , SAKAI_USER_ID_MAP M where R.USER_ID=M.USER_ID and M.USER_ID like '%-%-%-%';