Query against the Assignment Business Object to get the Assignment audit history

Version 7

    Verified Product Versions

    LANDESK Service Desk 7.6LANDESK Service Desk 7.7.xLANDESK Service Desk 7.8.xLANDESK Service Desk 2016.xLANDESK Asset Central 2016.x

    Issue:

    When a process related record, say, an Incident, comes to the end status, the Current Assignment information (group and user) will be gone, but sometimes we do need the Assignment details, say, an audit history to check what the assignment path it had gone through whatever the record’s status is.

     

    Solution:

    We can achieve this by creating a query against Assignment business object under the relevant module.

    For example, I want to view the Incident’s reference number, Assignment serial number, the title of the assigned-to group and user, the creation date time of the Assignment, the Assignment’s subject, then what I have to do is to select to display the following attributes in the query:

    Incident.Reference Number,

    User.Title,

    Group.Title,

    Title,

    CreationDate,

    Process Assignment Serial Number (this attribute is column pm_serial_number in table pm_process_assignment in your database).

     

    Reference screenshots:

    Query design

    Query result

    You can view the Assignment history for a specific Incident, and sort it based on conditions such as Creation Date, Process Assignment Serial Number, etc.