It's difficult to build queries without seeing some sample data. Can you please provide some?
Also, it's not clear what you want the results to be. For instance, you say "memory, disk, and network activity." Do you mean in real time? The last time you polled? An average over the last minute, or hour, or day?
Please read the search documentation and see if you can construct the search yourself first. Please post the searches you tried, what the searches returned, and what results you were looking for.
http://docs.splunk.com/Documentation/Splunk/6.2.2/SearchTutorial/WelcometotheSearchTutorial
http://docs.splunk.com/Documentation/Splunk/6.2.2/Search/Whatsinthismanual
... View more