How to generate a report based on utilisation of AWS services covering cost & capacity management in Splunk?

[gammah786]

Hi

I would like some query's or a query combined into one which gives me information about the following point's

•Formula for % usage over time for Memory and CPU
•Formula for MB/GB/TB used over time for Memory and Storage
•Formula for total MB/GB/TB available for Memory and Storage
•Storage breakdown includes Host and Volume i.e. hostname\file-system name

I started off by running below search to start off;
"index=os* sourcetype=df | stats median(PercentFreeSpace) by host filesystem" This gives me abit of information, but focusing on extracting the above information either in single query or different ones?

Please Advise.
Regards