I'd like to get a list of bib records that have no holdings so that we can begin
a systematic cleanup.  Records that I know about seen to fall into several
categories (but there are problably others):  1) FR and WPL temp records entered
for ILL purposes, 2) full bib records that were created by "system
administrator" about the time of migration, 3) Rocky Flats records for websites
and 4) some newish WPL records for new donations that will have holdings
attached in the near future.  

When the list is created, could we include some fields that would identity them
by the above types--like date created, user name etc.?

Also, after we get going, we will need to figure out why the ILL problem is
occurring.

Fields I can extract that may help you are:
  bib#
  create_user (created by)
  create_date (date created)
  change_user (changed/edited by)
  change_date (date changed)
  title

There are a few other fields in the bib_control table, but I don't think they
will be of much use.

Records created by "system administrator" are likely artifacts from the
migration. (Records incorrectly/incompletely deleted from Dynix, CARL, etc.)

Assuming I have done the query correctly, there are currently ~4,800 such
records in the system. I can extract them and export them to an Excel
spreadsheet for you. Do the fields above sound useful and what order do you want
the report sorted in?

If ILL items are still causing problems, please enter as a separate ticket with
additional details. Thanks!