select m.mfr_id, m.mfr_name, mbr.firstName, mbr.lastName, m.gs1_gln, tx.notifications, tx.firstNotification, tx.lastNotification, datediff( day, tx.lastNotification, getDate() ) daysAgo from tblManufacturers m left outer join ( select d.informationProviderGLN, count( distinct tx.txId ) notifications, min( tx.receiptDateTime ) firstNotification, max( tx.receiptDateTime ) lastNotification from tbl_1SYNC_Transactions tx inner join tbl_1SYNC_Documents d on d.txId = tx.txId group by d.informationProviderGLN ) tx on tx.informationProviderGLN = m.gs1_gln left outer join tbl_Fspro_members mbr on mbr.fspro_userid = m.fseContactId where m.gs1_syncEnabled = 'Y' order by mfr_name select distinct b.broker_Id, coalesce( b.BrokerAbbrevName, b.broker_name ) brokerName, b.broker_name brokerFullName from tblBrokers b inner join tbl_SMA_BrokerOfficeLink sma on sma.brokerId = b.broker_id inner join tblMfrBrokerLink mbl on mbl.mfr_id = sma.mfr_id and mbl.broker_id = b.broker_id where sma.mfr_Id in ( ) -- and exists ( select * from tbl_PRD_Skus s where s.ownerId = b.broker_id and s.fsl_tablecode = 'BRO' and s.mfrId = sma.mfr_id ) and 1 = 2 order by brokerName

See STOP using this tool, there was a library equivalent built. If you have a need, please add a scrum for that tool - Tx. Griffin

FS Enablers' GLN Number is 1100001017829

select ws.websiteId, ( select count(*) from tbl_CUS_WebsiteSections wss where wss.websiteId = ws.websiteId and wss.uri like '/apps/103%' ) navigation, ( select count(*) from tbl_APP_Configurations c where c.ownerId = ws.portal_ownerId and c.ownerType = ws.portal_ownerType and c.applicationCode like '103%' ) installed from tbl_CUS_Websites ws where ws.portal_ownerId = and ws.portal_ownerType='MFR' select count(*) gs1Skus, sum( case when dataLevel > 0 then 1 else 0 end ) level1Skus, sum( case when coalesce( dataLevel, 0 ) = 0 then 1 else 0 end ) level0Skus from tbl_PRD_Skus where ownerId = and fsl_tablecode = 'MFR' and gs1_syncDate is not null select distinct sma.brokerId, sma.mfr_id from tblBrokers b inner join tbl_SMA_BrokerOfficeLink sma on sma.brokerId = b.broker_id inner join tblMfrBrokerLink mbl on mbl.mfr_id = sma.mfr_id and mbl.broker_id = b.broker_id where sma.mfr_id = and sma.brokerId = select subscriptionId from tbl_PRD_Subscriptions where ownerType = 'MFR' and ownerId = and subscriberType = 'BRO' and subscriberId = select dataProviderId from tbl_PRD_DataProviders where ownerType = 'BRO' and ownerId = and dataOwnerType = 'MFR' and dataOwnerId = select count(*) skuCount from tbl_PRD_SKUs where ownerId = and fsl_tablecode = 'BRO' and mfrId = and shareWithFoodMark = 'Y' select count(*) syndicationCount from tbl_AFDR_Skus where ownerId = and ownertype = 'MFR' select count(*) syndicationCount from tbl_OFS_Skus where ownerId = and ownertype = 'MFR' select count(*) syndicationCount from tbl_OFS_SchoolSkus where ownerId = and ownertype = 'MFR' select count(*) syndicationCount from tbl_OFS_BrokerSkus where ownerId = and ownertype = 'MFR'

GS1 Activity -- Live View switch Development View switch
GS1 Status						Brokers	Channels
Manufacturer (#_mfrCount#)	SKUs Ready/Total	Notifications	First	Last	Days Ago	#htmleditformat( brokerName )# #broker_id#	1FS	1FSBRO	1FSCH	AFDR
#htmleditformat( mfr_name )#^#mfr_id# GLN: #htmleditformat( gs1_gln )# #htmleditformat( qmd_fseProductCatalogContact.email )#	#qmd_skuStats.level1Skus#/#qmd_skuStats.gs1Skus#	#lsnumberformat( notifications )#	#lsdateformat( firstNotification, "MM/DD/YY")#	#lsdateformat( lastNotification, "MM/DD/YY")#	#lsnumberformat( daysAgo )#	&##160;	&##160;	&##160;	&##160;	&##160	&##160; #lsnumberformat( _itemCount )# #lsnumberformat( _shareWithFMCount )#	&##160;	&##160;#lsnumberformat( qmd_1fs.syndicationCount )#	&##160;#lsnumberformat( qmd_1fsbro.syndicationCount )#	&##160;#lsnumberformat( qmd_1fsch.syndicationCount )#	&##160;#lsnumberformat( qmd_afdr.syndicationCount )#

The brokers listed are the brokers that have product catalogs and are in a double spigot relationship with one of the manufacturers to the left.

If a cell for a broker is grey, that means that particular broker does not have a double spigot relationship with the manufacturer.

If a cell is white, that means that syndication is not setup for the Manufacturer/Broker.

If a cell is green, that means that syndication ready - the manufacturer has syndicated to the broker and the broker has setup the manufacturer as a data provider.

If a cell is yellow, that means the Manufacturer has syndicated products to the broker, but the broker does NOT identify the Manufacturer as a data provider.

If a cell is red, that means the Manufacturer NOT syndicated products to the broker, but the broker does identify the Manufacturer as a data provider.

If a number appears in a green or yellow cell, that is the number of SKUs that have been syndicated to the broker.

Connection Busy, Try Again Later or use a non-dev tool