Difference between revisions of "User:Pgmurphy/Script Notes/New ECE Grad Student Account Notifier"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | + | =New ECE Grad Student Account Notifier= | |
+ | |||
+ | ==Scripts== | ||
+ | # Welcome to ECE/Account created | ||
+ | ## Notify ECE graduate students that an account has been created for them and they need to change their password. | ||
+ | ## Pull data from GuardDog using group id 6161. | ||
+ | # Password Sync Nag | ||
+ | ## Can probably combined into one system once we automate employee groups in AD. | ||
+ | ## Courses | ||
+ | ### Notifies members of course groups that they need to synchronize their password. | ||
+ | ## Employees | ||
+ | ### Notifies employees that they need to synchronize their password. | ||
+ | ### Get info from GuardDog until AD groups are pulled from LDAP. | ||
+ | |||
+ | ==Planning== | ||
+ | # How many ECE accounts are currently not sync'd? | ||
+ | ## Grad Students? | ||
+ | ## Faculty? | ||
+ | ## Staff? | ||
+ | ## RAs? | ||
+ | ## TAs? | ||
+ | |||
+ | ==Notes== | ||
How do we create accounts now? | 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. | # Query curriculum codes from curr_vue table in Sybase. Search students OU in LDAP for people with those curriculum codes. | ||
Line 11: | Line 33: | ||
# Array of curriculum codes given a department. | # Array of curriculum codes given a department. | ||
# Array of RAs given a department. | # Array of RAs given a department. | ||
+ | # Array of ECE graduate students. | ||
+ | <code> | ||
+ | $List = new hierHelp(6161); | ||
+ | $GradStudentList = $List->getGroupUsers(); | ||
+ | </code> | ||
Who do we want to notify to sync their password? | Who do we want to notify to sync their password? |
Revision as of 14:29, 17 November 2006
New ECE Grad Student Account Notifier
Scripts
- Welcome to ECE/Account created
- Notify ECE graduate students that an account has been created for them and they need to change their password.
- Pull data from GuardDog using group id 6161.
- Password Sync Nag
- Can probably combined into one system once we automate employee groups in AD.
- Courses
- Notifies members of course groups that they need to synchronize their password.
- Employees
- Notifies employees that they need to synchronize their password.
- Get info from GuardDog until AD groups are pulled from LDAP.
Planning
- How many ECE accounts are currently not sync'd?
- Grad Students?
- Faculty?
- Staff?
- RAs?
- TAs?
Notes
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.
- Array of ECE graduate students.
$List = new hierHelp(6161);
$GradStudentList = $List->getGroupUsers();
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.