Our PACS group gets a lot of patient studies on CDs to be imported into the PACS archive. The other day I was asked if it was possible to split out the study and image counts for these imported studies to get an idea of the imported study volume relative to the total.
Fortunately it turned out to be a relatively easy query since all imported studies use the same prefix for the accession number. After experimenting with a few SQL queries, I managed to come up with data to make this graph showing the fraction of imported studies and images relative to the total volume.
It's been climbing pretty steadily (something that definitely has not gone unnoticed by the person who does the importing), but is still a pretty small fraction of the total volume.
This will be good stuff to put into my paper.