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.
This was it. Thanks.