N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
Page History
...
- Refresh your browser and navigate to Datasets on the MSPbots app.
- On the Datasets tab, the New SQL Agent Dataset button.
- On the New popup enter a Nameand a Descriptionfor the dataset.
- Next, click the Data Cleaning tab to enter the data SQL data to be captured.
- In the SQL field, select the data from your databases. The best practice is to test the SQL in your databases first.
- Provide a description.
- Click the DB field and select your dataset.
- Input your desired Sync Frequency. This setting is in minutes.
Click Confirm. This will send a test SQL and a preview of the data.
Info If the aggregate function is used in SQL, please use the as statement to enable the alias function like this:
Select status ,count(*) as counts from sys_usergroup by status
Please wait until the data is synced in the next cycle. After sync, you can preview the data on the Dataset tab and use this dataset to create your widgets or bots.
Overview
Content Tools