Permanently Disabled

select #_anomaliesColumnList# from qmd_anomalies union select #_anomaliesColumnList# from qmd_detectorResults select * from qmd_anomalies where ownerId > 0 and not ( ownerType = '#listFirst( _clientCode, ":")#' and ownerId = #listLast( _clientCode, ":")#) select m.firstName, m.lastName, m.fspro_userid, case when m.email = 'rheavern@fslibrary.com' then 'rheavern@fsenablers.com' else m.email end email, mfr.mfr_name clientName from tblManufacturers mfr left outer join tbl_Fspro_members m on m.fspro_userId = mfr.fseContactId where mfr.mfr_id = select m.firstName, m.lastName, m.fspro_userid, case when m.email = 'rheavern@fslibrary.com' then 'rheavern@fsenablers.com' else m.email end email, bro.broker_name clientName from tblBrokers bro left outer join tbl_Fspro_members m on m.fspro_userId = bro.fseContactId where bro.broker_id = select * from qmd_anomalies where clientName not like 'OwnerType%' and detectorName not in ( 'reDistributionDetector', 'otherDirectShipDetector' ) order by email, ownerType, ownerId, detectorName

Anomalies for #htmleditformat( clientName )#
Type	Anomaly	Count
#htmleditformat( anomalyType )#	#htmleditformat( message )#	#lsnumberformat( anomalyCount )#

If you do not know what these mean, please contact mgriffin@fsenablers.com

#_anomalyNotificationHTML#

#_bccList#

select * from qmd_anomalies where clientName not like 'OwnerType%' and detectorName in ( 'reDistributionDetector', 'otherDirectShipDetector', 'mappingPriorityDetector' ) order by email, ownerType, ownerId, detectorName

Anomalies for #htmleditformat( clientName )#
Type	Anomaly	Count
#htmleditformat( anomalyType )#	#htmleditformat( message )#	#lsnumberformat( anomalyCount )#

If you do not know what these mean, please contact mgriffin@fsenablers.com

> #_anomalyNotificationHTML#

#_bccList#