CA Service Management

  • 1.  Report On Attached Service Type Events?

    Posted May 24, 2017 11:00 PM

    Hello,

     

    We are using SDM 12.9, I want a report on any requests that have a duplicate attached service type event pending. Does anyone know how to do this using the 'CA Service Desk' universe for CABI?

     

    I can't seem to find the object that references the attached service type event name.

     

    Our CABI version is 12.7.0.1983 (build 1983).

     

    Thanks Stuart



  • 2.  Re: Report On Attached Service Type Events?
    Best Answer

    Posted May 30, 2017 09:54 PM

    I'm not going to use CABI to achieve this, instead I'll run this SQL query.

     

    SELECT [mdb].[dbo].[call_req].[ref_num]
    FROM [mdb].[dbo].[call_req]
    INNER JOIN [mdb].[dbo].[att_evt]
    ON [mdb].[dbo].[call_req].[persid]=[mdb].[dbo].[att_evt].[obj_id]
    WHERE [mdb].[dbo].[att_evt].[event_tmpl]='evt:400120' AND [mdb].[dbo].[call_req].[active_flag]=1
    GROUP BY [mdb].[dbo].[call_req].[ref_num] HAVING COUNT (*) > 1
    ORDER BY [mdb].[dbo].[call_req].[ref_num] ASC;