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

[phartwig]

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

[VolkerEckardt]

Hi Paul,

why not just executing:   aa users

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

Hope this helps

Volker

[phartwig]

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

[VolkerEckardt]

Hello Paul,

What about:

a) integrity mksdomaingroups --fields=name,description

b) im groups --fields ....

Does that help?