mysql> select name, ainame, scriptname from creature_template where ainame <>"" and scriptname <> "";
+-------------------------------+---------+-------------------------------+
| name                          | ainame  | scriptname                    |
+-------------------------------+---------+-------------------------------+
| Innkeeper Farley              | EventAI | npc_innkeeper                 |
| Morbent Fel                   | EventAI | spell_dummy_npc               |
| Arugal's Voidwalker           | EventAI | mob_arugal_voidwalker         |
| Earthen Guardian              | EventAI | mob_archaeras_add             |
| Earthen Hallshaper            | EventAI | mob_archaeras_add             |
| Earthen Custodian             | EventAI | mob_archaeras_add             |
| Mekgineer Thermaplugg         | EventAI | boss_thermaplugg              |
| Vault Warder                  | EventAI | mob_archaeras_add             |
| Lady Illucia Barov            | EventAI | boss_illucia_barov            |
| Lord Alexei Barov             | EventAI | boss_lord_alexei_barov        |
| Instructor Malicia            | EventAI | boss_instructor_malicia       |
| The Ravenian                  | EventAI | boss_the_ravenian             |
| Ras Frostwhisper              | EventAI | boss_boss_ras_frostwhisper    |
| Lorekeeper Polkelt            | EventAI | boss_lorekeeper_polkelt       |
| Doctor Theolen Krastinov      | EventAI | boss_doctor_theolen_krastinov |
| Drek'Thar                     | EventAI | npc_drekthar                  |
| Vanndar Stormpike             | EventAI | npc_vanndar_stormpike         |
| Dun Baldar North Marshal      | EventAI | npc_marshall                  |
| Dun Baldar South Marshal      | EventAI | npc_marshall                  |
| Icewing Marshal               | EventAI | npc_marshall                  |
| Stonehearth Marshal           | EventAI | npc_marshall                  |
| East Frostwolf Warmaster      | EventAI | npc_marshall                  |
| Iceblood Warmaster            | EventAI | npc_marshall                  |
| Tower Point Warmaster         | EventAI | npc_marshall                  |
| West Frostwolf Warmaster      | EventAI | npc_marshall                  |
| Stalagg                       | EventAI | mob_stalagg                   |
| Feugen                        | EventAI | mob_feugen                    |
| Naxxramas Worshipper          | EventAI | mob_worshipper                |
| Void Zone                     | EventAI | npc_void_zone                 |
| Death Knight Understudy       | EventAI | npc_death_knight_understudy   |
| Hulking Helboar               | EventAI | spell_dummy_npc               |
| Kil'rek                       | EventAI | mob_kilrek                    |
| Fiendish Imp                  | EventAI | mob_karazhan_imp              |
| Blacksilt Scout               | EventAI | spell_dummy_npc               |
| Azgalor                       | EventAI | boss_azgalor                  |
| The Black Stalker             | EventAI | boss_blackstalker             |
| High Botanist Freywinn        | EventAI | boss_high_botanist_freywinn   |
| Phase Hunter                  | EventAI | spell_dummy_npc               |
| Ember of Al'ar                | EventAI | mob_ember_of_alar             |
| Commander Dawnforge           | EventAI | npc_commander_dawnforge       |
| The Lurker Below              | EventAI | boss_the_lurker_below         |
| Underbog Colossus             | EventAI | mob_underbog_colossus         |
| Shadow Fissure                | EventAI | mob_shadow_issure             |
| Inner Demon                   | EventAI | mob_inner_demon               |
| Shadowy Construct             | EventAI | mob_shadowy_construct         |
| Akil'zon                      | EventAI | boss_akilzon                  |
| Amani'shi Savage              | EventAI | mob_amanishi_savage           |
| Zephyr                        | EventAI | npc_zephyr                    |
| Greengill Slave               | EventAI | spell_dummy_npc               |
| Felblood Initiate             | EventAI | spell_dummy_npc               |
| Shield Orb                    | EventAI | mob_shield_orb                |
| Hand of the Deceiver          | EventAI | mob_hand_of_the_deceiver      |
| Volatile Felfire Fiend        | EventAI | mob_volatile_felfire_fiend    |
| M'uru                         | EventAI | boss_muru                     |
| Dark Fiend                    | EventAI | dark_fiend                    |
| Void Sentinel                 | EventAI | void_sentinel                 |
| Entropius                     | EventAI | boss_entropius                |
| Rabid Grizzly                 | EventAI | spell_dummy_npc               |
| Greer Orehammer               | EventAI | npc_greer_orehammer           |
| Annhylde the Caller           | EventAI | npc_annhylde                  |
| Dragonflayer Forge Master     | EventAI | mob_dragonflayer_forge_master |
| Scavenge-bot 004-A8           | EventAI | spell_dummy_npc               |
| Sentry-bot 57-K               | EventAI | spell_dummy_npc               |
| Defendo-tank 66D              | EventAI | spell_dummy_npc               |
| Scavenge-bot 005-B6           | EventAI | spell_dummy_npc               |
| 55-D Collect-a-tron           | EventAI | spell_dummy_npc               |
| Rune Reaver                   | EventAI | spell_dummy_npc               |
| Woodlands Walker              | EventAI | spell_dummy_npc               |
| Arthas                        | EventAI | npc_arthas                    |
| Meathook                      | EventAI | boss_meathook                 |
| Salramm the Fleshcrafter      | EventAI | boss_salramm                  |
| Chrono-Lord Epoch             | EventAI | boss_lord_epoch               |
| Mal'Ganis                     | EventAI | boss_malganis                 |
| Blighted Elk                  | EventAI | spell_dummy_npc               |
| Trollgore                     | EventAI | boss_trollgore                |
| Novos the Summoner            | EventAI | boss_novos                    |
| The Prophet Tharon'ja         | EventAI | boss_tharonja                 |
| Frenzied Worgen               | EventAI | npc_worgen                    |
| Ravenous Furbolg              | EventAI | npc_furlborg                  |
| Massive Jormungar             | EventAI | npc_jormungar                 |
| Ferocious Rhino               | EventAI | npc_rhino                     |
| Reanimated Frost Wyrm         | EventAI | spell_dummy_npc               |
| Overseer Deathgaze            | EventAI | spell_dummy_npc               |
| Acolyte                       | EventAI | npc_cs_acolyte                |
| Crypt Fiend                   | EventAI | npc_cs_field                  |
| Patchwork Construct           | EventAI | npc_cs_butcher                |
| Lordaeron Footman             | EventAI | npc_arthas_marine             |
| High Elf Mage-Priest          | EventAI | npc_arthas_priest             |
| Turgid the Vile               | EventAI | spell_dummy_npc               |
| Prophet of Sseratus           | EventAI | spell_dummy_npc               |
| Prince Tenris Mirkblood       | EventAI | boss_tenris                   |
| Dark Necromancer              | EventAI | npc_cs_necromancer            |
| Sanguine Spirit               | EventAI | sanguine                      |
| Devouring Ghoul               | EventAI | npc_cs_gnoul                  |
| Shaman Vekjik                 | EventAI | npc_vekjik                    |
| Artruis the Heartless         | EventAI | npc_artruis                   |
| Krik'thir the Gatewatcher     | EventAI | boss_krikthir                 |
| Watcher Narjil                | EventAI | boss_narjil                   |
| Watcher Gashra                | EventAI | boss_gashra                   |
| Watcher Silthik               | EventAI | boss_silthik                  |
| Hadronox                      | EventAI | boss_hadronox                 |
| Anub'arak                     | EventAI | boss_anubarak                 |
| Stormforged Lieutenant        | EventAI | mob_stormforged_lieutenant    |
| Silver Covenant Guardian Mage | EventAI | npc_dalaran_guardian_mage     |
| Sunreaver Guardian Mage       | EventAI | npc_dalaran_guardian_mage     |
| Xevozz                        | EventAI | boss_xevozz                   |
| Ethereal Sphere               | EventAI | mob_ethereal_sphere           |
| Moorabi                       | EventAI | boss_moorabi                  |
| Gal'darah                     | EventAI | boss_galdarah                 |
| Drakkari Colossus             | EventAI | boss_colossus                 |
| Lavanthor                     | EventAI | boss_lavanthor                |
| Ichor Globule                 | EventAI | mob_ichor_globule             |
| Erekem Guard                  | EventAI | mob_erekem_guard              |
| Living Mojo                   | EventAI | mob_living_mojo               |
| Ruins Dweller                 | EventAI | npc_ruins_dweller             |
| Arcane Overload               | NullAI  | npc_arcane_overload           |
| Exhausted Vrykul              | EventAI | spell_dummy_npc               |
| Portal Guardian               | EventAI | mob_vh_dragons                |
| Azure Invader                 | EventAI | mob_vh_dragons                |
| Azure Spellbreaker            | EventAI | mob_vh_dragons                |
| Azure Binder                  | EventAI | mob_vh_dragons                |
| Azure Mage Slayer             | EventAI | mob_vh_dragons                |
| Azure Captain                 | EventAI | mob_vh_dragons                |
| Azure Sorceror                | EventAI | mob_vh_dragons                |
| Azure Raider                  | EventAI | mob_vh_dragons                |
| Portal Keeper                 | EventAI | mob_vh_dragons                |
| Azure Saboteur                | EventAI | npc_azure_saboteur            |
| Argent Healer                 | EventAI | npc_argent_healer             |
| Azure Stalker                 | EventAI | mob_vh_dragons                |
| Infinite Corruptor            | EventAI | boss_infinite_corruptor       |
| Stormcaller Brundir           | EventAI | boss_brundir                  |
| Steelbreaker                  | EventAI | boss_steelbreaker             |
| Runemaster Molgeim            | EventAI | boss_molgeim                  |
| Scorch                        | EventAI | mob_scorch_target             |
| Behsten                       | EventAI | npc_experience_eliminator     |
+-------------------------------+---------+-------------------------------+
135 rows in set