Skip to main content
PH_107698351-Visitor
1-Visitor
Feb 2, 2016 9:57 PM UTC
Question

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

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

    3 replies

    VolkerEckardt17-Peridot
    17-Peridot
    Feb 13, 2016 12:37 PM UTC

    Hi Paul,

    why not just executing:   aa users

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

    Hope this helps

    Volker

    Translate
    PH_107698351-VisitorAuthor
    1-Visitor
    Feb 15, 2016 8:11 PM UTC

    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

    Translate
    VolkerEckardt17-Peridot
    17-Peridot
    Feb 18, 2016 7:07 PM UTC

    Hello Paul,

    What about:

    a) integrity mksdomaingroups --fields=name,description

    b) im groups --fields ....

    Does that help?

    Translate
    Terms & ConditionsAccessibility statement