I installed Application Manager 11700. I am doing PING tests and so on.

I see that the system show only the last 6 hours of raw data, max 24 if I change the AMServer.Properties file.

This is not enough for the customer because he would like to have the raw data for two weeks.

If it's not possible to increase the retention on the AppManager itself, is it at least possible to create a script to export in TEXT format that data?

I found a query that can be run to export the data:

select * from am_managedobjectdata where RESID = 10000106 order by COLLECTIONTIME

But then I cannot find a way to use that in a command line script.

Can you help me?

Thanks,

Roberto.