The University of the West Indies (UWI), at Cave Hill, Barbados

The University of the West Indies

at Cave Hill, Barbados

Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
10 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
14 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
15 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
16 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
17 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
18 >>>> TypeInfo(cms.versionhistory).Events.GetData ApplicationModule.PostAcquireRequestState
19 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
21 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
22 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
23 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
24 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
25 TypeInfo(cms.document.slider.cameraitem).Events.GetData PageContext.CurrentPage_InitComplete
26 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
27 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
28 TypeInfo(cms.acl).Events.GetData CMSAbstractMenuProperties.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/FMS/outputdata/007B/1323522329.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/FMS_CSS Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/960_cave_footer.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/cave_footer.ascx.cs Local
5 EXISTS
~/CMSControls/fms/960_cave_header.ascx Local
6 EXISTS
~/CMSControls/fms/960_cave_header.ascx.cs Local
7 EXISTS
~/CMSWebParts/navigation/cmsbreadcrumbs.ascx Local
8 EXISTS
~/CMSWebParts/Navigation/cmsbreadcrumbs.ascx.cs Local
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
10 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
11 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
12 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 public FilterDataSetByPermissions DataSet: DataSet: Table (2 [37], 424 B) read FMS CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False CMSAbstractMenuProperties.OnLoad
IsGlobalAdministrator False
CheckPrivilegeLevel False GlobalAdmin CMSAbstractMenuProperties.OnLoad
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|fms|/for-students/current|en-gb|/for-students/current|true
template|235
nodeid|5547
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|fms|https://www.cavehill.uwi.edu/fms/for-students/current.aspx|en-gb||true|true
template|235
nodeid|5547
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 GET pageinfo|fms|/7301|en-gb||false PageContext.CurrentPage_InitComplete
5 GET pageinfo|fms|/|en-gb||false
6 GET siteresourcerolespermissions|51|cms.content CMSAbstractMenuProperties.OnLoad
7 ADD breadcrumbs|fms|/7301/5519|en-gb|false|cms.menuitem;cms.office||true|
node|fms|/7301/5519|childnodes
CMSAbstractMenuProperties.OnLoad
8 GET cmsmenudatasource||en-gb|fms|/%|en-gb|false|cms.menuitem|||2|true||false|false CMSListMenu.OnLoad
9 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /for-students/current.aspx 0.000
0.391
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.391
0.469
 
3 > OnPreInit 0.859
0.000
 
4 > OnInit 0.859
0.188
 
5 > OnLoad 1.047
0.391
 
6 > OnPreRender 1.438
N/A
    1.438  
Request cookies:
 NameValue
1 CMSPreferredCultureen-GB
2 CMSCsrfCookietOJdbDmGGeWD7FOxNAbiYe9nsrSv8UYanvIp5O31
3 ASP.NET_SessionIdardt3pkt3btlcixgmzlxhsxx
4 Campaign 
5 Source 
6 CMSCurrentThemeFMS_CSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-GB24/04/2020 10:38:27
2 CMSCsrfCookietOJdbDmGGeWD7FOxNAbiYe9nsrSv8UYanvIp5O31 
3 ASP.NET_SessionIdardt3pkt3btlcixgmzlxhsxx 
4 Campaign 24/04/2018 10:38:28
5 Source 24/04/2018 10:38:28
6 CMSCurrentThemeFMS_CSS25/04/2019 10:38:28
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.90.86.231
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDardt3pkt3btlcixgmzlxhsxx
8 ServerNameARES1_fms
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @DocumentUrlPath nvarchar(max) = N'/for-students/current';
DECLARE @NodeAliasPath nvarchar(max) = N'/for-students/current';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:38:27 AM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/for-students/current' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 2 kB)
 
ApplicationModule.PostResolveRequestCache 0.297
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/7301', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 2.1 kB)
 
ApplicationModule.PostResolveRequestCache 0.094
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @NodeGUID uniqueidentifier = 'dda3d08d-6efd-4c9c-a0da-3cd12f135fc0';
DECLARE @Now datetime2 = '4/24/2019 10:38:28 AM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
524 B
 
Table (1 [157], 2.4 kB)
 
ApplicationModule.PostAcquireRequestState 0.078
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 38106
Table (1 [23], 4.6 kB)
 
ApplicationModule.PostAcquireRequestState 0.234
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/7301/5519';
DECLARE @ABVariantSiteID int = 51;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.063
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 5519
PageContext.CurrentPage_InitComplete 0.078
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(slider.cameraitem.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @Now datetime2 = '4/24/2019 10:38:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/images/Rotator%';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN slider_cameraitem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.CameraitemID AND V.ClassName = N'slider.cameraitem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
768 B
 
Table (3 [166], 2.5 kB)
 
PageContext.CurrentPage_InitComplete 0.078
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
8
(cms.document.generalselect)
DECLARE @NodeSiteID int = 51;
DECLARE @Now datetime2 = '4/24/2019 10:38:28 AM';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings], [DocumentID]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/7301/5519', N'/7301', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'cms.office')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeAliasPath DESC
1.5 kB
 
Table (2 [37], 424 B)
 
CMSAbstractMenuProperties.OnLoad 0.141
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
9
(cms.acl.generalselect)
DECLARE @ACLID int = 57;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
Table (1 [5], 52 B)
 
CMSAbstractMenuProperties.OnLoad 0.063
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
10
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 51;
DECLARE @Date datetime2 = '4/24/2019 10:38:28 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (57)

1.3 kB
 
CMSAbstractMenuProperties.OnLoad 0.078
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
11
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 2214;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 51;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
CMSAbstractMenuProperties.OnLoad 0.078
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
  11 queries, 8.8 kB write, 14.1 kB read   1.281
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} The Faculty of Medical Sciences | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
> prefix The Faculty of Medical Sciences | The University of the West Indies at Cave Hill, Barbados 0.000
2 {% pagetitle_orelse_name %} Current 0.000
> pagetitle_orelse_name Current 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/fms/for-students/current.aspx" (30 B)
30 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
DropDownList1
No
No
AutoPostBack = True
Width = 119px
0 B
 
4 lt
cave_header1
ImageButton1
No
No
No
Height = 33px
ImageUrl = "http://www.cavehill.uwi.edu/images/search_go_cavehill_off.png" (61 B)
Width = 33px
61 B
 
5 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
6 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes