Batch updates a database.
Service | batchupdate-db |
Permission | Update DB XML API |
Version | 4.6.5 or later |
Parameter | Definition |
|---|---|
HH$Name | Filter by database name (like operation) |
HH$DbType | One of the database types |
HH$DbVersion | Filter by database version |
HH$DbVersionCompare | Operator to compare the database version value to EQ, GT, LT, GE, LE, NE |
HH$EnableNetMonitor | Boolean — Enable or disable network monitoring |
HH$EnableMemMonitor | Boolean — Enable or disable memory monitoring |
HH$AddParams | Add a list of advanced parameters to each matching database in the format
|
HH$RemoveParams | Remove a list of advanced parameters from each matching database |
For example, to enable network monitoring for all databases of type MSSQL and version less than 2008 (SQL Server version=10), submit a request:
https://127.0.0.1:8443/xmlapi.svc?service=batchupdate-db&HH$DbType=MSSQL&HH$DbVersion=10&HH$DbVersionCompare=LT&HH$EnableNetMonitor=true