I have a report of full tapes that need to be ejected. I need to create another report that lists the scratch tapes to be loaded in their place. When I try doing a count(id) the GUI give a nebulus error response.
Its not clear to me what exactly you are expecting in your report ? Also could you pleaes share the whoc are you building the ew report ? If its custom then what filters and columns are you selecting and if its custom SQL , what SQL you are using ?
Do you want the list of media ids from scratch pool that should replace the mediaid that are ejected (FULL) ??