Hi Mhairi, there is a system supplied report that will do this: if you click reports: run and expand System supplied and then Statistics, you should see a report called most prolific recorders V06-12.

This should list all the names within your system and the number of records attributed to them. However, as the recorder name table is used for system login you may find that some entries are needed for system metadata.

Eric

Hi Mhairi, give the attached xml a go - it produces a report with all entries in the Name table and includes counts of their Name_Keys in the Survey_Event_Recorder, Taxon_Determination and User tables.  It should help find individuals that have no records or determinations in your database. Unlike the prolific recorders report it doesn't count the individuals records, it just counts the number of times they are listed in the Survey_Event _Recorder table.
Hope it helps!
Ian