Identify SPAIDEN records with STDT emails but no Active Directory Acct

 Problem Description : 

Email STDT records can get put on SPAIDEN but no Active Directory Account created. When student tries to logon to network, email or change password they get account errors.

 Resolution : 

In DOS prompt, run following command to create a text file of current STDT accounts:

dsquery user "ou=stdt,DC=gdn,DC=peachnet,DC=edu" -limit 0 -o samid > stdt.txt

In TOAD user the DATABASE->IMPORT->IMPORT TABLE DATA menu selection to import the textfile into the WSTLAST table

Run the following SQL to identify records in GOREMAL that are not in WSTLAST

select replace(lower(goremal_email_address),'@gdn.edu')

-- delete

from goremal

where

 goremal_emal_code = 'STDT'

-- and trim(GOREMAL.GOREMAL_ACTIVITY_DATE) != trim(sysdate)

 and not exists (

 select 'X'

 from wstlast 

 where

 lower(WSTLAST.USERNAME) = replace(lower(goremal_email_address),'@gdn.edu')

 )

If needed, run the "delete" to remove them so they can recreate.

 Revision Date : 7/12/2010