Yes, the usage jobs information is stored in the cloud_usage database on the usage_job table.
The start_date and end_date columns indicate which usage range was parsed and the start_millis and end_millis the jobs execution start and end time in milliseconds, which can be converted to date. Regards, Nicolas Vazquez ________________________________ From: Hean Seng <heans...@gmail.com> Sent: Thursday, October 29, 2020 4:58 PM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Re: listUsageRecords Update frequency Hi NIC Do know where can confirm the last run for usage server ? It seems my counter is not running , my setup is AdvanceZone Security Group. On Thu, Oct 29, 2020 at 4:34 AM Nicolas Vazquez < nicolas.vazq...@shapeblue.com> wrote: > Hi Hean, > > You are looking at the right configuration, if you set > 'usage.stats.job.aggregation.range' = 60 then you only need to restart the > usage server to propagate the changes. > > Also please check the 'usage.stats.job.exec.time' configuration, you can > set that exec time to a previous time in the day so after the usage server > restarts, the usage jobs start running, and then the interval remains > hourly (by the previous configuration) > > > Regards, > > Nicolas Vazquez > > ________________________________ > From: Hean Seng <heans...@gmail.com> > Sent: Wednesday, October 28, 2020 3:10 PM > To: users@cloudstack.apache.org <users@cloudstack.apache.org> > Subject: listUsageRecords Update frequency > > Hi > > I notice the usage record update once in a day . > > Is that possible to update the Usage data more frequently? May be hourly > etc. > > I try to update usage.stats.job.aggregation.range but seem that is not I > am looking for, it only affect startdate and enddate of the record, but > not update usage record interval. > > > -- > Regards, > Hean Seng > > nicolas.vazq...@shapeblue.com > www.shapeblue.com<http://www.shapeblue.com> > 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK > @shapeblue > > > > -- Regards, Hean Seng nicolas.vazq...@shapeblue.com www.shapeblue.com 3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK @shapeblue
