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

From WolfTech
Jump to navigation Jump to search
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
==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