I've been trying to get some reporting working on package history and experience some 'challenges' to obtain the right set of data.
What I need is the (average) time it takes (or took) for a package to get from state X to state Y in a given environment.
I can get a per environment list of all Created, Promote and Demote actions from table harPkgHistory (plus the date/time of execution). But when a package has been promoted/demoted into a state more than once, the query returns too many rows.
Any help would be very welcome ...