User:Pgmurphy/Script Notes/New ECE Grad Student Account Notifier

New ECE Grad Student Account Notifier

How do we create accounts now?

1. Query curriculum codes from curr_vue table in Sybase. Search students OU in LDAP for people with those curriculum codes.
2. Search employees OU in LDAP for users with ouc’s for supported colleges
3. Query users registered for classes in supported colleges in stu_crs_wolftech table in Sybase.

Information I would like from Guard Dog?

1. Array of faculty given a department.
2. Array of staff given a department.
3. Array of students given a curriculum code.
4. Array of curriculum codes given a department.
5. Array of RAs given a department.

Who do we want to notify to sync their password?

1. ECE grad students

How to find ECE grad students?

1. Title=Graduate Students
2. 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?

1. Search employees OU in LDAP for ouc=140488 and title=Graduate Research Asst

Or

1. 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?

1. Search employees OU in LDAP for ouc=140488 and title=Graduate Teaching Asst

Or

1. 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.