Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Select EX.[Exchequer-Code], M.FirstName + ' ' + M.LastName Name, AD.ClubName, AD.Address1, AD.Address2, T.Town, R.Region, C.Country, AD.PostCode, PH.Phone, EM.Email, AT.Type, M.[Map-Reference], CT.Type ClubType, CASE WHEN Enews.EnewsPackage IS NULL THEN 'None' ELSE ENP.Name END AS Enews, Case When Pem.EPOSID IS NULl then 'None' ELSE Epos.EPOSModel End AS Epos, CASE WHEN Visit.PartnerID IS NULL then 'None' ELSE Visit.[Retail-Score] End AS 'Last Retail Visit', CASE WHEN Visit.PartnerID IS NULL then 'None' ELSE Visit.VisitDate End AS 'Last Retail Visit', LG.Username 'MYTGI Username', LG.Password 'MYTGI Password', RDA.FirstName +' '+ RDA.LastName RDA from dbo.Member M inner join dbo.[Member-Exchequer-Codes] EX ON EX.MemberID = M.ID inner join dbo.[Member-Address] AD ON AD.MemberID = M.ID inner join dbo.Town T on AD.Town = T.ID inner join dbo.Region R on AD.Region = R.ID inner join dbo.Country C on AD.Country = C.ID inner join dbo.[Club-Course-Type] CT on CT.ID = AD.[Club-Course-Type] inner join dbo.[Member-Email] EM ON EM.MemberID = M.ID inner join dbo.[Member-Phone] PH ON PH.MemberID = M.ID inner join dbo.[Member-Account-Type] AT ON M.AccountType = AT.ID inner join dbo.Admin A ON M.[RDA-ID] = A.ID inner join dbo.Member RDA on RDA.ID = A.MID inner join dbo.[Member-Login] LG on LG.MemberID = M.ID left join dbo.MemberEnews Enews on Enews.MID = M.ID LEFT join dbo.EnewsPackage ENP on ENP.ID = Enews.EnewsPackage LEFT JOIN dbo.PartnerEposModel Pem on Pem.PartnerID = M.ID Left join dbo.EPOSSys Epos on Epos.ID = Pem.EPOSID Left join dbo.RetailVisit Visit on Visit.PartnerID = M.ID WHERE AT.ID not in (5,6,8,9,10) AND EM.defaultemail = 'Y' AND PH.DefaultP = 'Y' AND AD.[Default-Address] = 'Y' AND LG.ServiceID = 1
CREATE TABLE [dbo].[RetailVisit]( [ID] [int] IDENTITY(1,1) NOT NULL, [PartnerID] [int] NOT NULL, [RetailConsultant] [int] NOT NULL, [Retail-Score] [int] NOT NULL, [VisitDate] [datetime] NOT NULL, [VisitNotes] [nvarchar](max) NULL, [VisitDocument] [nvarchar](255) NULL, CONSTRAINT [RetailVisit_pk] PRIMARY KEY CLUSTERED (