CA Service Management

Expand all | Collapse all

CABI Report On Special Handling Group Members?

Jump to Best Answer
  • 1.  CABI Report On Special Handling Group Members?

    Posted 11-20-2016 08:43 PM

    Does anyone know how to create a CABI report that will return the inactive members of a specified Special Handling group.

     

    Basically the equivalent of this stored query against the contact table. 

     

    delete_flag=1 AND cnthandling_list.special_handling IN (400001)

     

    I couldn't find a way using the CA Service Desk universe for SDM 12.9

     

    CABI Build Number:  1983 
    CABI Product Version:  12.7.0.1983 

     

    Thanks Stuart



  • 2.  Re: CABI Report On Special Handling Group Members?
    Best Answer

    Posted 12-18-2016 04:50 PM

    I had another look at this today and solved the issue, different names between the universe objects, schema designer and DBMS can be confusing.

     

     

    SELECT
      contact_handling.contact_combo_name,
      cnt_handling.delete_flag_symbol
    FROM
      contact_handling INNER JOIN cnt  cnt_handling ON (cnt_handling.id=contact_handling.contact)
     
    WHERE
      (
       cnt_handling.delete_flag  =  1
       AND
       contact_handling.special_handling  =  400001
      )