Outside of creating two separate reports, and with my forgotten SQL knowledge I basically need to create a report that will list the node name on a line and the columns will be: AVG CPU, Peak CPU, AVG Memory, Peak Memory, Interface Xmit Bytes, Interface Recv Bytes.
I've tried to combine various SQL statements from the different types of reports to no avail. Any help would be greatly appreciated.
If you have copies of the multiple SQL Statements from the Reports that you want combined and post them in this Thread, I can work my SQL Magic to see if I can Combine the Reports for you.
In Report Writer open the Reports and Select Report > Show SQL and a SQL Tab will be added to the Report. Copy and Paste the SQL Statement so I know exactly what you need.