How can we retrieve Service Desk Manager attachments through ITPAM using persid?

Products

• CA Process Automation Base
• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

We have the persid of a ticket, how can ITPAM obtain attachment IDs from the SDM Database so we can use ITPAM to move these attachments to another location?

Environment

Release : 4.4

Resolution

You can create a Notification Rule and attach it to an activity notification .

There is an important table called attmnt_act_map in the MDB

This table contains the activity log (alg) values and the attmnt_id

Option 1

Build a SQL statement in PAM after receiving the activity log persid

With the persid, you can write a join statement to get the physical name and location of the attachment.

Option 2

Using Web Screen Painter, you can create a BREL field on the alg object pointing to this object

After publishing this new field you can use PAM to get the information needed.

Additionally, you can use the activity log to show the attachment name  and other attributes of the attachment