As you monitor your SQL server using SQLDBManager Plus, you may come across situations where certain important server-related data is not captured by the default fields present in SQLDBManager Plus. In such situations, you may want to add extra field types to capture that information. The 'Custom Fields' option allows you to configure these extra field types as per your business requirements.
Configuring Custom Fields
Click the Custom Fields button in the SQL Overview section of the SQL details page. This will open the Custom Fields section immediately below, where you can modify existing fields or add new fields.
There are 3 different tabs in the ‘Custom Fields’ section.
Custom Fields: In this tab, there are some preset fields such as Label, Impact, etc. You can edit the fields and specify their values as necessary. Apart from the default fields, you can add custom fields of your own if required. Just click the icon in the right-hand corner of the ‘Custom Fields’ tab. This will open the ‘Add/Remove Custom Fields’ popup window where you can add new fields, edit current fields or remove unwanted fields.
User/Owner: This tab allows you to associate users to the particular monitor or SQL group. All types of user roles such as user, operator and administrator are supported.
Location: In this tab, you can specify information pertaining to the physical location of the server. The available fields include Location Name, Floor, building, city, state, country, postal code and zip code.
|Note: The default values for custom fields of a monitor are inherited from the parent SQL group.|