Skip to main content
P
PH_107698351-Visitor
1-Visitor
February 2, 2016
Question

Is it possible to run a sql command from a trigger?

  • February 2, 2016
  • 1 reply
  • 1807 views

I have defined an executeCmdAs with the following command "im diag --diag=runsql --param=select login from mksdomainusers".  However, the following error is returned: "Runsql Diagnostic: SQL Statement execution failed: Invalid SQL type: sqlKind = UNINITIALIZED"

Thank you,

Paul Hartwig

    1 reply

    V
    VolkerEckardt17-Peridot
    17-Peridot
    February 13, 2016

    Hi Paul,

    why not just executing:   aa users

    This returns the same result, and could also become a trigger element

    Hope this helps

    Volker

    P
    PH_107698351-VisitorAuthor
    1-Visitor
    February 15, 2016

    Volker,

       I need to determine which users are defined in the MKS domain and which users are coming from LDAP.  PTC provided me a way to get the information I need for this issue, but I still have another where I need to get the groups and their descriptions.

    Thank you,

    Paul Hartwig

    V
    VolkerEckardt17-Peridot
    17-Peridot
    February 18, 2016

    Hello Paul,

    What about:

    a) integrity mksdomaingroups --fields=name,description

    b) im groups --fields ....

    Does that help?

    Terms & ConditionsAccessibility statement