CA Service Management

Expand all | Collapse all

Service Desk 12.6--Joining Attachments and Call Req tables

Jump to Best Answer
  • 1.  Service Desk 12.6--Joining Attachments and Call Req tables

    Posted 04-17-2015 10:39 AM

    We are trying to write a report where we determine some criteria based off of the attachments table. At that point we want to be able to locate the ticket with which that attachment is associated. We found all of the attachments here: [mdb].[dbo].[attmnt] and assume there must be another table where it associates the attachment persid with the persid from [mdb].[dbo].[call_req].

     

    We found that at one time the two tables were associated with the [mdb].[dbo].[attmnt_lrel] and the connections between the two are perfect. However, all of the data in this table ends around the summer of 2012.  This happens to be the time we upgraded from 12.1 to 12.6. I assume that there must be a different table CA is utilizing now to join the two. Does anyone know what table this is? Thanks.



  • 2.  Re: Service Desk 12.6--Joining Attachments and Call Req tables
    Best Answer

    Posted 04-17-2015 02:20 PM

    Please check

    usp_lrel_attachments_requests

    usp_lrel_attachments_changes

    usp_lrel_attachments_issues



  • 3.  Re: Service Desk 12.6--Joining Attachments and Call Req tables

    Posted 04-20-2015 03:03 PM

    This was it. Thanks.