How to monitor status of Reporter's database with external instruments?

Products

• Reporter
• Reporter-S500
• Reporter-VA

Issue/Introduction

This article is meant to provide information about report's database monitoring

Environment

Reporter 11.0.1.1

Resolution

You can track if a DB is loading or not in two ways:

1. Using Web API requests.
   https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/reporter-reference/web_api_params.html
   
   For example,
   https://reporter:8082/api/create?username=admin&password=admin&database=main%20(Unified)&role=_admin&label=myreport1&summarizeBy=sc_filter_category
   If the DB is loaded, it should be shown the similar output:
   

   reportId:655373
   reportName:myreport1
   status:Queued
   percent_done:0

   If the DB is unloaded
   

   httpStatusCode: 500
   httpMessage: Internal Server Error
   detailedMessage: Unable to acquire profile context

   The report can be canceled after checking
   https://reporter:8082/api/cancel?username=admin&password=admin&reportid=655373
   
   
2. Also you can configure a syslog server with the Info level.
   https://techdocs.broadcom.com/us/en/symantec-security-software/web-and-network-security/reporter/11-0/reporter-reference/Rptr_CLI/config-mode-commands/c_event-log.html
   And track on the server the similar events:

Note: The reporter doesn't support the DB monitoring via SNMP.