Unicon - Scout - Export daily report of All Devices in Scout using Report Generator
Article ID: CTX696133
Updated On:
Description
Solution
The best current approach is to create an SQL query to fetch the required data and run this query daily using a cronjob.
Steps to Resolve
-
Create an SQL Query:
-
Write an SQL query to retrieve the device information you need from the Scout database.
-
-
Set Up a Cronjob:
-
On your server, set up a cronjob to run the SQL query at your preferred time each day.
-
Configure the cronjob to export the data in your desired format (e.g., CSV).
-
-
Automate Export:
-
Ensure the cronjob saves the export to a designated folder.
-
Environment
Stay updated on future Scout releases for the REST-API feature.
Issue/Introduction
Currently, the Report Generator in Scout does not support an automated daily export of information from all devices.
Additional Information
Future Enhancement
-
We are planning to implement a REST-API Endpoint in the Scout Board, which will allow for more advanced filtering of devices.
-
Once the REST-API is available, it will simplify the process of generating and filtering reports directly from the Scout Board.
