I would suggest checking out StackTach over at Racker Labs -> https://github.com/rackerlabs/stacktach. It will store and report this data for you from your rabbit/qpid queues. On Fri, May 10, 2013 at 3:26 PM, Daniel Murphy <murphstein at yahoo.com> wrote: > Say it's midnight, and I want to know how many instances a tenant had > running in the past hour or day… > > I know the MySQL DB contains "historical" started, changed and stopped > times for each instance/server. > > Is there an API call to access that data (I can't find one), or do I need > to go to the DB directly for the info? > > As a side note, can anyone explain if/how/when Nova cleans up the instance > table periodically in Folsom? > > Thanks, > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack at lists.launchpad.net > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp > > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130510/f34344f1/attachment.html>