Difference between revisions of "User:Pgmurphy/Script Notes/New ECE Grad Student Account Notifier"
Jump to navigation
Jump to search
(→Notes) |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 3: | Line 3: | ||
==Scripts== | ==Scripts== | ||
# Welcome to ECE/Account created | # Welcome to ECE/Account created | ||
− | ## Notify ECE graduate students that an account has been created for them and they need to change their password. | + | ## Notify ECE graduate students, staff, and faculty that an account has been created for them and they need to change their password. |
− | ## Pull data from GuardDog using group id 6161. | + | ## Pull data from GuardDog using group id 6161, 60759, and 61979. |
+ | ## Detect accounts created in AD in the last 24 hours. | ||
# Password Sync Nag | # Password Sync Nag | ||
− | |||
## Courses | ## Courses | ||
### Notifies members of course groups that they need to synchronize their password. | ### Notifies members of course groups that they need to synchronize their password. | ||
− | |||
− | |||
− | |||
==Planning== | ==Planning== | ||
− | # How many ECE accounts are currently sync'd? | + | # How many ECE accounts are currently sync'd (as of 11/17/2006)? |
## Grad Students? | ## Grad Students? | ||
##* (378/558) 68 % | ##* (378/558) 68 % | ||
## Ugrad Students? | ## Ugrad Students? | ||
##* (788/1031) 76 % | ##* (788/1031) 76 % | ||
+ | ## ECE Courses | ||
+ | ##* (1124/1519) 74 % | ||
## Faculty? | ## Faculty? | ||
##* (79/103) 77 % | ##* (79/103) 77 % | ||
Line 50: | Line 49: | ||
How to find ECE RAs? | How to find ECE RAs? | ||
− | + | * Search employees OU in LDAP for ouc=140488 and title=Graduate Research Asst | |
Or | 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. | Note: ouc=140488 and ou=Electrical and Computer Engineering Grads and Temps currently produce the same results. | ||
How to find ECE TAs? | How to find ECE TAs? | ||
− | + | * Search employees OU in LDAP for ouc=140488 and title=Graduate Teaching Asst | |
Or | 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. | Note: ouc=140488 and ou=Electrical and Computer Engineering Grads and Temps currently produce the same results. |
Latest revision as of 11:41, 21 November 2006
New ECE Grad Student Account Notifier
Scripts
- Welcome to ECE/Account created
- Notify ECE graduate students, staff, and faculty that an account has been created for them and they need to change their password.
- Pull data from GuardDog using group id 6161, 60759, and 61979.
- Detect accounts created in AD in the last 24 hours.
- Password Sync Nag
- Courses
- Notifies members of course groups that they need to synchronize their password.
- Courses
Planning
- How many ECE accounts are currently sync'd (as of 11/17/2006)?
- Grad Students?
- (378/558) 68 %
- Ugrad Students?
- (788/1031) 76 %
- ECE Courses
- (1124/1519) 74 %
- Faculty?
- (79/103) 77 %
- Staff (including RAs/TAs)?
- (284/321) 88 %
- RAs/TAs?
- (192/199) 96 %
- Grad Students?
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.