CA Service Management

 View Only
  • 1.  CI's attached to Change Order

    Posted Mar 29, 2020 03:37 AM
    Dear Team

    how can i check CI's attached in Change Order Tickets from sql query? i know there is a column has_CI which shows only 0 or 1 value. But i want to know that which & how many CI's attached to specific Change Order ?

    Anyone can help?

    @Lindsay_Estabrooks


  • 2.  RE: CI's attached to Change Order
    Best Answer

    Posted Mar 29, 2020 04:23 AM
    got the information

    usp_lrel_asset_chgnr