need help?

TruGreen wants to help you turn the lawn you have into the lawn you love. Please enter your information and a TruGreen representative will call you back to discuss your lawn concerns and help find a plan tailored to your needs.
By providing TruGreen with my cell phone number, I agree that TruGreen may contact me on that number using an automated telephone dialing system or prerecorded or artificial voice to discuss my account, including current and possible future services provided by TruGreen, customer service and billing. I understand that providing my cell phone number is not required to purchase TruGreen services and that I may revoke this permission at any time.

need immediate help?

Customer Service
Phone: 800.458.4186

Back to top
800-800-8008
Arrange a call back
700-700-7007
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
7 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
8 >> TypeInfo(cms.pagetemplate).Events.GetData SimpleHandler`2.StartEvent
9 >> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
10 >> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
11 >> TypeInfo(cms.workflowstep).Events.GetData SimpleHandler`2.StartEvent
12 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
13 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
14 >> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
15 >> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
16 >> TypeInfo(cms.workflow).Events.GetData SimpleHandler`2.StartEvent
17 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
18 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
19 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
20 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
>>> URLRewritingEvents.ProcessRewritingResult.Before
>>>> CustomApplicationEventsAttribute.ProcessRewritingResult_Before
21 >>>>> DocumentEvents.GetData SimpleHandler`2.StartEvent
22 >>>>>> TypeInfo(cms.document.tg.urlredirect).Events.GetData SimpleHandler`2.StartEvent
23 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
24 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
25 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
26 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> CustomApplicationEventsAttribute.SessionStart_Execute
27 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
28 >>> TypeInfo(cms.document.tg.product).Events.GetData ObjectQueryBase`2.GetEnumerator
29 >>>> TypeInfo(cms.versionhistory).Events.GetData ObjectQueryBase`2.GetEnumerator
30 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
31 >>> TypeInfo(cms.document.tg.servicetype).Events.GetData ObjectQueryBase`2.GetEnumerator
32 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
33 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
34 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
35 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
36 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
37 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
38 DocumentEvents.GetData TextLayout.CreateChildControls
39 TypeInfo(cms.document.cms.menuitem).Events.GetData TextLayout.CreateChildControls
40 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
41 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
42 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
43 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
44 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
45 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
46 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
47 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
48 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
49 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
50 TypeInfo(cms.document.tg.megamenuitem).Events.GetData ObjectQueryBase`2.GetEnumerator
51 >> TypeInfo(cms.versionhistory).Events.GetData ObjectQueryBase`2.GetEnumerator
52 DocumentEvents.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
53 TypeInfo(cms.document.tg.infographic).Events.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
54 >> TypeInfo(cms.versionhistory).Events.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
55 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
56 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
57 DocumentEvents.GetData BasicRepeater.OnLoad
58 TypeInfo(cms.document.cms.menuitem).Events.GetData BasicRepeater.OnLoad
59 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
60 TypeInfo(cms.transformation).Events.GetData
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
2 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
3 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
4 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 IsFeatureAvailable True WorkflowVersioning devkcms.trugreen.vanickurl.com SimpleHandler`2.StartEvent
2 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator PageContext.CurrentPage_InitComplete
3 ValidateHash True s=GetMyAccountFirstName(); if (s.Length > 0) { %} <li class="regular-mobile-menu"><a href="/manage-my-account">{%s%}'s Account</a> <ul class="sub-hide-mobile-menu"> <li class="sub-mobile-menu"><a href="/account/logout">Account Log Out</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account">Account Summary</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/transaction-history">Billing History</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/servce-history">Service Details</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/account-update">Update Account</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/faq">Questions</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">PrePay and Save</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/easypay-status">EasyPay Settings</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">Save money by paying up front for a full year</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">Sign Up for PrePay</a></li> </ul> </li> </li> {%} else { %} <a {% (IsBranchFranchise() =="true") ? "" : "href='/manage-my-account/login'" %}>Account Log In</a> {%} ron.cundiff PageContext.CurrentPage_InitComplete
4 ValidateHash True s=GetMyAccountFirstName(); if (s.Length > 0) { print(ResolveMacros("\r\n <li class=\"regular-mobile-menu\"><a href=\"/manage-my-account\">{%s%\}\'s Account</a>\r\n\t\t\t<ul class=\"sub-hide-mobile-menu\">\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/account/logout\">Account Log Out</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account\">Account Summary</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/transaction-history\">Billing History</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/servce-history\">Service Details</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/account-update\">Update Account</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/faq\">Questions</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">PrePay and Save</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/easypay-status\">EasyPay Settings</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Save money by paying up front for a full year</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Sign Up for PrePay</a></li> \r\n\t\t\t</ul>\r\n\t\t</li>\r\n </li>\r\n "))} else { print(ResolveMacros(" \r\n <a {% (IsBranchFranchise() ==\"true\") ? \"\" : \"href=\'/manage-my-account/login\'\" %\}>Account Log In</a> \r\n "))} ron.cundiff PageContext.CurrentPage_InitComplete
5 ValidateHash True FormatNotEmpty(GetUserZipCode(), "{0}", "Enter Zip") administrator PageContext.CurrentPage_InitComplete
6 ValidateHash True branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { %} <a href="{% branchUrl %}" id="LocalBranch">Your Local Branch</a> {% } ron.cundiff
7 ValidateHash True if (GetSessionVariable("sls-cobranding") != null) { "src='/TruGreen/media/images/tg-sls.png' class='sls-logo'" } else { "src='/TruGreen/media/images/header-logo.png'" } administrator
8 ValidateHash True if (CurrentDocument.TemplateSectionIdValue.Length > 0) { CurrentDocument.TemplateSectionIdValue; } else { CurrentDocument.DocumentName; } administrator TextLayout.CreateChildControls
9 ValidateHash True if (CurrentDocument.DocumentName.Contains("Lead Form") || CurrentDocument.GetValue("Model", "")=="LocalLawnCare") {return false;} else {return true;} administrator CMSAbstractWebPart.OnInit
10 ValidateHash True if (CurrentDocument.GetValue("Model", "")=="LocalLawnCare") {return true;} else {return false;} administrator
11 ValidateHash True if (NodeAliasPath.Contains("/local-lawn-care") && QueryString.city != "") { return true; } else { return false; }administrator CMSAbstractWebPart.OnInit
12 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.GetValue("Model","") == "LocalLawnCare") {return true;} else {return false;} administrator CMSAbstractWebPart.OnInit
13 This same security check is called more than once within the request. ValidateHash True if(NodeAliasPath.Contains("/products-and-services")) { return true; } else { return false; } administrator
14 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.GetValue("Model","") == "LocalLawnCare") {return true;} else {return false;} administrator
15 ValidateHash True if (CurrentDocument.DocumentName.Contains("Lead Form") || CurrentDocument.NodeAliasPath.Contains("/need-help")) {return true;} else {return false;} administrator
16 ValidateHash True if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true;} else {return false;} administrator
17 ValidateHash True if (CurrentDocument.DocumentName.Contains("Error")) {return true;} else {return false;} administrator
18 ValidateHash True if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else { return false; } administrator CMSAbstractWebPart.OnInit
19 ValidateHash True if (CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else {return false;} administrator
20 ValidateHash True if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else {return false;} administrator CMSAbstractWebPart.OnInit
21 ValidateHash True if (CurrentDocument.GetValue("Model", "")=="LocalLawnCare" ) {return true;} else {return false;} administrator
22 ValidateHash True if (CurrentDocument.DocumentName.Contains("Lawn Plans for Fertilizaton")) {return true;} else {return false;} administrator
23 ValidateHash True if (CurrentDocument.DocumentName.Contains("trugreen-qlp")) {return true;} else {return false;} administrator
24 This same security check is called more than once within the request. ValidateHash True if(NodeAliasPath.Contains("/products-and-services")) { return true; } else { return false; } administrator
25 ValidateHash True RenderView("~/Views/TruGreen/Shared/_StylesCombined.cshtml")ron.cundiff DocumentBase.Load
26 ValidateHash True RenderView("~/Views/TruGreen/Shared/_ScriptsCombined.cshtml")ron.cundiff
27 ValidateHash True if(CurrentDocument.DocumentName == "Homepage") { @"<meta name=""google-site-verification"" content=""xroegriqTZDld_HsGJXi42RWPgAN9qWGJAtJA2PXd_w"" />" administrator
28 ValidateHash True if (CurrentDocument.BodyIdValue.Length > 0) { CurrentDocument.BodyIdValue; } else { CurrentDocument.DocumentName; } ron.cundiff
29 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
30 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
31 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator CMSWebParts_General_javascript.OnPreRender
32 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator
33 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator
34 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
35 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
36 This same security check is called more than once within the request. ValidateHash True if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";}administrator
37 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
38 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
39 This same security check is called more than once within the request. ValidateHash True if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";}administrator
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|trugreen|/need-help|en-us|/need-help|true
template|24152
nodeid|2480
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|trugreen|http://devkcms.trugreen.vanickurl.com/need-help|en-us||true|true
template|24152
nodeid|2480
pageinfo
SimpleHandler`2.StartEvent
3 GET pageinfo|trugreen|/|en-us||false PageContext.CurrentPage_InitComplete
4 ADD currentdocument|trugreen|/need-help|en-us
nodes|trugreen|cms.menuitem|all
node|trugreen|/need-help
TextLayout.CreateChildControls
5 ADD breadcrumbs|trugreen|/need-help|en-us|false|||true|
webpartinstance|e86c5e78-25ed-4743-a8db-0b75064edb46
node|trugreen|/need-help|childnodes
CMSAbstractMenuProperties.OnLoad
6 ADD cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|c182c97b-26f8-49e1-a3e3-e7a9d9516e4f
nodes|trugreen|cms.menuitem|all
node|trugreen|/need-help
BasicRepeater.OnLoad
7 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| BasicRepeater.OnLoad
8 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
9 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
10 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
11 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
12 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
13 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
14 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
15 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
16 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
17 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
18 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
19 GET cmsdatasource||en-us|trugreen|/need-help|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
20 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /need-help 0.000
0.058
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.058
21.317
 
