2.2.4.24 Site Metadata Result Set

Article
10/13/2020

The Site Metadata Result Set contains metadata for a site (2) or sites.

The Site Metadata Result Set is defined using T-SQL syntax, as follows.

 Id                             uniqueidentifier,
 Title                          nvarchar(255),
 Description                    nvarchar(max),
 MetaInfoVersion                int,
 WebTemplate                    int,
 Language                       int,
 Locale                         int,
 Collation                      smallint,
 TimeZone                       smallint,
 Time24                         bit,
 CalendarType                   smallint,
 AdjustHijriDays                smallint,
 AltCalendarType                tinyint,
 CalendarViewOptions            tinyint,
 WorkDays                       smallint,
 WorkDayStartHour               smallint,
 WorkDayEndHour                 smallint,
 ProvisionConfig                smallint,
 Flags                          int,
 Author                         int,
 AlternateCSSUrl                nvarchar(260),
 CustomizedCss                  nvarchar(260),
 CustomJSUrl                    nvarchar(260),
 AlternateHeaderUrl             nvarchar(260),
 SecurityProvider               uniqueidentifier,
 MasterUrl                      nvarchar(260),
 CustomMasterUrl                nvarchar(260),
 {SiteLogoUrl}                  nvarchar(260),
 {SiteLogoDescription}          nvarchar(255),
 AllowMUI                       bit,
 TitleResources                 nvarchar(256),
 DescriptionResource            nvarchar(256),
 AlternateMUICultures           nvarchar(max),
 OverwriteMUICultures           bit,
 UIVersion                      tinyint,
 ClientTag                      smallint,
 AnonymousPermMask              bigint,
 {SiteFlags}                    int,
 {SitePortalURL}                nvarchar(260),
 {SitePortalName}               nvarchar(255),
 MeetingCount                   smallint,
 DefTheme                       nvarchar(64),
 CachedNav                      varbinary(max),
 CachedInheritedNav             varbinary(max),
 CachedNavDirty                 int,
 CachedDataVersion              int,
 NavParentWebId                 uniqueidentifier,
 FirstUniqueAncestorWebId       uniqueidentifier,
 ScopeId                        uniqueidentifier,
 DbNow                          datetime,
 Acl                            varbinary(max),
 {RequestAccessEmail}           nvarchar(255),
 Ancestry                       varbinary(max),
 ProductVersion                 smallint,
 tp_Id                          int,
 tp_SiteAdmin                   bit,
 tp_IsActive                    bit,
 tp_Login                       nvarchar(255),
 tp_Email                       nvarchar(255),
 tp_Title                       nvarchar(255),
 tp_Notes                       nvarchar(1023),
 tp_ExternalTokenLastUpdated    datetime,
 tp_Token                       varbinary(max),
 tp_Flags                       int,
 UserId                         int,
 {SiteSecurityVersion}          bigint,
 tp_Locale                      int,
 tp_TimeZone                    smallint,
 tp_Time24                      bit,
 tp_CalendarType                smallint,
 tp_AdjustHijriDays             smallint,
 tp_AltCalendarType             tinyint,
 tp_CalendarViewOptions         tinyint,
 tp_WorkDays                    smallint,
 tp_WorkDayStartHour            smallint,
 tp_WorkDayEndHour              smallint,
 tp_MUILanguages                varchar(64),
 tp_ContentLanguages            varchar(64),
 {SiteHashKey}                  binary(16),
 {UserInfoListId}               uniqueidentifier,
 {RootWebId}                    uniqueidentifier,
 {SiteLastContentChange}        datetime,
 {SiteLastSecurityChange}       datetime,
 {RbsCollectionId}              int,
 {DenyPermMask}                 tPermMask;

Id: The Site Identifier for the site (2).

Title: The title of the site (2) for display in the front-end Web server.

Description: The description of the site (2) for display in the front-end Web server.

MetaInfoVersion: A counter incremented any time a change is made to the Metainfo for this site (2) and used for internal conflict detection.

WebTemplate: The identifier for the site template used in the site definition to define the base structure of this site (2).

Language: The LCID associated with the site (2) which is used to determine current UI culture, which determines which language resources to use to display messages on the front-end Web server.

Locale: The LCID associated with the site (2) which is used to determine the current culture for regional language specific data formatting such as currency or date and time settings.

Collation: The Collation Order of the site (2) which indicates an additional sorting order that is processed by the back-end database server. The collation method is an implementation-specific capability of the front-end Web server and back-end database server.

