1 Topic by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 67

Topic: Recorder list with count of records?

Is there a report available that would give me all the recorders in the database and the number/count of records that they have? I am trying to tidy up our database and want to remove those recorders who have no records.
Any help appreciated
Mhairi

2 Reply by Fletchere

  • Fletchere
  • Member
  • Offline
  • Registered: 29-10-2007
  • Posts: 11

Re: Recorder list with count of records?

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

Eric Fletcher
RECORD Manager
http:/www.record-lrc.co.uk

3 Reply by FNRCinfoassist

  • FNRCinfoassist
  • Veteran
  • Offline
  • From: Fife
  • Registered: 15-06-2011
  • Posts: 67

Re: Recorder list with count of records?

Thank you Eric, I was aware of this report.
My problem is that some of the recorders listed in our database have no records and not listed in this report. Previously we captured all iRecord recorders by their name but we changed that so now we have all these recorders with no records (we delete the iRecord survey and reimport a fresh copy every 6 months). I was hoping to tidy up our recorders by deleting the ones with no records.
Thank you for your response.
Mhairi