What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

HTTP API / Sort by multiple columns

Votes:

0

Hallo! I try to sort the xml output by multiple values. I already tried:

.../api/table.xml?content=sensors&columns=objid,downtimetime,device,sensor,lastvalue,status,message,priority,minigraph,checkbox&filter_status=5&filter_status=4&filter_status=10&sortby=-status,-downtimetime&username=xxx&password=xxx

and

.../api/table.xml?content=sensors&columns=objid,downtimetime,device,sensor,lastvalue,status,message,priority,minigraph,checkbox&filter_status=5&filter_status=4&filter_status=10&sortby=-status&sortby=-downtimetime&username=xxx&password=xxx

Both are not working. I try to sorty by status (descending) first, then by downtime (descending) to get the ERROR sensors to the top of the list with the longest downtime on top, below the ERROR sensors then the WARNING sensors.

What's the right syntax to sort by multiple columns?

Thank you!

Marc

api http prtg xml

Created on Apr 2, 2017 5:37:43 AM

Last change on Apr 3, 2017 4:45:43 AM by Sven Roggenhofer [Paessler Technical Support]



1 Reply

Votes:

0

You can't sort by multiple columns, simple as that :)

Created on Apr 3, 2017 7:07:09 PM by Stephan Linke [Paessler Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.