Software Education Services

United States
Home > Training > Courses Schedule
Home
Training
 - Training by Product
 - Training by Location
 - Training by Type
 - Onsite Training
Certification
 - ASE Program
 - ASE Exams
 - Exam Policy
Other
 - Online Store
 - Collateral & Resources
 - Contact
 - Training Unit Usage
HP Global Support
Find out how to utilize Software Support Online
 - SSO Online Tutorial
 - Customer Support Handbook

Login


*Virtual Western US Central US Southeast US Northeast US Canada Latin Am. all
 

No classes found
The course you have selected is currently not scheduled
in the region you have selected.

You can visit the Onsite Training page to find more information
on this course. Please click the link below to go to the Onsite
Training Page

Onsite Training Information


 


Debugging Information
ColdFusion Server Standard 8,0,1,195765
Template /main/schedule/course_schedule.cfm
Time Stamp 19-Apr-14 04:25 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 15.192.1.43
Host Name 15.192.1.43


Execution Time

Total Time Avg Time Count Template
125 ms 125 ms 1 top level E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm
16 ms 16 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_menu_bar.cfm
16 ms 16 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_page_start.cfm
16 ms 16 ms 1 E:\CommonApps\PRODUCTION\MAIN\schedule\Application.cfm
16 ms 16 ms 1 E:\CommonApps\PRODUCTION\MAIN\security_check.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\US\application.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\app_config.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\app_init.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_page_end.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_site_footer.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_site_header.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include-en\resources\_translations.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include\_admin_menu_bar.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include\_country_menu.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include\_func_library.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include\_keepalive_iframe.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\include\_login.cfm
0 ms 0 ms 2 E:\CommonApps\PRODUCTION\MAIN\include\menu\_menu_end.cfm
0 ms 0 ms 18 E:\CommonApps\PRODUCTION\MAIN\include\menu\_menu_item.cfm
0 ms 0 ms 2 E:\CommonApps\PRODUCTION\MAIN\include\menu\_menu_start.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\schedule\include\_calendar_courselist.cfm
0 ms 0 ms 1 E:\CommonApps\PRODUCTION\MAIN\schedule\include\_calendar_virtualcourselist.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
141 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

rs_wsite (Datasource=merctraindsn, Time=0ms, Records=1) in E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm @ 04:25:03.003
	SELECT	*
	FROM	tbl_websites
	WHERE	wsite_short='US'
rs_regions (Datasource=merctraindsn, Time=15ms, Records=56) in E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm @ 04:25:03.003
	SELECT	*
	
    FROM	
        tbl_websites RIGHT OUTER JOIN
        tbl_training_facilities ON wsite_id = fac_wsite LEFT OUTER JOIN
        tbl_training_facility_regions ON fac_region = fac_reg_id
	WHERE	fac_active= 1 AND fac_resource <> 1
			AND fac_reg_regions LIKE 'AMERICAS%'
			AND NOT (fac_mercury= 0 AND fac_order_mercury= 1)
	ORDER BY fac_reg_order, fac_state, fac_zip, fac_adr1
rs_events (Datasource=merctraindsn, Time=47ms, Records=0) in E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm @ 04:25:03.003
	SELECT	*
	FROM	qry_training_calendar_with_courses
	WHERE	fac_active= 1 AND fac_resource <> 1
			AND NOT (fac_mercury= 0 AND fac_order_mercury= 1)
			
				AND fac_reg_regions LIKE 'AMERICAS%'
				
			AND event_startdate + event_length > {d '2014-04-19'}
			AND cat_screentype= 'publictraining'
			
				AND citm_course_id= 00009461 
				AND event_status in ('Open','Closed')
			
	ORDER BY cat_order, itm_id DESC,
			 fac_reg_order, fac_mercury DESC, fac_order_mercury DESC, fac_state, fac_zip,
			event_length DESC, event_startdate, event_room_id
rs_virtual_events (Datasource=merctraindsn, Time=47ms, Records=0) in E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm @ 04:25:03.003
	SELECT	*
	FROM	qry_training_calendar_with_courses
	WHERE	fac_active= 1 AND fac_resource <> 1
			AND fac_reg_regions LIKE 'AMERICAS%'
			AND NOT (fac_mercury= 0 AND fac_order_mercury= 1)
			
			AND event_startdate + event_length > {d '2014-04-19'}
			AND cat_screentype= 'virtual'
			
				AND citm_course_id= 00009461 
				AND itm_status= 'Current'
				AND event_status in ('Open','Closed')
			
	ORDER BY cat_order DESC, itm_id DESC,
			 fac_reg_order, fac_mercury DESC, fac_order_mercury DESC, fac_state, fac_zip,
			event_length DESC, event_startdate, event_room_id
rs_wsites (Datasource=merctraindsn, Time=0ms, Records=74) in E:\CommonApps\PRODUCTION\MAIN\include\_country_menu.cfm @ 04:25:03.003
		SELECT	*
		FROM	tbl_websites
		WHERE	wsite_active = 1
				AND wsite_contact_info <> ''
				AND wsite_geo <> ''
		ORDER BY	wsite_geo, wsite_long
	


Scope Variables

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=E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=h20546.www2.hp.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=/main/schedule/course_schedule.cfm
PATH_TRANSLATED=E:\CommonApps\PRODUCTION\MAIN\schedule\course_schedule.cfm
QUERY_STRING=ProductID=194&CourseID=00009461&Region=all&sitepick=US
REMOTE_ADDR=15.192.1.43
REMOTE_HOST=15.192.1.43
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/main/schedule/course_schedule.cfm
SERVER_NAME=h20546.www2.hp.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=
Cookie Variables:
CFID=3646366
CFTOKEN=28173618
Session Variables:
access_all=FALSE
access_area_certification=FALSE
access_area_mercury=FALSE
access_area_partner=FALSE
access_beta=FALSE
access_internal=FALSE
alert_message=
bv_usr_session=
cert_access=False
cert_admin=False
cert_group=1
comeback=http://h20546.www2.hp.com/main/schedule/course_schedule.cfm?ProductID=194&CourseID=00009461&Region=all&sitepick=US
courseid=00009461
email=
ff_assign=
ff_close=
ff_default=0
ff_regions=
ff_view=
http_referer=/main
ipaddress_restrict=FALSE
item_discount=0
itemid=
loggedin=FALSE
ls_currency=
ls_dateformat=mmm/dd/yyyy
ls_oitems_cat=
ls_oitems_discountcode=
ls_oitems_discountinfo=
ls_oitems_event=
ls_oitems_id=
ls_oitems_listprice=
ls_oitems_quantity=
ls_oitems_status=
ls_oitems_unitprice=
ls_oitems_userinfo=
ls_paymenttypes=
ls_sitepick=
ls_symbol=
name=
order_no_tax=FALSE
order_no_tax_states=
ordertypes=1
paymenttypes=CC,TU,PO,CRDT,AUFT,MCC,IL,BT,POEF,DD,PTD
permissions=
region=all
report_comment=
sched_admin_access=FALSE
sched_admin_edit=FALSE
sched_admin_main=FALSE
scheduling_group=1
sel_date=
sessionid=863056bf054dbbe933f3631d4472355f3135
status=TRUE
store_admin=False
store_admin_items=False
store_admin_news=False
store_admin_orders=False
store_admin_payment=False
store_admin_regions=
store_admin_system=False
store_admin_users=False
store_group=1
store_status=Shopping
tuvalue=
urltoken=CFID=3646366&CFTOKEN=28173618&jsessionid=863056bf054dbbe933f3631d4472355f3135
userbvid=
usergroup=Visitor
usergroup_discounts=
userid=
usr_address1=
usr_address2=
usr_city=
usr_company=
usr_country=USA
usr_email=
usr_firstname=
usr_lastname=
usr_phone=
usr_residental=
usr_state=
usr_zip=
view_internal=FALSE
URL Parameters:
COURSEID=00009461
PRODUCTID=194
REGION=all
SITEPICK=US
Debug Rendering Time: 15 ms