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?