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

    SQL script to get only actions used on specific module


      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]




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