How to get list of packages for 1 year?

Hello everybody... I want to get a list of all the packages deployed/built in a certain environment (say,DV7333/PD7333) in JDE for the last one year(say,in whole 2011).. Can anyone help me out of this as to how to do it..

Thanks in advance

List of packages "deployed" for DV7333 in 2011

SELECT UPJDEPKGNM , UPPATHCD , UPMKEY , UPDEPLDATE , UPDEPLTIME, UPINPKST FROM SYS7333.F98826 WHERE UPPATHCD = 'DV7333' AND UPDEPLDATE BETWEEN 111001 AND 111365 ORDER BY UPDEPLDATE , UPJDEPKGNM;

Change the pathcode value as per your needs. Note if a package was deployed more than once to a server , or more than one server , it will appear more than once in the result set.

Similarly you can query F96215 to get information on packages built