3 Replies Latest reply on Aug 4, 2016 1:59 AM by Peter Weighill

    SQL script to get only actions used on specific module

    Specialist

      Hello Guys,

       

      I would appreciate if i can get a query to get the details of all actions used in specific module like Incident.

       

      The below statement list out all actions used in different module and also OOTB ones, but i would like to see only actions limited to our Incident module.

       

      SELECT distinct([lc_name])

          

        FROM [IMS].[dbo].[lc_action]

       

       

      Or

      Let me know which tables to join and the seam to join to get the required details.