Sets the Must Change Password flag (UGN.CPW) to True for all active accounts of a specified user type, requiring a password change at the next login.

NOTE: Back up the UGN table before making any changes. For hosted districts, submit a Support Ticket to request the backup.

1. Identify Records to Update

• Replace admin with the target user type as needed — other valid types include user and teacher; returns active accounts where Must Change Password is currently False

LIST UGN UGN.UID UGN.UN UGN.UTY UGN.CD UGN.LDT UGN.ST UGN.CPW IF UGN.UTY = 'admin' AND UGN.ST = '0' AND UGN.CPW = '0'

2. Set UGN.CPW to 1

• Replace admin with the target user type as needed — other valid types include user and teacher; updates the same records identified in step 1

CHANGE UGN UGN.CPW TO '1' IF UGN.UTY = 'admin' AND UGN.ST = '0' AND UGN.CPW = '0'

• ST = '0': targets active records only
• CPW TO '1': sets Must Change Password to True, requiring a password change at next login
• UTY = 'admin': filters to the specified user type