SAK-394

Owned by Thomas Amsler
Last updated: Mar 09, 2007 by Jon Gorrono (Unlicensed)Version comment
11 min read

JIRA: SAK-394

type key summary assignee reporter priority status resolution created updated due

Unable to locate Jira server for this macro. It may be due to Application Link configuration.

  • 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 3
    EME 106 001 FQ2006 SiteInfo 2
    EME 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 '%-%-%-%';

Other courses