Symantec Access Management

Expand all | Collapse all

REST Policy Data API  - SQL Join Table Query

  • 1.  REST Policy Data API  - SQL Join Table Query

    Posted 07-03-2018 06:51 PM

    I have a SQL for  policy store query

     

    select
    d.domainname AS domain
    p.policyname AS POLICY
    r.rulename AS rule,

    from


    smpolicylink4 pl,
    smpolicy5 p,
    smrules5 r,
    smdomain5 d,

    where
    p.policyoid = pl.policyoid
    AND pl.ruleoid = r.ruleoid
    AND pl.domainoid = d.domainoid
    AND d.domainname LIKE "search string"

     

     

    If I am REST Policy Data API

    How can I do that ???

    What is the equivalent?

     

    Can I us cuRL PHP to do this?



  • 2.  Re: REST Policy Data API  - SQL Join Table Query

    Posted 07-04-2018 10:02 PM

    Any SM Gurus can help out erictse2 on this enquiry?



  • 3.  Re: REST Policy Data API  - SQL Join Table Query

    Posted 07-04-2018 10:19 PM

    Yes just look at the rest api swagger interface. All calls are in curl. I would just do a call to get all SmDomains then do the search on the retuned json output.