EnterpriseOne (E1) Package Build Count

Recently we were asked the following question:

"How many packages of each type per environment did you build last year?"

Here is the SQL that I used to gather the information required:

select hhpkgname, hhpathcd, year(date(char(hhblddte+1900000))) as hhblddte
from sy811/f96215
where hhpkgname not like 'JJ%' --remove the ESUs
and hhdatp='CLIENT' --type of build
and hhbldsts=50 --build completed successfully

I then used this information to create an ASP.Net page to organize the data more elegantly. Below are package statistics for the 2 EnterpriseOne (E1) installations that I support: