plugin_proval_probeconfig
Purpose
The view is created to present information related to Network Probe configurations in the environment. It consolidates the information for both Generation 1 and Generation 2 probes in one place. The view is used for the data displayed in the dataview CWM - Automate - Dataview - Probe Deployment Audit Re-Defined [View].
This view was created to bypass the word count limit of 2500 for the "SQLBody" column in the Dataviews table. The view is generated by the script, CWM - Automate - Script - Create View "plugin_proval_probeconfig".
Dependencies
- CWM - Automate - Dataview - Probe Deployment Audit Re-Defined [View]
- CWM - Automate - Script - Create View "plugin_proval_probeconfig"
Table
plugin_proval_probeconfig
| Column | Type | Explanation |
|---|---|---|
| ComputerID | INT | Computer ID of the network probe, only if it's available for the location. |
| LocationID | INT | Location ID |
| ClientID | INT | Client ID |
| Client | VARCHAR | Client Name |
| Location | VARCHAR | Location Name |
| Probe Status | VARCHAR | Indicates if the probe is enabled or not. Name of the probe if enabled. |
| Recommended Probe | VARCHAR | Name of the recommended computer if the probe is disabled; otherwise, the name of the probe. |
| Probe Version | VARCHAR | Version of Probe, such as Generation 1 or Generation 2. |
| StatDate | VARCHAR | MAX(statdate) from h_locationstats for the location ID. |
| IsMacAddressScanningEnabled | INT | Indicates if scanning is enabled or disabled for the probe. |
| IsDataCollectionEnabled | INT | Indicates if data collection is enabled or disabled for the probe. |
| MaxDeploymentAttempts | INT | Number of attempts to deploy the agent. |
| AutomatedDeploymentEnabled | INT | Indicates if automated agent deployment is enabled or not. |
| Network | VARCHAR | Network(s) being scanned by the probe. |
| SubnetMask | VARCHAR | Subnet Mask(s) of the Network(s) scanned by the probe. |
| Credentials Title | VARCHAR | Title of credentials being used for agent deployment. |
| Credentials Username | VARCHAR | Usernames of the credentials being used for agent deployment. |
| Discovery Scan Frequency | VARCHAR | Discovery Scan Frequency of the Network Probe |
| Status Scan Frequency | VARCHAR | Status Scan Frequency of the Network Probe |
| Only Run Discovery in Scan Window | TinyInt | Indicates if the probe's discovery scan is running in a limited time only (1 or 0) |
| Discovery Start Time | time | Discovery Scan Start Time |
| Discovery End Time | time | Discovery Scan End Time |
| Spawned Threads | INT | Number of Spawned Threads |
| Scan Network Port | VARCHAR | Default |
| Status Scan Port Number | VARCHAR | Network Port Numbers allocated for scanning |
| Created By | VARCHAR | Creator of the Network Probe |
| Updated By | VARCHAR | Last user to make any changes to the probe |
| Creation Date | datetime | Date of creation |
| Last Update Date | datetime | Last update date for the network probe |