---
sourceDocument: Xanadu Employee Service Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/employee-service-management

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Employee Service Management

ft:clusterId :

    - emplsm

bundleId :

    - emplsm

workflow :

    - Employee


---

# Workplace Connectors Data Summarization

# Workplace Connectors Data Summarization {#ariaid-title1}

* Release version: Xanadu
* 
* Updated February 26, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Execute the DataSummarization schedule job to retrieve the daily aggregate summary data. When the schedule job runs, it collects the data from target table and MetricBase and stores the daily aggregate data into the respective
summary table.

The MetricBase application stores time series data, which is data that is sampled at regular intervals. The administrator specifies a metric to store and how often to collect it by creating a time-series definition in MetricBase. The time-series data is sent from instance to the MetricBase server using the MetricBase API**.** For more information about MetricBase, see [Defining and collecting MetricBase data](https://www.servicenow.com/docs/access?context=collecting-metricbase-data&version=xanadu&pubname=xanadu-servicenow-platform&ft:locale=en-US).

Workplace Connectors supports retrieving the time series data from the MetricBase and populates the data into the following summary tables:

Navigate to AllWorkplace ConnectorsSummary to view the summary tables.
{#data-summarization__table_cth_c32_gfc__entry__2}

| Table Name | Description |
|-|-|
| Space Occupancy Daily Summary Data | The Space Occupancy Daily Summary Data (sn_wsd_wc_space_occupancy_daily_summary_data) table displays aggregate data retrieved from the Occupancy and Environment Data target table and MetricBase. The DataSummarization scheduled job runs daily and loads the daily aggregate summary data into the table. It collects the metric data (Space Occupancy Value) from the target table (Occupancy and Environment data) and MetricBase and populates the data in the summary table (Space Occupancy Daily Summary Data). |
| Wi-Fi Daily Summary Data | In the Wi-Fi Daily Summary Data table (sn_wsd_wc_wifi_daily_summary_data), you can view aggregate data from Wi-Fi providers to determine employee attendance in the office. The DataSummarization scheduled job runs daily and retrieves the summary data based on the Wi-Fi time-series data stored in the Wi-Fi Data target table and MetricBase database. |
| Environmental Daily Summary Data | The Environmental Daily Summary Data table (sn_wsd_wc_environmental_daily_summary_data) displays daily aggregate environment data, including air quality and temperature for a workplace. The DataSummarization scheduled job runs daily and loads the daily aggregate summary data into the Environmental Daily Summary Data table. It collects metric data from the target table (Occupancy and Environment data) and MetricBase and populates the summary table data. |
| Environmental Hourly Summary Data | The Environmental Daily Summary Data table (sn_wsd_wc_environmental_hourly_summary_data) displays hourly aggregate environment data, including air quality and temperature data for a workplace. The DataSummarization scheduled job runs daily and loads the hourly aggregate summary data into the Environmental Hourly Summary Data table. It collects metric data from the target table (Occupancy and Environment data) and MetricBase and populates the summary table data. |
[Table 1. Summary Data]

{#data-summarization__table_cth_c32_gfc}
* **[Archive and purge summary data tables](https://servicenow-prod.fluidtopics.net/3CAipzMZykySmOs7QHNRWw)**   
  Use the archive rules and destroy rules to archive and purge the summary data. Archive and purge the Space Occupancy Daily Summary Data (sn_wsd_wc_space_occupancy_daily_summary_data), Environmental Daily Summary Data (sn_wsd_wc_environmental_daily_summary_data), Environmental Hourly Summary Data (sn_wsd_wc_environmental_hourly_summary_data), Wi-Fi Daily Summary Data (sn_wsd_wc_wifi_daily_summary_data) table records.
* **[Run the DataSummarization on-demand job](https://servicenow-prod.fluidtopics.net/oeEpUyY5dSA9xnP5TZFJ8A)**   
  Use the ad-hoc OnDemandDataSummarization schedule job to retrieve summary data for the required connector type if the DataSummarization schedule job fails to populate the occupancy, environmental, or Wi-Fi summary reports.
* **[Migrate event data to new summary tables](https://servicenow-prod.fluidtopics.net/VRC8fpNETYJGXyL_YOOPQQ)**   
  You can migrate old sensor event data from the existing tables to the new summary data tables using the OnDemandDataMigration scheduled job. This job summarizes daily aggregated data based on specified criteria such as day-wise, location hierarchy-wise, and business entity-wise for occupancy, environment, badging, and Wi-Fi data. The summarized data is stored in the new Space Occupancy Daily Summary Data, Wi-Fi Daily Summary Data, Environmental Daily Summary Data, and Environmental Hourly Summary Data tables.

**Previous topic:** [Environmental data form for Workplace Connectors](https://servicenow-prod.fluidtopics.net/cYW2xFrOzmEJEO6Ck3psyg "Environmental sensor data form has pre-filled environmental data values and units of measure.")  
**Next topic:** [Archive and purge summary data tables](https://servicenow-prod.fluidtopics.net/3CAipzMZykySmOs7QHNRWw "Use the archive rules and destroy rules to archive and purge the summary data. Archive and purge the Space Occupancy Daily Summary Data (sn_wsd_wc_space_occupancy_daily_summary_data), Environmental Daily Summary Data (sn_wsd_wc_environmental_daily_summary_data), Environmental Hourly Summary Data (sn_wsd_wc_environmental_hourly_summary_data), Wi-Fi Daily Summary Data (sn_wsd_wc_wifi_daily_summary_data) table records.")

*[\>]: and then