CREATE VIEW [PUBLIC_VIEWS].[sanhqs]
AS
SELECT 
TG.Name AS 'Customer',
CT.FullDomainName AS 'FQDN',
CT.IPAddress AS 'IP',
CT.LastSyncTime AS 'LastSyncTime',
CSFMU.Downloaded,
CSFMU.NotInstalled,
CSFMU.Failed,
CSFMU.InstalledPendingReboot,
CSFMU.Downloaded + CSFMU.NotInstalled AS 'TotalNeededUpdates'
FROM 
SUSDB.dbo.tbComputerTarget CT
INNER JOIN SUSDB.dbo.tbComputerSummaryForMicrosoftUpdates CSFMU ON CT.TargetID = CSFMU.TargetID
INNER JOIN SUSDB.dbo.tbTargetInTargetGroup TITG ON CT.TargetID = TITG.TargetID
INNER JOIN SUSDB.dbo.tbTargetGroup TG ON TITG.TargetGroupID = TG.TargetGroupID
WHERE tbTargetGroup.Name = '101010 - SANHQs'


GO



----------------

Substring(tbTargetGroup.Name, 1,7) AS KD From tbTargetGroup
WHERE tbTargetGroup.Name = '101010 - Managed Hosting Windows';