Difference between revisions of "Script Example: Read Table From Agent"

From NetXMS Wiki
Jump to navigation Jump to search
(Created page with "This script can be put into Script Library and run from server's debug console. It accepts node object name or ID as first parameter, table name as second parameter, and print...")
(No difference)

Revision as of 11:18, 30 June 2013

This script can be put into Script Library and run from server's debug console. It accepts node object name or ID as first parameter, table name as second parameter, and prints content of given table to console.

// Find node object
node = FindObject($1);
if (node == null)
{
	println "ERROR: Node not found";
	return;
}

// REad table data from agent
table = AgentReadTable(node, $2);
if (table == null)
{
	println "ERROR: Cannot read table from agent";
	return;
}

// Print column names
for(i = 0; i < table->columnCount; i++)
	print "| " . left(table->getColumnName(i), 20);
println "|";
for(i = 0; i < table->columnCount; i++)
	print "+" . left("-", 21, "-");
println "+";

// Print data
for(i = 0; i < table->rowCount; i++)
{
	for(j = 0; j < table->columnCount; j++)
	{
		print "| " . left(table->get(i, j), 20);
	}
	println "|";
}