3 > OnPreInit 21.375
0.001
 
4 > OnInit 21.376
0.139
 
5 > OnLoad 21.515
0.276
 
6 > OnPreRender 21.791
N/A
    21.791  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieuZWFL54UXOktHt+7wFgeKM1ngAwc5hWsqdGGRNBg
3 ASP.NET_SessionIdhq4iookv0xe4qrvf5mlend3b
4 persistlastVisit=3/19/2019 4:42:18 AM&cookieId=a17bf4a6-0809-4f00-b07d-d88cc07510e6
5 __RequestVerificationTokenYD3HzCcjTBqoPwxbtZcWdUCK_gKDmOzx0hZ4aZJw7nxVWQD3-KIlRumUZXNjtiKImG4xe032wRuwrzDPCgNCrMbf6tYokjw6BCiUaCVbL-s1
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US3/19/2020 4:42:18 AM
2 CMSCsrfCookieuZWFL54UXOktHt+7wFgeKM1ngAwc5hWsqdGGRNBg 
3 ASP.NET_SessionIdhq4iookv0xe4qrvf5mlend3b 
4 persistlastVisit=3/19/2019 4:42:18 AM&cookieId=a17bf4a6-0809-4f00-b07d-d88cc07510e64/18/2019 4:42:18 AM
5 __RequestVerificationTokenYD3HzCcjTBqoPwxbtZcWdUCK_gKDmOzx0hZ4aZJw7nxVWQD3-KIlRumUZXNjtiKImG4xe032wRuwrzDPCgNCrMbf6tYokjw6BCiUaCVbL-s1 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.243.17.113
5 UserName 
6 SessionIDhq4iookv0xe4qrvf5mlend3b
7 ServerNameTG01CMSIIS2
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/need-help';
DECLARE @NodeAliasPath nvarchar(max) = N'/need-help';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '3/19/2019 4:42:18 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-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/need-help' 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], 368 B)
 
