NetXMS Support Forum

English Support => General Support => Topic started by: Sorikan on April 10, 2025, 09:11:27 PM

Title: Business Services - wipe data?
Post by: Sorikan on April 10, 2025, 09:11:27 PM
After setting up business services (which is pretty slick BTW) how do I clear out the data from the setup period so that my percentages are correct?
Title: Re: Business Services - wipe data?
Post by: Filipp Sudanov on April 11, 2025, 05:15:54 PM
There's no option to clear history from the GUI, but you can delete data from database.

You need to stop server process prior to deleting from the DB!!!

The table you need are these two: BUSINESS_SERVICES_DOWNTIME, BUSINESS_SERVICE_TICKETS. First keeps downtime records, second keeps tickets which are displayed at the bottom when viewing a business service.

Document describing the DB is here:
https://www.netxms.org/documentation/datadictionary-latest/#t-business-services-downtime
https://www.netxms.org/documentation/datadictionary-latest/#t-business-service-tickets