DX Infrastructure Manager

Expand all | Collapse all

NMS 5.6.1 no more grp_server SQL question

  • 1.  NMS 5.6.1 no more grp_server SQL question

    Posted 08-15-2012 11:01 PM

    Hi,

     

    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.

     

    -Randy



  • 2.  Re: NMS 5.6.1 no more grp_server SQL question

    Posted 08-15-2012 11:50 PM

    Hello Randy,

     

    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:

     

    http://forum.nimsoft.com/t5/Unified-Monitoring-Development/qos-views-sql-script/m-p/16613

     

    These views can help tie the robot name to the statistics for you.



  • 3.  Re: NMS 5.6.1 no more grp_server SQL question

    Posted 08-16-2012 03:56 PM

    Hi,

     

    Thanks for the pointer to the new version.  Any idea where they stashed os_user1 and os_user2?

     

    -Randy