This tool is now obsolete. Please use 1FS Profile Database | Operator Profiles

select cho.cho_id, cho.cho_name, cho.cho_address, cho.cho_address2, cho.cho_city, cho.cho_state, cho.cho_zipCode, fsl_choIdBy, fsl_choIdStatus, fsl_choIdDate, opr.ownerId, opr.fsltablecode, opr.operatorId, opr.companyName, opr.address, opr.address2, opr.city, opr.state, opr.zipCode, opr.recordSource, m.email, '' clientName from tbl_OPR_ClientOperators opr with (nolock) inner join tbl_CHO_Operators cho with (nolock) on cho.cho_id = fsl_choId left outer join tbl_Fspro_members m with (nolock) on m.fspro_userId = opr.fsl_choidBy where opr.fsl_choIdDate is not null and convert( datetime, convert( varchar, fsl_choIdDate, 101 )) >= and convert( datetime, convert( varchar, fsl_choIdDate, 101 )) < order by cho.cho_name, opr.fsl_choIdDate select distinct email from qmd_links where email is not null order by email select * from qmd_links where ( fsl_choIdStatus = 'M' OR fsl_choIdStatus = '1' OR fsl_choIdStatus = '2' OR fsl_choIdStatus = '3' ) order by cho_name, fsl_choIdDate select distinct cho_id from qmd_links where ( fsl_choIdStatus = 'M' OR fsl_choIdStatus = '1' OR fsl_choIdStatus = '2' OR fsl_choIdStatus = '3' ) and email = select * from qmd_links where cho_id in ( ) order by cho_name, fsl_choIdDate select * from qmd_links where 1 = 1 and email = order by cho_name, fsl_choIdDate

#lsnumberformat( qmd_links.recordCount )# Operator Records Linked (see summary)
1FS Id	1FS Operator	Client Operator	Client	Linkage
#cho_id#	#htmleditformat( cho_name )# #htmleditformat( cho_address )# #htmleditformat( cho_address2 )# #htmleditformat( cho_city )#, #htmleditformat( cho_state )# #htmleditformat( cho_zipCode )#	#htmleditformat( companyname )# #htmleditformat( address )# #htmleditformat( address2 )# #htmleditformat( city )#, #htmleditformat( state )# #htmleditformat( zipCode )# #htmleditformat( recordSource )#	#htmleditformat( clientName )# (operatorId: #operatorId#)	Method: #displayMethod(fsl_choIdStatus)# User: #htmleditformat( email )#SystemUnknown Date: #fsl_choIdDate#

select clientName, count(*) links from qmd_links group by clientName order by links desc select fsl_choIdStatus, count(*) links from qmd_links group by fsl_choIdStatus order by links desc select email, count(*) links from qmd_links group by email order by links desc

User Summary
User	Links
#email#System	#links#

Client Summary
Client	Links
#htmleditformat( clientName )#	#links#

Method Summary
Method	Links
#displayMethod(fsl_choIdStatus)#	#links#