SimpleHandler`2.StartEvent 0.017
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-us';

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 = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [157], 2.1 kB)
 
SimpleHandler`2.StartEvent 0.004
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 24152;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 127 kB)
 
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
4
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 4.2 kB)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
5
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 12.8 kB)
 
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
6

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_WorkflowStep');
Table (1 [1], 6 B)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
7
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 172)
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
8
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 172)
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
9
(cms.workflowstep.generalselect)
DECLARE @StepID int = 2;

SELECT *
FROM CMS_WorkflowStep
WHERE [StepID] = @StepID
Table (1 [23], 469 B)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Workflow';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 4.8 kB)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
11
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Workflow';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 16.4 kB)
 
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
12

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Workflow');
Table (1 [1], 10 B)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
13
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 171)
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
14
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 171)
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
15
(cms.workflow.generalselect)
DECLARE @WorkflowID int = 1;

SELECT *
FROM CMS_Workflow
WHERE [WorkflowID] = @WorkflowID
Table (1 [23], 95 B)
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
16
(tg.urlredirect.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @IsActive bit = 1;
DECLARE @Request nvarchar(max) = N'/need-help';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_UrlRedirect AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.UrlRedirectID AND V.ClassName = N'TG.UrlRedirect' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [IsActive] = @IsActive AND [Request] = @Request AND [DocumentCulture] = @DocumentCulture
548 B
 
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
17
(tg.product.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_Product AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ProductID AND V.ClassName = N'TG.Product' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (174 [177], 415 kB)
 
ObjectQueryBase`2.GetEnumerator 0.013
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
18
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 1448
Table (1 [23], 7.3 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
19
(tg.servicetype.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_ServiceType AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ServiceTypeID AND V.ClassName = N'TG.ServiceType' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (23 [169], 27 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
TextLayout.CreateChildControls N/A
20
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-us';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MenuItemID AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE (NodeID = 2480) AND [DocumentCulture] = @DocumentCulture
Table (1 [353], 1.8 kB)
 
TextLayout.CreateChildControls 0.002
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
21
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 2468
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
22 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.062
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
23 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
24 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
25 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
26
(tg.megamenuitem.generalselect)
DECLARE @NodeSiteID int = 1;

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuItemID AND V.ClassName = N'TG.MegaMenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID
ORDER BY [SortOrder]
Table (10 [162], 8.5 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
27
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 2966
Table (1 [23], 2.7 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
28
(tg.infographic.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @p int = 1;

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_Infographic AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.InfographicID AND V.ClassName = N'TG.Infographic' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID) AND (([Featured] = @p))
ORDER BY [SORTORDER] DESC
Table (1 [172], 2.2 kB)
 
_Page_Views_TruGreen_Megamenu_cshtml.Execute 0.002
 
CloseConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
OpenConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
29
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 333
Table (1 [23], 3.9 kB)
 
_Page_Views_TruGreen_Megamenu_cshtml.Execute 0.001
 
CloseConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
30
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:42:40 AM';
DECLARE @NodeLevel int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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]
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'/need-help', N'/')) 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.4 kB
 
Table (2 [36], 298 B)
 
CMSAbstractMenuProperties.OnLoad 0.003
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
31
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:42:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/need-help';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MenuItemID AND V.ClassName = N'CMS.MenuItem' 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] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
729 B
 
Table (1 [353], 1.8 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
32
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGC-Default-with-no-Subhead_en-US')
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
33
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGJ-Article-Only_en-US')
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
  33 queries, 12.6 kB write, 651 kB read   0.140
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% CurrentDateTime.Year %} 2019 administrator PageContext.CurrentPage_InitComplete 0.001
 
> CurrentDateTime.Year 2019 0.000
 
>> CurrentDateTime 3/19/2019 4:42:40 AM 0.000
 
2 {% s=GetMyAccountFirstName(); if (s.Length > 0) { print(ResolveMacros(" <li class=\"regular-mobile-menu\"><a href=\"/manage-my-account\">{%s%}\'s Account</a> \t\t\t<ul class=\"sub-hide-mobile-menu\"> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/account/logout\">Account Log Out</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account\">Account Summary</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/transaction-history\">Billing History</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/servce-history\">Service Details</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/account-update\">Update Account</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/faq\">Questions</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">PrePay and Save</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/easypay-status\">EasyPay Settings</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Save money by paying up front for a full year</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Sign Up for PrePay</a></li> \t\t\t</ul> \t\t</li> </li> "))} else { print(ResolveMacros(" <a {% (IsBranchFranchise() ==\"true\") ? \"\" : \"href=\'/manage-my-account/login\'\" %}>Account Log In</a> "))} %} <a href='/manage-my-account/login'>Account Log In</a> ron.cundiff PageContext.CurrentPage_InitComplete 0.002
 
> s = GetMyAccountFirstName(); if (s.Length > 0) { ... } else { ... } <a href='/manage-my-account/login'>Account Log In</a> 0.001
 
> s.Length 0 0.000
 
>> s 0.000
 
> {% (IsBranchFranchise() =="true") ? "" : "href='/manage-my-account/login'" %} href='/manage-my-account/login' 0.000
 
3 {% GetServiceNumber() %} 800.458.4186 PageContext.CurrentPage_InitComplete 0.001
 
4 {% FormatNotEmpty(GetUserZipCode(), "{0}", "Enter Zip") %} Enter Zip administrator PageContext.CurrentPage_InitComplete 0.000
 
5 {% branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { print(ResolveMacros(" <a href=\"{% branchUrl %}\" id=\"LocalBranch\">Your Local Branch</a> ")) } %} null ron.cundiff 0.005
 
> branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { ... } null 0.005
 
> branchUrl.Length 0 0.005
 
>> branchUrl 0.005
 
6 {% if (GetSessionVariable("sls-cobranding") != null) { "src='/TruGreen/media/images/tg-sls.png' class='sls-logo'" } else { "src='/TruGreen/media/images/header-logo.png'" } %} src='/TruGreen/media/images/header-logo.png' administrator 0.001
 
> if (GetSessionVariable("sls-cobranding") != null) { ... } else { ... } src='/TruGreen/media/images/header-logo.png' 0.001
 
7 {% if (CurrentDocument.TemplateSectionIdValue.Length > 0) { CurrentDocument.TemplateSectionIdValue; } else { CurrentDocument.DocumentName; } %} PurchaseCustom administrator TextLayout.CreateChildControls 0.007
 
> if (CurrentDocument.TemplateSectionIdValue.Length > 0) { ... } else { ... } PurchaseCustom 0.007
 
> CurrentDocument.TemplateSectionIdValue.Length 14 0.006
 
>> CurrentDocument.TemplateSectionIdValue PurchaseCustom 0.006
 
>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.006
 
>>>> CurrentDocument.TemplateSectionIdValue PurchaseCustom 0.007
 
> CurrentDocument.TemplateSectionIdValue PurchaseCustom 0.007
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.007
 
8 {% if (CurrentDocument.DocumentName.Contains("Lead Form") || CurrentDocument.GetValue("Model", "")=="LocalLawnCare") {return false;} else {return true;} %} True administrator CMSAbstractWebPart.OnInit 0.005
 
> if (Contains(CurrentDocument.DocumentName, "Lead Form") || CurrentDocument.GetValue("Model", "") == "LocalLawnCare") { ... } else { ... } True 0.004
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return true True 0.004
 
return true True 0.000
 
9 {% if (CurrentDocument.GetValue("Model", "")=="LocalLawnCare") {return true;} else {return false;} %} False administrator 0.001
 
> if (CurrentDocument.GetValue("Model", "") == "LocalLawnCare") { ... } else { ... } False 0.001
 
> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
10 {% if (NodeAliasPath.Contains("/local-lawn-care") && QueryString.city != "") { return true; } else { return false; } %} False administrator CMSAbstractWebPart.OnInit 0.002
 
> if (NodeAliasPath.Contains("/local-lawn-care") && QueryString.city != "") { ... } else { ... } False 0.001
 
> NodeAliasPath /need-help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
11 {% if (CurrentDocument.GetValue("Model","") == "LocalLawnCare") {return true;} else {return false;} %} False administrator CMSAbstractWebPart.OnInit 0.001
 
> if (CurrentDocument.GetValue("Model", "") == "LocalLawnCare") { ... } else { ... } False 0.001
 
> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
12 {% if(NodeAliasPath.Contains("/products-and-services")) { return true; } else { return false; } %} False administrator 0.001
 
> if (NodeAliasPath.Contains("/products-and-services")) { ... } else { ... } False 0.001
 
> NodeAliasPath /need-help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
13 {% if (CurrentDocument.GetValue("Model","") == "LocalLawnCare") {return true;} else {return false;} %} False administrator 0.001
 
> if (CurrentDocument.GetValue("Model", "") == "LocalLawnCare") { ... } else { ... } False 0.001
 
> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
14 {% if (CurrentDocument.DocumentName.Contains("Lead Form") || CurrentDocument.NodeAliasPath.Contains("/need-help")) {return true;} else {return false;} %} True administrator 0.002
 
> if (Contains(CurrentDocument.DocumentName, "Lead Form") || Contains(CurrentDocument.NodeAliasPath, "/need-help")) { ... } else { ... } True 0.001
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
> CurrentDocument.NodeAliasPath /need-help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>> return true True 0.001
 
return true True 0.000
 
15 {% if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true;} else {return false;} %} False administrator 0.001
 
> if (Contains(CurrentDocument.DocumentName, "TruGreen Customer Support")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
16 {% if (CurrentDocument.DocumentName.Contains("Error")) {return true;} else {return false;} %} False administrator 0.002
 
> if (Contains(CurrentDocument.DocumentName, "Error")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
17 {% if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else { return false; } %} False administrator CMSAbstractWebPart.OnInit 0.001
 
> if (Contains(CurrentDocument.DocumentName, "TruGreen Customer Support")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
18 {% if (CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else {return false;} %} False administrator 0.002
 
> if (Contains(CurrentDocument.DocumentName, "TruGreen Customer Support")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
19 {% if ( CurrentDocument.DocumentName.Contains("TruGreen Customer Support")) { return true; } else {return false;} %} False administrator CMSAbstractWebPart.OnInit 0.001
 
> if (Contains(CurrentDocument.DocumentName, "TruGreen Customer Support")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
20 {% if (CurrentDocument.GetValue("Model", "")=="LocalLawnCare" ) {return true;} else {return false;} %} False administrator 0.002
 
> if (CurrentDocument.GetValue("Model", "") == "LocalLawnCare") { ... } else { ... } False 0.001
 
> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
21 {% if (CurrentDocument.DocumentName.Contains("Lawn Plans for Fertilizaton")) {return true;} else {return false;} %} False administrator 0.001
 
> if (Contains(CurrentDocument.DocumentName, "Lawn Plans for Fertilizaton")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
22 {% if (CurrentDocument.DocumentName.Contains("trugreen-qlp")) {return true;} else {return false;} %} False administrator 0.002
 
> if (Contains(CurrentDocument.DocumentName, "trugreen-qlp")) { ... } else { ... } False 0.001
 
> CurrentDocument.DocumentName Need Help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> return false False 0.001
 
return false False 0.000
 
23 {% if(NodeAliasPath.Contains("/products-and-services")) { return true; } else { return false; } %} False administrator 0.001
 
> if (NodeAliasPath.Contains("/products-and-services")) { ... } else { ... } False 0.001
 
> NodeAliasPath /need-help 0.001
 
>>>>> return false False 0.001
 
return false False 0.000
 
24 {% TGDRepeaterTransformationName %} null PageContext.CurrentPage_InitComplete 0.000
 
> TGDRepeaterTransformationName null 0.000
 
25 {% TGERepeaterTransformationName %} null 0.000
 
> TGERepeaterTransformationName null 0.000
 
26 {% TGCRepeaterTransformationName %} CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead 0.001
 
> TGCRepeaterTransformationName CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead 0.001
 
27 {% TGRRepeaterTransformationName %} null 0.064
 
> TGRRepeaterTransformationName null 0.064
 
28 {% TGSRepeaterTransformationName %} null 0.001
 
> TGSRepeaterTransformationName null 0.000
 
29 {% TGNRepeaterTransformationName %} null 0.001
 
> TGNRepeaterTransformationName null 0.000
 
30 {% TGORepeaterTransformationName %} null 0.001
 
> TGORepeaterTransformationName null 0.001
 
31 {% TGLRepeaterTransformationName %} null 0.000
 
> TGLRepeaterTransformationName null 0.000
 
32 {% TGJRepeaterTransformationName %} CMS.MenuItem.TGRES-TGJ-Article-Only 0.000
 
> TGJRepeaterTransformationName CMS.MenuItem.TGRES-TGJ-Article-Only 0.000
 
33 {% TGKRepeaterTransformationName %} null 0.001
 
> TGKRepeaterTransformationName null 0.001
 
34 {% TGHRepeaterTransformationName %} null 0.000
 
> TGHRepeaterTransformationName null 0.000
 
35 {% TGIRepeaterTransformationName %} null 0.000
 
> TGIRepeaterTransformationName null 0.000
 
36 {% TGFRepeaterTransformationName %} null 0.001
 
> TGFRepeaterTransformationName null 0.000
 
37 {% TGGRepeaterTransformationName %} null 0.001
 
> TGGRepeaterTransformationName null 0.001
 
38 {% RenderView("~/Views/TruGreen/Shared/_StylesCombined.cshtml") %}
<link href="/css/TruGreen/normalize.css" rel="stylesheet"/> <link href="/css/TruGreen/jquery-ui....
ron.cundiff DocumentBase.Load 0.000
 
39 {% RenderView("~/Views/TruGreen/Shared/_ScriptsCombined.cshtml") %}
<script src="/js/TruGreen/jquery.js"></script> <script src="/js/TruGreen/jquery-ui-1.10.1.custom...
ron.cundiff 0.001
 
40 {% if(CurrentDocument.DocumentName == "Homepage") { @"<meta name=""google-site-verification"" content=""xroegriqTZDld_HsGJXi42RWPgAN9qWGJAtJA2PXd_w"" />" %} null administrator 0.001
 
> CurrentDocument.DocumentName Need Help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
41 {% if (CurrentDocument.BodyIdValue.Length > 0) { CurrentDocument.BodyIdValue; } else { CurrentDocument.DocumentName; } %} Need Help ron.cundiff 0.001
 
> if (CurrentDocument.BodyIdValue.Length > 0) { ... } else { ... } Need Help 0.001
 
> CurrentDocument.BodyIdValue.Length null 0.000
 
>> CurrentDocument.BodyIdValue null 0.000
 
>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
> CurrentDocument.BodyIdValue.Length null 0.001
 
>> CurrentDocument.BodyIdValue null 0.001
 
>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> CurrentDocument.DocumentName Need Help 0.001
 
> CurrentDocument.DocumentName Need Help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
42 {% pagetitle_orelse_name %} Need Help DocumentBase.Load 0.001
 
> pagetitle_orelse_name Need Help 0.000
 
43 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
44 {% GetSalesNumber() %} 800.464.0171 0.000
 
45 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
46 {% GetSalesNumber() %} 800.464.0171 0.001
 
47 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
48 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
49 {% CurrentDateTime.Year %} 2019 administrator CMSPagePlaceholder.LoadRegionsContent 0.001
 
> CurrentDateTime.Year 2019 0.000
 
>> CurrentDateTime 3/19/2019 4:42:40 AM 0.000
 
50 {% CurrentDateTime.Year %} 2019 administrator CMSPagePlaceholder.LoadRegionsContent 0.001
 
> CurrentDateTime.Year 2019 0.001
 
>> CurrentDateTime 3/19/2019 4:42:40 AM 0.001
 
51 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
52 {% GetSalesNumber() %} 800.464.0171 0.000
 
53 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
54 {% GetSalesNumber() %} 800.464.0171 0.000
 
55 {% GetServiceNumber() %} 800.458.4186 CMSPagePlaceholder.LoadRegionsContent 0.001
 
56 {% GetServiceNumber() %} 800.458.4186 0.000
 
57 {% GetServiceNumber() %} 800.458.4186 CMSPagePlaceholder.LoadRegionsContent 0.000
 
58 {% GetServiceNumber() %} 800.458.4186 0.000
 
59 CurrentPath /need-help BasicRepeater.OnLoad 0.000
 
60 CurrentPath /need-help BasicRepeater.OnLoad 0.000
 
61 {% TGCHeadline %} need help? TextTransformationTemplate.ltl_DataBinding 0.001
 
> TGCHeadline need help? 0.001
 
62 CurrentPath /need-help BasicRepeater.OnLoad 0.001
 
63 CurrentPath /need-help 0.000
 
64 CurrentPath /need-help 0.000
 
65 CurrentPath /need-help 0.000
 
66 CurrentPath /need-help 0.000
 
67 CurrentPath /need-help 0.001
 
68 CurrentPath /need-help 0.000
 
69 CurrentPath /need-help 0.000
 
70 CurrentPath /need-help 0.001
 
71 {% TGJArticle %}
<section class="immediate-help"> <h2>need immediate help?</h2> <p><strong>Customer Service</s...
TextTransformationTemplate.ltl_DataBinding 0.000
 
> TGJArticle
<section class="immediate-help"> <h2>need immediate help?</h2> <p><strong>Customer Service</s...
0.000
 
72 CurrentPath /need-help BasicRepeater.OnLoad 0.000
 
73 CurrentPath /need-help 0.000
 
74 CurrentPath /need-help 0.001
 
75 CurrentPath /need-help 0.000
 
76 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator CMSWebParts_General_javascript.OnPreRender 0.001
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/need-help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
77 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
78 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator 0.001
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/need-help 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
79 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
80 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator 0.001
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/need-help 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.001
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
81 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
82 {% IsBranchFranchise() %} false 0.001
 
83 {% IsServiceable() %} false 0.000
 
84 {% CustomerHasAddress() %} false 0.000
 
85 {% GetUserZipCode() %} 0.000
 
86 {% GetUserZipOrigin() %} 0 0.000
 
87 N/A
> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
> {% IsBranchFranchise() %} false 0.000
 
> {% IsServiceable() %} false 0.000
 
> {% CustomerHasAddress() %} false 0.000
 
> {% GetUserZipCode() %} 0.000
 
> {% GetUserZipOrigin() %} 0 0.001
 
88 N/A
>> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
>> {% IsBranchFranchise() %} false 0.000
 
>> {% IsServiceable() %} false 0.001
 
>> {% CustomerHasAddress() %} false 0.000
 
>> {% GetUserZipCode() %} 0.000
 
>> {% GetUserZipOrigin() %} 0 0.000
 
89 N/A
>>> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
>>> {% CurrentDocument.DocumentName %} Need Help administrator 0.000
 
>>>> CurrentDocument.DocumentName Need Help 0.000
 
>>>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>> {% QueryString["q"] %} null administrator 0.001
 
>>>> QueryString aliaspath=%2fneed-help 0.000
 
>>> {% getgaValue("imp_ids",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_names",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_lists",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_brands",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("imp_categories",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_variants",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("imp_positions",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_prices",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_ids",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_names",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_categories",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_variants",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("product_quantities",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_positions",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("action_type",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("action_revenue",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_tax",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_coupon",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_step",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_cust_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_city",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_country",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_state",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("order_price",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";} %} "" administrator 0.001
 
>>>> if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { ... } else { ... } "" 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>>>>>>> return "\"\"" "" 0.001
 
>>>> return "\"\"" "" 0.000
 
>>> {% GetApplicationSetting("tealium_env") %} dev 0.000
 
>>> {% CurrentDocument.DocumentName %} Need Help administrator 0.001
 
>>>> CurrentDocument.DocumentName Need Help 0.000
 
>>>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Need Help 0.000
 
>>> {% QueryString["q"] %} null administrator 0.000
 
>>>> QueryString aliaspath=%2fneed-help 0.000
 
>>> {% getgaValue("imp_ids",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_names",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_lists",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_brands",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_categories",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_variants",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("imp_positions",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("imp_prices",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_ids",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("product_names",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_categories",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("product_variants",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("product_quantities",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("product_positions",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_type",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_revenue",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_tax",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("action_coupon",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("action_step",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("order_cust_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_city",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>> {% getgaValue("order_country",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_state",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% getgaValue("order_price",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /need-help 0.000
 
>>> {% if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";} %} "" administrator 0.001
 
>>>> if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { ... } else { ... } "" 0.001
 
>>>> NodeAliasPath /need-help 0.001
 
>>>>>>>> return "\"\"" "" 0.001
 
>>>> return "\"\"" "" 0.000
 
>>> {% GetApplicationSetting("tealium_env") %} dev 0.000
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/need-help" (10 B)
10 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 PrimaryNav
ViewRenderer
ViewResult
Yes
Text = "
<nav id="primaryNav">
<ul>
<li style='text-align:-webkit-right'><a href="/"><section class='home-icon-menu'></section></a></li>
<li data-hover="plans"><a href="/products-and-services" >Plans & Services</a></li>
<li data-hover="whytrugreen"><a href="/why-choose-trugreen" >Why TruGreen</a></li>
<li data-hover="trupurpose"><a href="/trupurpose" >TruPurpose</a></li>
<li data-hover="learningcenter"><a href="/learning-center" >Learning Cen..." (16 kB)
16 kB
 
4 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
5 TGB
PopularPlansHoriz
ViewResult
Yes
Text = "

<i class="ico-white-tree"></i>
<h3>popular services in <a class="zip">edit</a></h3>
<section class="service-title">TruComplete<span class="service-mark">SM</span> Lawn Plan</section>
<section class="service-bullet">Pre-Emergent & Targeted Weed Control •
Fertilization •
Aeration •
Lime Soil Amendment
</section>
<a href="/products-and-services/trucomplete/" class="btn-orange btn-go">learn more</a>
<section..." (527 B)
527 B
 
6 TGC
TGCRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead" (46 B)
HideControlForZeroRows = True
59 B
 
7 TGC
ViewModelViewPickerPlaceholderC
ViewResult
Yes
Text = "" (0 B)
0 B
 
8 TGD
TGDRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
9 TGE
TGERepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
10 TGF
TGFRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
11 TGG
TGGRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
12 TGH
TGHRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
13 TGH
LeadForm
ViewResult
Yes
Text = "
<div id="frmAddress">

<input name="__RequestVerificationToken" type="hidden" value="dPzU3KYd0B7kQt_3WJDpcB9c78FrZR7BmoCGsprAS73Kh4324MGJeHL8yBe_pMHDiHv7dhphJq9ZUa-9M0TIrz-elYdQfQUrRVEYjlv589Q1" />




<input type="hidden" id="LeadFormCity" />
<input type="hidden" id="NewState" />
<input type="hidden" id="Branch" />
<input type="hidden" id="Region" />

<section class="middle">
<section class="row-fluid div-form">
..." (9.2 kB)
9.2 kB
 
14 TGI
TGIRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
15 TGO
TGORepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
16 TGR
TGRRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
17 TGJ
TGJRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "CMS.MenuItem.TGRES-TGJ-Article-Only" (35 B)
HideControlForZeroRows = True
48 B
 
18 TGJ
ViewModelViewPickerScriptBottom
ViewResult
Yes
Text = "<script type="text/javascript" src="/js/TruGreen/jquery.vmap.min.js"></script>
<script type="text/javascript" src="/js/TruGreen/jquery.vmap.usa.js"></script>
<script type="text/javascript"
src="https://maps.googleapis.com/maps/api/js?key=AIzaSyAKshgdlhz_aB7jqi5jQ7o2kBfS-tIppjE&sensor=false">
</script>
<script type="text/javascript">
var serviceablestates = new Array();
var branchaddresses = new Array();
var selectedbranchaddress = new Array();
var zipcodesLocation..." (5.8 kB)
5.8 kB
 
19 TGK
TGKRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
20 TGL
TGLRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
21 TGS
TGSRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
22 TGN
TGNRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
23 GetACallBack
GetACallBackView
ViewResult
Yes
Text = "



<section class="header">
How can we help?
</section>

<section class="tab">
<span class="heading" style="margin-right: -4px; background-position: 85%;" name="NewServices"><a href="#">Buy By Phone</a></span>
<span class="heading selected" style="border-left: 1px solid #BFC0C0; " name="CurrentServices"><a href="#">Get Service Help</a></span>

<section class="tabcontent" id="NewServices">
<table class="choice new">
<tr>
..." (5.5 kB)
5.5 kB
 
24 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes