The MGDC for SharePoint team continues to improve the available datasets.
This time around, we are introducing additional columns to some of our existing datasets.
- 2 new archive-related properties in the Sites dataset
- 2 new storage-related properties in the Sites dataset
- 4 new owner and member properties in the Groups dataset
- 1 new sharee property in the Permissions dataset
Here is a summary of the 9 changes in the 3 datasets (Sites, Groups and Permissions):
|
Dataset |
Column |
Type |
Description |
|
Sites |
SiteArchivedBy |
String |
Who archived the site. Null if not archived |
|
Sites |
SiteArchivedTime |
DateTime |
When the site was archived. Null if not archived |
|
Sites |
LastContentChange |
DateTime |
When the site contents were last changed (in UTC) |
|
Sites |
StorageMetrics. |
int64 |
Total size of additional file streams in bytes, excluding the latest version, previous versions and metadata |
|
Groups |
Owner. |
String |
Login name of group owner. If ending with _o, this should be expanded using the owners of the group, not the members |
|
Groups |
Owner. |
String |
User Principal Name of group owner |
|
Groups |
Member. |
String |
Login name of group member. If ending with _o, this should be expanded using the owners of the group, not the members |
|
Groups |
Member. |
String |
User Principal Name of group member |
|
Permissions |
SharedWith. |
String |
Login name for the sharee. If ending with _o, this should be expanded using the owners of the group, not the members |
* When the LoginName ends with _o, that means that this group should be expanded using the owners of the group, not the members of the group.
These changes are non-breaking, which means that your existing pipelines will continue to run. We also let this change sit for 21 days, so that delta datasets are also not impacted.
Anyone starting fresh with MGDC for SharePoint will automatically get the new columns in their pipelines. If you have existing pipelines and want to use the new columns, you will need to update your MGDC application, get that update approved and then update your pipeline to pull the new schema.
For more details about updating your pipelines to include new columns, or to see how these can be leveraged in specific scenarios, see these articles:
- How can I track the lifecycle of a SharePoint site?
- How are SharePoint Groups and Security Groups used together?
- MGDC for SharePoint FAQ: How to deal with schema changes
- Main MGDC for SharePoint article: https://aka.ms/SharePointData
To view the complete schema for all SharePoint datasets in MGDC, visit https://aka.ms/SharePointDatasets
Microsoft