Simeon Sync Power BI dataset

  • Last update on September 27th, 2024

This dataset serves as a foundation for creating custom queries in both Log Analytics and Power BI reports. Each row in the data source represents a single property of a configuration, allowing for granular analysis and monitoring.

With this information, you can develop specific Log Analytics queries to monitor various aspects of tenant configurations. 

These queries can be further refined into real-time alerts, notifying you of critical changes or even triggering automated responses when predefined conditions are met.

Available fields in the dataset

The fields available in the dataset are as follows:

Organizational and Tenant Information 

  • Organization: The DevOps organization housing the tenant 
  • Tenant: Name of the tenant running the sync
 
 

Sync Details

  • Action: Sync stage (e.g., export, preview, deploy) 
  • Sync_Run_Name: user-specified or automated name for the sync run 
  • Sync_Comment: additional user comments from the Sync page 
  • Sync_Date_Time: the date and time of the Sync in UTC time zone
 
 

Configuration information

  • Configuration: name of the configuration 
  • Configuration_Full_Name: full name of the configuration, including the path where the configuration can be found
  • Configuration_Description: detailed description for Configuration Manager Baseline configurations 
  • Configuration_Type: the configuration type used by Configuration Manager to distinguish where a config should be deployed to (e.g., MSGraph:Groups)
  • Configuration_Type_Description: translation of the Configuration Type
 
 

Baseline and reconciliation data

  • Baseline_Name: the name of the baseline the tenant is using. If the tenant does not have a baseline, the value is [No Baseline]
  • Baseline_Property_Value: the baseline value of the property (if applicable) at the time of the Sync
  • Configuration_Reconciliation_Type: the section that the configuration falls into on the Reconcile Screen - only in tenant, available from baseline, conflicting with baseline, matching baseline 
  • Property_Reconciliation_Type: similar to the Configuration Reconcile Type, but at the property level
 
 

Property details

  • Property_Name: the name of the property being reported on
  • Property_Value: the value of the property at the time of the sync 
  • Old_Property_Value: captures the previous value of the property before the Sync changes are applied
 
 

Change and error information

  • Change_Type: the action the Sync performed (Removed, Added, Changed, Unchanged, Skipped, Failed)
  • Error_Message: if the configuration fails for any reason, the full error message is captured in this column