Executing the Get Dataset Query with Thresholds Utility

Previous Next JavaScript must be enabled to correctly display this content

8.2.2 Executing the Get Dataset Query with Thresholds Utility

To execute the Get Dataset Query with Thresholds Utility, follow these steps.

After the Alert Creator process completes, execute the get_dataset_query.sh script as follows:
```
<OFSAAI Installed Directory>/database/db_tools/bin/get_dataset_query.sh <Dataset ID> <Threshold Set ID>
```
The dataset query automatically prints to standard output, which you can copy and paste into any other application.
When the dataset query does not find a dataset, output is:
```
Error: Dataset not found. 
```
When the dataset query does not find a threshold set, output is:
```
Error: Threshold Set not found.
```
Optional: Redirect the output into a text file as follows:
```
<OFSAAI Installed Directory>/database/db_tools/bin/get_dataset_query.sh <Dataset ID> <Threshold Set ID> query.sql
```