Here you will see a list of "Program Events" (Asterisk, Low Battery, Windows Log-on, etc.). Browse and Replace: Select an event (like "Notification").
If you are looking to download these audio files for your own system, several community archives host them in WinCustomize : This site offers various Windows Longhorn Sound Schemes windows longhorn sounds download wav