TimeZone: The Time Zone Identifier (section 2.2.1.3) for the time zone to be used when displaying time values for this site (2).

Time24: If set to "1", use a 24-hour time format when displaying time values for this site; otherwise, a 12-hour time format can be used.

CalendarType: The Calendar Type that is to be used when processing date values for this site (2).

AdjustHijriDays: If the Calendar Type value is "6", this specifies the number of days to extend or reduce the current month in Hijri calendars for this site (2).

AltCalendarType: The Calendar Type of an alternate calendar for processing date values for this site (2). If NULL, only the CalendarType value is used for this site (2).

CalendarViewOptions: A Calendar View Options Type that specifies the calendar display options setting for this site (2).

WorkDays: A set of Workdays Flags that specify the weekdays defined as the workweek for this site (2).

WorkDayStartHour: The start time of the workday in minutes after midnight for this site (2).

WorkDayEndHour: The end time of the workday in minutes after midnight for this site (2).

ProvisionConfig: An identifier of the site template used to provision this site (2). The following reserved site template identifiers are defined.

Value	Description
-1	This site (2) has not had any site template provisioned.
0	This site (2) has the implementation-specific default site template applied.
1	This site (2) has the Team Collaboration site template applied.
2	This site (2) has the Meeting Workspace site template applied.
3	This site (2) has the Central Administration site template applied.
4	This site (2) has the Wiki site template applied.
9	This site (2) has the Blog site template applied.

Flags: A Site Property Flags value describing the configuration of this site (2).

Author: The User Identifier of the user who is listed as creating this site (2).

AlternateCSSUrl: The URL for a custom CSS sheet file registered on the site (2) for use in pages of the site.

CustomizedCss: This contains an implementation-specific list of custom CSS files associated with this site (2).

CustomJSUrl: The URL for a custom JavaScript file registered on the site (2) for use in pages of the site.

AlternateHeaderUrl: The URL for a custom header HTML page registered on the site (2) for use in pages of the site when rendered on the front-end Web server.

SecurityProvider: COM class identifier (CLSID) of the external security provider for this site (2). This is NULL for sites using the native security implementation.

MasterUrl: The URL for the master page registered on the site (2) for use in pages of the site when rendered on the front-end Web server.

CustomMasterUrl: The URL for an alternate master page registered on the site (2) for use in pages of the site rendered on the front-end Web server.

{SiteLogoUrl}: The URL of an image that represents the site (2) for display in the front-end Web server.

{SiteLogoDescription}: The description of the image that represents the site (2) for display in the front-end Web server as an ALT tag on the image.

@AllowMUI: A bit which indicates whether the Multilingual User Interface feature is enabled.

@TitleResource: The resource token or resource identifier of the title for the site (2) whose metadata is to be updated.

@DescriptionResource: The resource token or resource identifier of the description for the site (2) whose metadata is to be updated.

@AlternateMUICultures: The string that contains the distinct language identifier(s) for all the alternate language(s) of the site (2). For example, the language identifier for English is 1033. Every element is separated by semicolon from the next.

@OverwriteMUICultures: A bit which specifies whether the changes made to user-specified text in the default language automatically overwrite the existing translations made in all alternate languages.

@UIVersion: A number that represents the visual state of the site (2).

@ClientTag: A number that represents the state of the application files of the site (2).

AnonymousPermMask: A WSS Rights Mask that indicates the permissions granted to a user that is anonymous, or has no specific permissions, to this site (2). The value MUST be NULL for sites that do not exist.

{SiteFlags}: A Site Collection Flags value that indicates the settings for the site collection that contains this site (2).

{SitePortalURL}: The URL for a different site (2) registered on the site for use in navigation structures as a parent location.

{SitePortalName}: The display name of a different site (2) registered on the site for use in navigation structures as a parent location.

MeetingCount: If this site (2) is a meeting workspace (that is, its site template identifier in ProvisionConfig is set to 2), this value indicates the number of meetings that are configured.

DefTheme: The name of a theme that is used as part of the display of the site (2).

CachedNav: An implementation-specific serialization of navigation structure information to display in front-end Web server elements associated with this site (2).

CachedInheritedNav: This contains an implementation-specific serialization of navigation structure information to display in front-end Web server elements associated with the root navigation elements for this site (2).

CachedNavDirty: If this value is not set to "0", the cached navigation information for this site MUST be regenerated.

CachedDataVersion: A counter incremented on every change to the cached navigation information, used for internal conflict detection.

