- Print
- PDF
This feature has limited availability. Please consult your sales representative.
Cisco Provider Connectivity Assurance (formerly Skylight performance analytics) can schedule the export of datasets at regular intervals when the system has available resources during the off-hours. You can export session performance metrics in a CSV (comma separated values) compressed format.
Note: The report slots available for a dataset export are limited. With release 24.05, you can view the number of used report slots against the maximum available.
If you reach the limit and require more reports, we recommend to remove redundant reports.
Overview
The Dataset Export feature generates a CSV table format from the data ingested by Cisco Provider Connectivity Assurance. The report can be downloaded from a GUI or from the link provided in the report availability email.
Users can provision data set exports via the GUI and API. This feature is not exclusive to administrators. Users can provision new export configurations, that is, schedule dataset export reports.
However, users are can only share or email the report with user groups to which they belong.
Navigate
- Reports ▶ Dataset
This contains a list of provisioned reports. Clicking a report displays the provisioned information. Click Download to obtain a report.
Dataset format description
- The dataset is compressed using
gzip
format.- WinZip is an example of a tool that can decompress the format.
- The dataset is in the
CSV
(comma separated values) format.
Provision
Name
Provide a string value to identify a report from the report list. This value is used also used in the email if provisioned.
Data (Metrics and metadata)
The user is to provide the following:
- Object Type (example: TWAMP-SF). There is only one type per report.
- Direction: choices are NON(-1), SD(0), DS(1), and RT(2). At least one must be selected.
Note: number will be used in the CSV report.
- Metrics:
- Aggregate Type: (AVG, MAX, MIN, SUM)
- Threshold crossing: details below
For example:
- A user can choose
TWAMP DelayP95 aggregated with a maximum operation for direction P2R.
- A user can choose to add categorical data such as
router_hops
Threshold crossings
The dataset can include a column that holds the results (TRUE
or FALSE
) condition of a threshold crossing.
You can select this by selecting the ellipsis and then selecting Set up threshold
. The following image shows an example of a threshold crossing settings where the result will be true when averageThroughput<ax
is over 5000.
Group by
This section cannot be changed currently. The data in the report is group by using timestamp, and monitored Object.
Filters
Optional field. User can define a list of metadata and its values to narrow down the data for the report.
Busy Hour
- When busy hour is set to
TRUE
, the dataset will only contain records with the busy hour tag. - When busy hour is set to
FALSE
, the dataset will contain records with and without the busy hour tag.
For more details on this feature: 21.03 Release Notes
Maintenance Window
- When maintenance window is set to
TRUE
, the dataset will contain records with and without the maintenance tag. - When maintenance window is set to
FALSE
, the dataset will only container records without the maintenance tag.
For more details on this feature: 21.03 Release Notes
Data Cleaning
- When data cleaning is set to
TRUE
, the dataset will contain records where the data is clean. - When data cleaning is set to
FALSE
, the dataset will records regardless of data cleaning tag.
For more details on this feature: How does data cleaning work?
Granularity (Calculated)
There are two granularities available: daily
and hourly
.
Note: Use
hourly
for Duration=Day. Use daily
for Duration=week or month.Duration (Interval/Period)
The interval of the dataset can be a day, week, month.
Frequency
You can schedule the export of data with the following frequencies: daily
, weekly
, monthly
Generated
The time provisioned will be the start time of the report.
Note: The dataset report is generated in the Greenwich Mean Time (GMT / UTC +0) zone.
The time in the dataset congifuration follows the tenant time zone. Cisco Provider Connectivity Assurance converts this time to GMT and generates the report at the converted time.
Every dataset will have its last record end on the hour specified by this value for the previous
day.
For example, if you set the schedule duration to be 1 day and at 1300, then the report will be between 2021-01-01T13:00 and 2021-01-02T12:00
Sharing Datasets (e-mail)
The datasets are downloaded through the Skylight user interface or through an API. The user may opt-in to get an email alert when the export is ready.
Obtaining a Report
Example download from the datasets (GUI)
Example of an email:
You will receive once the dataset is ready for download.
To download the report from email
- Click the tenant url (https://jw6ten1.jwatson6.npav.accedian.net)
- Login to the tenant. Ensure to use a user that has permission to download report.
- Click Click to download from email. This will download the report to your local disk.
Dataset Example
Your dataset may be different from this example. This example is only to provide you with idea on how the dataset looks.
Deleting Dataset Reports
You can delete report instances within a report configuration or delete the report configuration.
To delete a report instance within a dataset report configuration:
Go to Reports ▶ Dataset, then select the row for the configuration you want to delete a report instance from.
Select the report instance.
Click the icon.
To delete a dataset report configuration:
CAUTION: Deleting a dataset report configuration deletes all its report instances.
Go to Reports ▶ Dataset, then select the row for the configuration you want to delete.
Click the ellipsis (...) , then click Delete config.
© 2024 Cisco and/or its affiliates. All rights reserved.
For more information about trademarks, please visit: Cisco trademarks
For more information about legal terms, please visit: Cisco legal terms
For legal information about Accedian Skylight products, please visit: Accedian legal terms and tradmarks