We are using a home-grown database for bug tracking. I need to extract the following info from it: # bugs, # OPEN, # CLOSED, # DEFERRED, # in QA to be verified, etc. Does anyone know of a small SQL written program that can do this? This is an Oracle db.
More than likely, you're not going to find any sort of SQL script that has been pre-made for you to use. That is, seeing as how you've got a home-grown bug-tracking database.
That having been said, why not roll your own script to pull your data? Depending on how much SQL background you have, it'd probably take all of two minutes to do.
At a high level, here are two queries that'll make things relatively easy for you (just plug 'n play your values):
select count(*) from [your main table]; (this just gets you your initial count)
select "status", count(*) from [your main table] group by "status"; (this will return a breakdown of each status and the corresponding count)
Now, it becomes a little more difficult if you track all of your history in the same table. Hopefully, your 'main table' houses only the current status of the defect. Else, you'll have a little more work to do. It all really boils down to what the structure of your database looks like.