The DHS Program

    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    

		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=4470 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID
	

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ? 

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=4470 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

SELECT DISTINCT 
S.Survey_ID, 
PR.Prnt_Rgn_Name, 
PR.Prnt_Rgn_Order, 
P.Phase_Name,
RE.Phase_Name AS Phase_Name_Recode, 
S.Survey_Yr, 
S.Survey_Yr_Display, 
S.Data_Avail_Flag,
S.rpt_avail_date,
s.GPS_Stts_ID,
C.Ctry_Name, 
C.Ctry_ID, 
C.Ctry_Code, 
s.Survey_Type_Id,
T.Survey_Type_Lbl, 
T1.Survey_SubType_Desc,
St.Stts_Lbl, 
St.Stts_ID,
S.Survey_Start, 
S.Survey_End, 
S.Implementing, 
S.Notes, 
Facil_Samp_Size, 
House_Samp_Size,
Survey_Footnotes, 
D.Data_Avail_Flag_Desc,
gp.GPS_Stts_Lbl, 
s.HIV_Stts_ID, 
HIV_Stts_Lbl,
s.SPA_Stts_ID, 
spa.SPA_Stts_Lbl,

(SELECT distinct(max(e.Pub_Type_ID)) FROM pub_Catalog e where
e.Survey_ID = s.Survey_ID and (e.Pub_Type_ID IN (?,?,?,?,?)) 
and e.Stts_id=?) AS Finalreport ,

(SELECT U.Univ_Lbl FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND s.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'f') AS Univ_Lbl_F,


(SELECT Sr.Resp_Age_Min FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'f') AS Min_Age_F,

(SELECT Sr.Resp_Age_Max FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'f') AS Max_Age_F,

(SELECT Sr.Sample_Size FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'f') AS Sample_F,

(SELECT U.Univ_Lbl FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'm') AS Univ_Lbl_M,

(SELECT Sr.Resp_Age_Min FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'm') AS Min_Age_M,

(SELECT Sr.Resp_Age_Max FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'm') AS Max_Age_M,

(SELECT Sr.Sample_Size FROM Survey_Resp Sr INNER JOIN Univ U ON U.Univ_ID =
Sr.Univ_ID WHERE sr.survey_id = s.survey_id
AND S.Ctry_ID = C.Ctry_ID AND r.rgn_ID = C.Rgn_ID AND p.phase_id =
s.survey_phase_id AND u.univ_type = 'm') AS Sample_M

FROM Survey S
 INNER JOIN Phase P ON P.Phase_ID = S.Survey_Phase_ID
 INNER JOIN Phase RE ON RE.Phase_ID = S.Survey_Recode_ID
 INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
 INNER JOIN Rgn R ON R.Rgn_ID = C.Rgn_ID
 INNER JOIN Prnt_Rgn PR ON PR.Prnt_Rgn_ID = R.Prnt_Rgn_ID
 INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
 INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID   
 INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID
 INNER JOIN GPS_Stts gp ON gp.GPS_Stts_ID = s.GPS_Stts_ID 
 INNER JOIN HIV_Stts h ON h.HIV_Stts_ID = s.HIV_Stts_ID
 INNER JOIN SPA_Stts spa ON spa.SPA_Stts_ID = s.SPA_Stts_ID
 INNER JOIN Data_Avail_Flag D ON D.Data_Avail_Flag = S.Data_Avail_Flag
 
 	LEFT OUTER JOIN pub_catalog e ON e.Survey_ID = s.Survey_ID
 
 
WHERE 
 St.Stts_ID <> 1
 AND St.Stts_ID <> 4
 AND St.Stts_ID <> 6
 AND St.Stts_ID <> 7
 AND St.Stts_ID <> 99
 AND St.Stts_ID <> 0
 
 	
	AND (e.Print_Date > '2024-01-02' or Stts_Lbl = 'ongoing')	
 
 	ORDER BY  C.Ctry_Name, S.Survey_Yr DESC
 

SELECT * 
FROM mod_feat
WHERE Active_Flag = 1

ORDER BY mod_feat_type, mod_feat_name

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 569
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 584
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 562
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 563
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 597
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 559
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 588
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 546
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 598
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 565
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 599
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 605
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 596
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 566
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 573
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 564
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 585
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 575
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 609
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 603
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 607
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 611
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 608
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 578
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 610
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

  
	select max(pub_id) as pubid
	from pub_Catalog
	where survey_id = 556
	  and pub_type_id IN (5,21,26,30,39)
	  and stts_id IN (1,2,3) 
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	

					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 

sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Methodology\customcf\search\listmodules.cfm @ 01:31:47.047

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Methodology\survey-search.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Methodology/survey-search.cfm?SrvyTp=recent&pgtype=recent
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Methodology\survey-search.cfm
QUERY_STRING=SrvyTp=recent&pgtype=recent
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Methodology/survey-search.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CSRFTOKEN=FD46E881467E96A01DF25D9E2802543AA2774C50

Form Fields:
FIELDNAMES=
LISTVIEW=-1

Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=25
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=1452851200
cs_runningdashboardcmdcode=0
csrftoken=FD46E881467E96A01DF25D9E2802543AA2774C50
ctrl_data=Struct (70)
customcf_data=Struct (2)
customcfupfront=Query (1)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 01:31:46
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719970306843
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (6)
params_formfields=
params_urlfields=SrvyTp,pgtype
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 01:31:46.843
req_sequenceid=57229
req_startticks=1719970306843
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_D699B8A9ED09D0E20A8DA82250C61DC4.cfusion
sessionstring=1_D699B8A9ED09D0E20A8DA82250C61DC4.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=19
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-03 01:31:46'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=FD46E881467E96A01DF25D9E2802543AA2774C50
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=4470
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719970306843
listview=0
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=D699B8A9ED09D0E20A8DA82250C61DC4.cfusion
sessionstring=1_D699B8A9ED09D0E20A8DA82250C61DC4.cfusion
urltoken=CFID=2273485&CFTOKEN=3e9d4f216a2e5fa7-9E30A4B7-D8CE-8034-D686F20B2EA1F7FF&jsessionid=D699B8A9ED09D0E20A8DA82250C61DC4.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)

URL Parameters:
SrvyTp=recent
pgtype=recent