Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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
  • 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 '%-%-%-%';
      
  • No labels