Properties on dbWatch Servers
The available properties for server are:
| Name | Description | Return type | Typical values |
|---|---|---|---|
| adminlist | Not currently used | Entity | Default Management |
| application | The name of the dbWatch application | Entity | dbWatch |
| artifact | The management, job and report artifact available to this dbWatch Server. | List of Entities | com.dbwatch.management:sql_server_node_backups:1.3, com.dbwatch.management:mysql_result_cpu-pct-graph:1.0, … |
| autodiscoverscan | List of network ranges that should be scanned for instances | List of Entities | 192.168.6.0/24 |
| avgreceive | The average number of messages recieved by the server pr minute | Number | 99 |
| avgsend | The average number of messages sent by the server pr minute | Number | 98 |
| cpuload | An approximation of the current cpu load on the Server | Number | 12.76 |
| currenttime | A text representation of the current time on the server | String | Tue Oct 10 10:13:22 CEST 2023 |
| dictionary | The dictionaries that are defined on this dbWatch Server | List of Entities | Default |
| discoveredinstance | List of instances that have been discovered by the autodiscover process | List of Entities | mysql/192.168.6.234/3306, postgres/192.168.6.223/5432, … |
| domain | The dbWatch domain this dbWatch Server is part of | Entity | acme.com |
| domaincontroller | The dbwatch domain the server is domain controller for (if any) | String | acme.com |
| extension | The available extensions on this dbWatch Server (currently only E-Mail extension) | List of Entities | E-Mail extension |
| file | The management, job and report xml files available to this dbWatch Server | List of Entities | SQL_Server_menuitem_disable_db_obj_sepec.xml, SQL_Server_menuitem_databases_restore_snapshot.xml … |
| flush | Flushes the caches on the dbWatch Server | String | Index flushed |
| group | The groups that are defined on this dbWatch Server. | List of Entities | Development, Production, Test |
| host | The IP address of the dbWatch Server | String | 192.168.7.27 |
| hostname | The host name for this Servers IP address. A reverse name lookup is performed. | String | Libra |
| installable | List of all the jobs that can be installed on instances | List of Entities | DBMS uptime, Lock statistics, Session load |
| instance | All the instances that this dbWatch Server is responsible for | List of Entities | 838791624072954182, 587324160434844496, 531224945097604289, … |
| instancecount | The number of instances this dbWatch Server is responsible for | Number | 74 |
| internal | See internal | Entity | internal |
| iospeed | A number of milliseconds it takes to create a small temp file and write a short text to it. The lower the better. | Number | 5 |
| isdc | If the server is a domain controller or not | Boolean | true / false |
| jobtemplate | The job templates that are defined on this dbWatch Server | List of Entities | To31ECbvuhHj8Kg6, Z60jdT3HkULk12Mh, … |
| license | The dbWatch license for this Server. | Entity | license |
| list | A list of available lists. List are used to define the content available to the users of a module | List of Entities | Default Management, Default Monitoring |
| manager | List of server managers. Used internally for getting manager states | List of Entity | |
| monitoringlist | The list used to define the content of the monitoring module | Entity | Default Monitoring |
| name, displayname | The name of the dbWatch Server | Entity | dbWatch Control Center |
| networkcost | The calculated cost of sending a message through this dbWatch Server | Number | 138 |
| networkrange | The network range that this dbWatch Server thinks its on. Used by the autodiscover process when scanning for unregistered instances | String | 192.168.7.0/24 |
| ostype | The operating system the dbWatch Server is running on. | String | Windows Server 2016/10.0/amd64 |
| osuser | The operating system user the dbWatch Server is running under. | String | MASSOSS$ |
| port | The port number this dbWatch Server accepts connections on. | Number | 7100 |
| reportconfig/schedule | The default schedule for global reports | String | 0 16 5 * |
| reportconfig/path | The default path where global reports will be placed | String | server/report |
| reporttemplate | The global reports templates that are available on this server | List of Entities | Database environment information |
| reporttemplate/displayname | The name of the report template | String | Database environment information |
| reporttemplate/description | The description of the report template | String | This report will show the database environment information |
| role | The roles that are defined on this dbWatch Domain Controller | List of Entities | dbw_role_domain_manager, ud_role_dba |
| role/name | The displayname for the role | String | Domain Manager, DBA |
| routeinfo | The routing table for the dbWatch Server | Text blob | |
| scheduledreport | The global reports that are scheduled on this dbWatch Server | List of Entities | Scheduled Report [Database backup report] – 3 |
| securitygroup | The security groups that are defined on this dbWatch Domain Controller | List of Entities | dbw_sg_all_instances, dbw_sg_domain_admin |
| securitygroup/displayname | The name of the security group | Entity | All Instances, Domain Configuration |
| socket | The active connections on this server. (dbWatch node connections, not database connections). | List of Entities | 6898177628126849188, 6047584236597675033, … |
| socketinfo | Debug info about the active connections on this server (dbWatch node connections, not database connections). | List of String | 10.0.5.218:53410 Connected (id: {8583312666762166566,-4679215439455640848}, version: 22.sep.2023 11:52:03) |
| speed | The number of milliseconds it takes to perform a certain calculation. The lower the better | Number | 92 |
| started | The start time of the dbWatch Server | String | 09.okt.2023 10:45:28 |
| target | All the targets that this dbWatch Server is responsible for. Currently this is the same as instance | List of Entities | 838791624072954182, 587324160434844496, 531224945097604289, … |
| time | The current time on the server as milliseconds since 1970 | Number | 1696925602129 |
| uptime | How long the dbWatch Server has been running | String | 17 days 19 hours 44 minutes 1 seconds |
| user | List of users defined in the domain. Only the Domain Controller will return values | List of Entities | admin, bob, mark, lisa |
| version | The version of the dbWatch Server | String | 26.2.064 |
| versioninfo | Expanded version of the dbWatch Server | String | Control Center Server (26.2.064) |