Looking for sample scripts

[David Miller]

Lee Ivy wrote:
> Hello,
> I am a new member of this list. Sorry if this is a dumb question but I 
> did not see it in the FAQ.
> 
> I am taking over an existing Bugzilla DB and I am looking for a fast way 
> to perform cleanup operations such as:
> 
>   1. Get a list of all the defects in Resolved/Fixed state
>   2. For each of these defects, if it has seen no updates in the last X
>      months, change its state to Closed
> 
> When I worked with ddts I built up a set of similar scripts & it was 
> very handy, once I had a few working it was not hard to customize them 
> for whatever I needed.
> 
> If anyone can point me to any share-able scripts that do anything 
> similar, and point out any caveats or land-mines to be aware of, I would 
> appreciate it.

There are some similar goodies on http://www.bugzilla.org/docs/queries.html

I don't think it has everything you're looking for, but it's a start.

You can do the above from the web UI though.

Go to the advanced search page, select the resolutions you want to 
match, put "1/1/1970" to "4m" in the date range section of the Bug 
Changes section, and run the search.

Once you have the results, click the "change several bugs at once" link 
at the bottom, then click "Check All", pick the option to close the 
bugs, and submit.

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/