IT Process Automation

  • Private Community

  • 1.  Operator Query Databse in IT PAM

    Posted Jun 05, 2015 04:12 PM

    Hello,

    In SQL, how to pass parameter containing conditions in IT PAM with the operator query database?


    Thanks !

     





  • 2.  Re: Operator Query Databse in IT PAM
    Best Answer

    Broadcom Employee
    Posted Jun 05, 2015 05:18 PM

    In the Query Database operator in the Expression field, put your sql statement in double quotes and then any PAM variables you want to use in that statement, keep them out of the quotes with a plus sign in front.  So for example:

     

    "select instance from " + Process.tablename

     

    Andrew Thompson

    Sr Support Engineer

     

    CA Technologies | 2002 Summit Blvd Suite 1500 | Atlanta, GA 30319

    Office: +61137 | Andrew.Thompson@ca.com

     

    <mailto:Andrew.Thompson@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[Google+]<http://www.ca.com/us/rss.aspx?intcmp=footernav>



  • 3.  Re: Operator Query Databse in IT PAM

    Posted Jun 08, 2015 09:24 AM

    Thanks !