I used to have an easy way to generate tables on a custom dashboard for groups of servers. I could just use...
select robotname,robotip,os_major,os_minor,cpu_usage,memory_usage,memory_paging from grp_server where os_user1='bloomington' order by cpu_usage desc
...Any suggestions for porting this to a non grp_server environment? I do have the qos_views.sql views available.
The same basic structure is in the NIS Server discovery table: CM_COMPUTER_SYSTEM for name, ip, os_name, os_type, but you will have to join it to another table to include CPU, and memory stats.
Cash Shurley just posted version 3.1 on the forumsfor building the views:
These views can help tie the robot name to the statistics for you.
Thanks for the pointer to the new version. Any idea where they stashed os_user1 and os_user2?