SQLize Online / PHPize Online  /  SQLtest Online

SELECT [ResourceID] ,[PCname] ,[Domain] ,[MAC] ,[IP] ,[OS] ,[CPU] ,[Source] FROM [VDI].[dbo].[Linux] WHERE [Source] = 'SCCM_Linux' AND [ImageVersion] like 'OS v%.3.%' AND [IP] not in ( SELECT [IP] FROM [VDI].[dbo].[Linux] WHERE LEFT ([IP],LEN([IP]) - CHARINDEX('.', REVERSE([IP]))) in ( SELECT distinct LEFT ([IP],LEN( [IP]) - CHARINDEX('.', REVERSE([IP]))) FROM [VDI].[dbo].[Linux] WHERE [Source] = 'SCCM_Linux' AND [IP] not like '21.%' group by LEFT ([IP], LEN([IP]) - CHARINDEX('.', REVERSE([IP]))) having count (*) < 3 ) )