Difference between revisions of "User:Pgmurphy/Script Notes"

From WolfTech
Jump to navigation Jump to search
 
Line 1: Line 1:
−
[[/New ECE Grad Student Account Notifier | New ECE Grad Student Account Notifier]]
+
*[[/New ECE Grad Student Account Notifier | New ECE Grad Student Account Notifier]]
−
 
 
−
==New ECE Grad Student Account Notifier==
 
−
How do we create accounts now?
 
−
# Query curriculum codes from curr_vue table in Sybase.  Search students OU in LDAP for people with those curriculum codes.
 
−
# Search employees OU in LDAP for users with ouc’s for supported colleges
 
−
# Query users registered for classes in supported colleges in stu_crs_wolftech table in Sybase.
 
−
 
 
−
Information I would like from Guard Dog?
 
−
# Array of faculty given a department.
 
−
# Array of staff given a department.
 
−
# Array of students given a curriculum code.
 
−
# Array of curriculum codes given a department.
 
−
# Array of RAs given a department.
 
−
 
 
−
Who do we want to notify to sync their password?
 
−
# ECE grad students
 
−
 
 
−
How to find ECE grad students?
 
−
# Title=Graduate Students
 
−
# Get curr’s from Sybase.curr_vue where ouc=140401.  Search students OU in LDAP for ncsuCurriculumCode=<code> and title=Doctoral Student or title=Graduate Student.
 
−
 
 
−
How to find ECE RAs?
 
−
# Search employees OU in LDAP for ouc=140488 and title=Graduate Research Asst
 
−
Or
 
−
# Search employees OU in LDAP for ou=Electrical and Computer Engineering Grads and Temps and title=Graduate Research Asst
 
−
Note:  ouc=140488 and ou=Electrical and Computer Engineering Grads and Temps currently produce the same results.
 
−
 
 
−
How to find ECE TAs?
 
−
# Search employees OU in LDAP for ouc=140488 and title=Graduate Teaching Asst
 
−
Or
 
−
# Search employees OU in LDAP for ou=Electrical and Computer Engineering Grads and Temps and title=Graduate Teaching Asst
 
−
Note:  ouc=140488 and ou=Electrical and Computer Engineering Grads and Temps currently produce the same results.
 

Latest revision as of 10:45, 17 November 2006

Retrieved from "https://tools.wolftech.ncsu.edu/support/index.php?title=User:Pgmurphy/Script_Notes&oldid=6274"