AMDB database question

AMDB database question

Is it possible to expand the date range of collected response time data? It seems like amdb.am_managedobjectdata in mySQL is getting cleaned out daily.

I've been using some of the data collected for a more detailed report. We're trying to track down an internal network timeout issue dealing with Apaches, a load balancer and tomcats and need more date range sensitive data to help.

I just drop the results into Excel and manually graph to show the problem to upper management. It would be nice if I had the entire date range to use instead of a moving date range.

Here's the SQL:

select mod.resid
, mo.displayname
, from_unixtime(ceil(mod.collectiontime/1000)) occurred
, mod.responsetime
from amdb.am_managedobjectdata mod
, amdb.am_managedobject mo
where mod.resid = mo.resourceid
and mod.responsetime > 10000
order by mod.collectiontime desc

Any ideas?