CA Service Management

 View Only
  • 1.  Query to get user aproved and date of a request in Catalog

    Posted Aug 06, 2020 02:31 AM
    Hi friends!

    Does anyone have a query or what are the tables to get the approver user and the date of a request in the Catalog?

    Thanks!!


  • 2.  RE: Query to get user aproved and date of a request in Catalog
    Best Answer

    Posted Aug 07, 2020 06:31 PM
    You will find the approver user_id in the usm_request_status table and the created_date of the request in the usm_request table.


    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------