Microsoft SQL

[guidito_ito]

Hi. Is there a way to run a sql query by pandora agent in ms sql?
I've tried ODBC but it seems like the database has that strange nvchar issue.
Then I tried using sqlcmd.exe: when using the windows CMD the result is fine, but using module_exec I can't get anything. taking a look at the XML the data field is empty. It's not a strange thing what i do just sqlcmd.exe with a user, database, query and then | tr -d "\r\n" and that's it.
I can't figure it out I think is an encoding issue of some kind but i'm not sure please help me

[opike]

The agent should pick up any text that is written to standard out.

When you run you sql script from the command line what does it write to standard out?

Also, you can monitor the files in server_path directory (as specified in the pandora_agent.conf) and see exactly what information is being picked up by the agent. This might help you troubleshoot what is going on.