SQLWrite() statement shows no queries

Problem:

You are trying to use the Agent Procedure function "SQLWrite()" in an agent procedure. You have copied the XML to \Kaseya\xml\Procedures\AgentProcSQL\0\SQLWrite, but the Agent Procedure interface does not allow you to select the XML file from the list

 

Cause:

The XML file is parsed by the system in the background and must be correct. If the XML has errors, either in the XML format itself, or the query in the XML is invalid - a table name is incorrect, or there is a spelling mistake in the query - then the XML file will not be available in the list.

 

Solution / Workaround:

Check your XML file for errors. Try running the SQL query outside of the XML to check that the query is valid.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Contact us