NavParentWebId: The Site Identifier of the site (2) to be treated as the parent of this site when displaying navigation elements in the front-end Web server.

FirstUniqueAncestorWebId: The Site Identifier of the closest site (2) in this site's ancestor chain that does not inherit security settings from its parent site.

ScopeId: The Scope Identifier of the security scope containing the site (2).

DbNow: The current time in UTC format on the back-end database server.

Acl: The binary serialization of the WSS ACL Format ACL for this site (2). This is either explicitly defined or inherited from the parent object of the site (2).

{RequestAccessEmail}: The e-mail address for a user who has the authority to grant access to the site (2), if any. This can be used by the front-end Web server to generate an e-mail to request access for a user who does not have access to the site (2).

Ancestry: An implementation-specific serialization of the navigation structure information for the site (2).

ProductVersion: The implementation-specific version identifier used to create the site (2).

tp_Id: The User Identifier of the current user.

tp_SiteAdmin: Set to "1" if the current user is an administrator of the site (2).

tp_IsActive: Set to "1" if the current user is an active user in the site collection containing this site (2).

tp_Login: The login information of the current user.

tp_Email: The e-mail address of the current user.

tp_Title: The display name of the current user.

tp_Notes: Notes about the current user.

tp_ExternalTokenLastUpdated: A time stamp in UTC format specifying the time when the External Group Token for the current user was last updated.

tp_Flags: A WSS User Flags value of the specified user

tp_Token: A WSS User Token value specifying the site group membership of the current user.

UserId: The site membership identifier of the current user. This is NULL if the current user has not been added to the set of members of this site (2).

{SiteSecurityVersion}: The current security information version of the site collection.

tp_Locale: An LCID referring to the locale value to be used when displaying messages in the front-end Web server for the current user. If this value is NULL, the site setting for Locale is used instead.

tp_TimeZone: The Time Zone Identifier for the time zone to be used when displaying time values for the current user. If this value is NULL, the site setting for TimeZone is used instead.

tp_Time24: A bit flag which specifies whether to use a 24-hour time format when displaying time values to the current user. If this parameter is set to "1", the 24-hour time format is be used; otherwise, the 12-hour time format is be used. If this value is NULL, the site setting for Time24 MUST be used instead.

tp_CalendarType: The Calendar Type to be used when processing date values for the current user. If this value is NULL, the site setting for CalendarType MUST be used instead.

tp_AdjustHijriDays: If the tp_CalendarType value is "6", this specifies the number of days to extend or reduce the current month in Hijri calendars for the current user. If this value is NULL, the site setting for AdjustHijriDays MUST be used instead.

tp_AltCalendarType: The Calendar Type of an alternate calendar to be used when displaying calendars in views for the current user. If this value is NULL, the site setting for AltCalendarType MUST be used instead.

tp_CalendarViewOptions: A Calendar View Options Type specifying the calendar options for the current user. If this value is NULL, the site setting for CalendarViewOptions MUST be used instead.

tp_WorkDays: A set of Workdays Flags specifying the weekdays defined as the workweek for the current user. If this value is NULL, the site setting for WorkDays MUST be used instead.

tp_WorkDayStartHour: The start time of the work day in minutes after midnight for the current user. If this value is NULL, the site setting for WorkDayStartHour MUST be used instead.

tp_WorkDayEndHour: The end time of the workday in minutes after midnight for the current user. If this value is NULL, the site setting for WorkDayEndHour MUST be used instead.

tp_MUILanguages: A string that contains the distinct culture(s) for the user's preferred display language(s), separated by semicolon. This string can be NULL.

tp_ContentLanguages: A string that contains the distinct culture(s) for the user's preferred content language(s), separated by semicolon. This string can be NULL.

{SiteHashKey}: Contains binary information used when generating digital signatures of information associated with this site collection.

{UserInfoListId}: The list identifier of the user information list for the site collection containing this site (2).

{RootWebId}: The site identifier for the root site of the site collection containing this site (2).

{SiteLastContentChange}: A time stamp in UTC format describing the time content was last changed within this site collection.

{SiteLastSecurityChange}: A time stamp in UTC format describing the time security settings were last changed within this site collection.

{RbsCollectionId}: The identifier for the remote BLOB storage collection for the site collection, or zero if remote BLOB storage is not configured for this database.

{DenyPermMask}: A WSS Rights Mask (section 2.2.2.15) specifying the rights to deny to the current user.

2.2.4.24 Site Metadata Result Set

Additional resources