Clarity Service Management

Expand all | Collapse all

Extract specific columns from Change Request

Jump to Best Answer
  • 1.  Extract specific columns from Change Request

    Posted 10-29-2018 10:31 AM

    Hi Team

     

     

    following command extract complete record from Change_Request table.

     

    pdm_extract Change_Request >c:\chg.txt

     

     

    I need  few columns data from change_request table. What argument will be add to this command to extract specfic columns data like , Requester, affected_contact, category, group etc ????



  • 2.  Re: Extract specific columns from Change Request
    Best Answer

    Posted 10-29-2018 02:58 PM

    Aamir,

     

    pdm_extract -f "select col1, col2, ... colm-n  from Change_Request"  > chg.txt

     

    _R



  • 3.  Re: Extract specific columns from Change Request

    Posted 10-30-2018 02:58 AM

    Thanks raghu