DX Unified Infrastructure Management

  • 1.  Sql Query for deactivated probes with corresponding robot name

    Posted Jan 09, 2017 04:59 AM

    Hi Team,

     

    Is there any sql query to know deactivated probe with corresponding robot name in CA UIM?



  • 2.  Re: Sql Query for deactivated probes with corresponding robot name
    Best Answer

    Posted Jan 09, 2017 07:30 AM

    Got it!!

     

    select CM_NIMBUS_PROBE.probe_name,CM_NIMBUS_ROBOT.robot,CM_NIMBUS_PROBE.probe_group,CM_NIMBUS_PROBE.pkg_version,CM_NIMBUS_PROBE.port
    from CM_NIMBUS_PROBE Inner join CM_NIMBUS_ROBOT on CM_NIMBUS_PROBE.robot_id= CM_NIMBUS_ROBOT.robot_id where CM_NIMBUS_PROBE.active=1 and CM_NIMBUS_ROBOT.robot_active=1;