1 Reply Latest reply on Jan 14, 2020 7:20 AM by Keyur Patel

    Manually deleted a condition or resource in Control-M

    Salvatore Santangelo
      Share This:

      How can I see which user manually deleted a condition or resource in Control-M?

        • 1. Re: Manually deleted a condition or resource in Control-M
          Keyur Patel

          Hi Salvatore Santangelo

           

          If you are using SQL as Control-M database then SQL query to dbo.AUDIT_ACTIVITIES on EMDB

           

          Select * From [emdb].[dbo].[AUDIT_ACTIVITIES] where [USERNMAE] = '<username you want to search>' and [OPERATION] like 'DELETE%'

          or

          Select * From [emdb].[dbo].[AUDIT_ACTIVITIES] where [USERNMAE] = '<username you want to search>' and [OPERATION] like 'DELETE CONDITION '

          or

          Select * From [emdb].[dbo].[AUDIT_ACTIVITIES] where [USERNMAE] = '<username you want to search>' and [OPERATION] like 'DELETE CONTROL RESOURCE'

          or

          Select * From [emdb].[dbo].[AUDIT_ACTIVITIES] where [USERNMAE] = '<username you want to search>' and [OPERATION] like 'DELETE QUANTITATIVE RESOURCE'

           

          Hope this will help

          Thanks

          2 of 2 people found this helpful