CA Service Management

  • 1.  ticket reassignment data information

    Posted Feb 25, 2014 11:24 AM

    Hi Team,

    Scenario:if a group works on a ticket and then transfer that ticket to another group for the fix,is it possible to get the ticket reassignment data logged in a DB area that we can report on.In our environment many of the tickets are handled by a group, and then passed on,Is there a way to report on everything they have been involved with, not necessarily closed?We are using CA service desk 12.7. Thanks in advance.

     

    Regards,

    Mohan



  • 2.  RE: [CA Service Desk General Discussion] ticket reassignment data informati

    Posted Feb 25, 2014 12:46 PM
    We do this in a somewhat brute force method, looking for the transfer activities and gathering the data from there.

    Sam Cohen, Global Systems Manager
    Marsh & McLennan Companies
    Global Technology Infrastructure (MGTI) | ESE Application Engineering
    121 River Street, Hoboken, NJ 07030, USA
    +1 201 284 5213 | Mobile +1 908 472 0027 | sam.cohen@mercer.com<mailto:sam.cohen@mercer.com>
    www.mmc.com<http://www.mmc.com/>

    From: CA Service Management Global User CommunityMessage Boards [mailto:CommunityAdmin@communities-mail.ca.com]
    Sent: Tuesday, February 25, 2014 11:24 AM
    To: mb_message.2276110.109939940@myca-email.ca.com
    Subject: [CA Service Desk General Discussion] ticket reassignment data information


    Hi Team,

    Scenario:if a group works on a ticket and then transfer that ticket to another group for the fix,is it possible to get the ticket reassignment data logged in a DB area that we can report on.In our environment many of the tickets are handled by a group, and then passed on,Is there a way to report on everything they have been involved with, not necessarily closed?We are using CA service desk 12.7. Thanks in advance.



    Regards,

    Mohan








    Posted by:mohansrinivas
    --
    CA Communities Message Boards
    109942480
    mb_message.2276110.109939940@myca-email.ca.com<mailto:mb_message.2276110.109939940@myca-email.ca.com>
    https://communities.ca.com

    ________________________________
    This e-mail and any attachments may be confidential, proprietary or legally privileged. Any review, use, disclosure, distribution or copying of this e-mail is prohibited except by or on behalf of the intended recipient. If you received this message in error or are not the intended recipient, please delete or destroy the e-mail message and any attachments or copies and notify the sender of the erroneous delivery by return e-mail. To the extent that this message or its attachments were sent without encryption, we can not guarantee that the contents have not been changed or tampered with. Any advice expressed in this message is being delivered to you solely for your use in connection with the matters addressed herein and may not be used for any other purpose without our prior written consent.

    The information contained in this document (including any attachments) is not intended by Mercer to be used, and it cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code that may be imposed on the taxpayer.


  • 3.  RE: ticket reassignment data information

    Posted Feb 26, 2014 12:11 AM

    Hi Mohan,

    When ticket is transfer to any group and member.Automatically Activity log is capture its those information stored in the Database.

    Can able you able to pull those information from the Activity log Table.

     

    Regards,

    Charan



  • 4.  RE: ticket reassignment data information

    Posted Feb 26, 2014 11:24 AM

    Thanks sam and charan for the response. Charan, As per my understanding  using activity log in a ticket  it is posible to fetch the transfer details for a single ticket alone. we need details of all the tickets that the group which has worked and after that transfered to other group.for Eg: Access team will work on certain tickets belong to that group and they transfer to other group ,also they touch some of other group tickets,we want to find what are all the tickets been handled and transfered by access management. it is possible to fetch the ticket handled by access group alone and for the ticket transfered, pls suggest the best practice. Thanks in advance.



  • 5.  RE: ticket reassignment data information

    Posted Feb 26, 2014 02:44 PM

    In you SQL Reporting get the list of contact IDs that are member of the specific group (see grpmem). Then link to the Activity Log (alg) table using those contacts and select only the transfer activities.