Hi,

I need to create a report that lists who has ack'd a sensor alarm.

I believe something similar to the following should have the username in the message column: api/table.csv?id=125881&content=messages&filter_status=620&filter_status=608&filter_status=607&count=*&columns=objid,datetime,parent,type,name,status,user

However, this does not contain the user info as it does in the interface.

I think this is a similar issue to: https://helpdesk.paessler.com/en/support/solutions/articles/84318-message-status-acknowledged-does-not-showing-user#reply-295773

Any answers would be gratefully recieved.

Article Comments

Hi there,

Thank you very much for your request. Please check our PRTG web interface and navigate to Setup | PRTG API | Live Data to find an overview and documentation of API queries that can be used to extract live data out of PRTG. On this page you'll find an example query Log entries of the last 7 days for object id 2003 with the following API query:
api/table.xml?content=messages&id=2003&start=0&filter_drel=7days&columns=objid,datetime,type,name,status,message
If you change the ID to the desired object's ID of the sensor (and optional the table from table.xml to table.csv) you'll get the following output:

2213,"2213","2020-10-09 07:33:07 AM","44113.2313349421","EXE/Script Advanced","exexml","State of 'Email and push notification to admin'","State of 'Email and push notification to admin'","Down (Acknowledged)","619","","Acknowledged at 2020-10-09 07:33:07 AM by PRTG System Administrator until 2020-10-09 07:38:07 AM"

Further filtering options, for instance for other time periods, can be also found within the API documentation under Sorting and Advanced Filtering.

Best regards,
Sebastian


Oct, 2020 - Permalink