1 Reply Latest reply on Apr 9, 2013 9:07 AM by Tristan

    select sql to see assignments

      I would like to see the assignments that has a certain policy using sql, is there any command to do that?

       

        • 1. Re: select sql to see assignments
          Tristan

          1 - Under 'Queries and Reports' drill down to the 'Policy Assingment' and find a query close enough to your requirements. In this case probably 'Applied Policies by Policy Name'

          2 - Tick the check box next to the policy

          3 - At the bottom the 'Actions' tab will have a 'View SQL' option.

           

          This should give you the basic stucture of your SQL Query. Combine this with a ePO.API extract of the policies to get each policies unique objectID

           

          https://<YOUR_EPO_SERVER>:8443/remote/policy.find?

           

          and you should be able to fill in the missing values in your query.

           

          Message was edited by: Tristan on 09/04/13 15:07:42 IST