Overview
The 'Daily Export' feature can be used to export data from the SiteManager Platform to a series of CSV files in a location chosen by the user, every 24 hours. This enables data from the SiteManager Platform to be ingested into third-party applications using the common CSV format (e.g. Power BI, Splunk, etc). This enables custom dashboarding and reporting, adding flexibility to SiteManager Platform's suite of reporting capabilities.
The 'Daily Export' settings can be found on the 'Daily Export' page of the SiteManager Platform settings:
To use the 'Daily Export', first select 'Enable'.
Exports
This section of the 'Daily Exports' page is used to control which CSV exports are created and the time each day that the export takes place:
The table below contains an overview of the different options and the columns that included in the CSV files they create:
|
Export Type
|
Description
|
CSV Columns
|
|---|---|---|
| Backup Logs | This CSV provides a breakdown of the last operation run by each Site Manager Agent/Macrium Reflect for the last 24 hours. |
Site Name, Computer, Log Type, Level, Date, Filename, Result, Error Message, Definition, Backup Method |
| Computers | This CSV provides a breakdown of every computer that has been registered with the Site Manager server and includes general information, information about the health of the computer, and licensing information. |
Site Name, Computer, Connection Status, Last Connection Time, Description, Operating System, Domain, Active Directory Group, Domain DN, Agent Version, Backup Definitions, Schedule Name, Computer Information, License Status, Standalone License Key, Standalone Reflect Edition, Standalone Reflect Version, Last Backup Success, Last Full Backup Success, Last Differential Backup Success, Last Incremental Backup Success, Last Backup Fail, Last Operation, Last Operation Status, IP Address, MAC Address, User Tags |
| Event Logs | This CSV includes all logs from the event logs page over the last 24 hours. | Site Name, Timestamp, Source, Type, Event, Message, User, Computer, SessionId |
| Repository Changes | This CSV provides information about repository changes over the last 24 hours. | Site Name, Repository Name, Repository Path, Computer, Oldest Backup, Newest Backup, Total Backups, Total Full, Total Differential, Total Incremental, Total File Size, File Count Change, File Size Change |
| Repository Contents | This CSV provides a list of every backup across every repository in the Site Manager. | Site Name, Repository Name, Repository Path, Computer, Filename, File Size, Time Last Updated, Definition Name, Schedule Name, Backup Method, Backup Set, Backup Level, Backup Type |
| Repository Status | This CSV provides more general information about each repository including its disk space, file counts, and online/offline status. | Site Name, Repository Name, Repository Path, Repository Type, Repository Status, Total Space, File Count, Computer Count, Total Used, Total Used by Backups, Free Space |
| Scheduled Backups | This CSV provides information about every active schedule in the Site Manager. | Site Name, Definition Name, Definition Description, Schedule Name, Schedule Description, Computers, Full Backup Schedule, Differential Backup Schedule, Incremental Backup Schedule, Full Retention Rules, Differential Retention Rules, Incremental Retention Rules, Schedule Options |
Output Information
'Output Information' controls the location where the CSV exports will be created, the names of the exports, and the credentials that are used to create the exports.
The credentials that are used to write the files can be controlled by specifying a username, password, and domain. If left blank, the SYSTEM account local to the Site Manager server is used.
'Output Path' controls the destination for the daily export, this can either be a local file path or a UNC path to a network share. The credentials that were specified previously should have write access to this path. The folder paths can be specified here using replaceable parameters, allowing a number of configurations, including creating each day's exports in the same folder (potentially overwriting old files) or placing each day's exports into a different subfolder. There are several supported variables:
|
Variable
|
Description
|
Example
|
|---|---|---|
| $date | Date of export in YYYY-MM-DD format. | C:\DailyExport\2024-09-09 |
| $time | Time of export in hhmm format. | C:\DailyExport\1335 |
| $isotime | Time of export in ISO 8601 in YYYY-MM-DDThhmmss format. | C:\DailyExport\2024-09-09T133536 |
| $servername | Name of the Site Manager server, this is controlled on the 'System' page of the Site Manager settings. | C:\DailyExport\SMServer |
| $exporttype | Type of export (e.g. Computers, EventLogs, etc), when this variable is used, each CSV will be placed in a different folder. | C:\DailyExport\Computers |
| $increment | If a daily export is performed to same destination as previous daily exports, existing daily exports can be overwritten. $increment will ensure that a new folder is created with each daily export. | C:\DailyExport\1 |
'File Name' will control the name of the exported CSV files. The file names can be specified using replaceable parameters, allowing a number of configurations. When exporting the CSVs to the same folder as previous exports, the variables can ensure that each CSV export is uniquely named from the last.
|
Variable
|
Description
|
Example
|
|---|---|---|
| $date | Date of export in YYYY-MM-DD format. | C:\DailyExport\2024-09-09-Computers.csv |
| $time | Time of export in hhmm format. | C:\DailyExport\1335-Computers.csv |
| $isotime | Time of export in ISO 8601 in YYYY-MM-DDThhmmss format. | C:\DailyExport\2024-09-09T133536-Computers.csv |
| $servername | Name of the Site Manager server, this is controlled on the 'System' page of the Site Manager settings. | C:\DailyExport\SMServer-Computers.csv |
| $exporttype | By default, the export type will be appended to the end of the filename (e.g. Example-Computers.csv), this variable enables the export type to be specified in other parts of the file name (e.g. ComputersExample.csv). | C:\DailyExport\ComputersExample.csv |
| $increment | If a daily export is performed to same destination as previous daily exports existing daily exports can be overwritten if the new file name is the same as previous files. $increment will simply add a number that is incremented with each export, meaning that a new file is created with each export. | C:\DailyExport\1-Computers.csv |