T-SQL query

Hi,

In the following query i am getting valid value as well as invalid values. Basically i wanted to see kernelrelease data. This column is needed to display for reporting purposes.

select CASE WHEN ipaddress like '%10.4.%' or ipaddress like '%10.4.%' or ipaddress like '%10.4.%' or ipaddress like '%10.4.139%'  or ipaddress like '%10.%' THEN 'DEV'
WHEN ipaddress not like '%10.%' or ipaddress not like '%10.4%' or ipaddress not like '%10.4.%' or ipaddress not like '%10.4%'  or ipaddress not like '%10.%' THEN 'PROD'

END AS is_Prod_or_Dev

,   o.hostname
,      o.ipaddress
,      CASE WHEN o.hardware_servicetag like '%000%' THEN '' ELSE o.hardware_servicetag END as hardware_servicetag
,      o.oracle_sizeofd02
,      o.oracle_spacedused_d02
,      o.is_virtual
,      o.lsbdistdescription
,      o.uptime
,      o.productname
,   q.value as kernelrelease
,CASE o.is_virtual WHEN
'False' THEN o.processorcount/2 ELSE o.processorcount END AS processorcount
,      o.memorysize
,      o.appname
,   max(w.warrantyEndDate) as LeaseEndDate
,   m.value as crowdstrike
,   n.value as tibslastlogin
,   p.value as reportdate

from oraclehosts o
left join hostwarranty w on w.hostname = o.hostname Collate SQL_Latin1_General_CP1_CI_AS  
left join puppetdb_certname_facts p on p.certname = o.hostname AND p.fact = 'reportdate'
left join puppetdb_certname_facts m on m.certname = o.hostname AND m.fact = 'crowdstrike'
left join puppetdb_certname_facts n on n.certname = o.hostname AND n.fact = 'tibslastlogin'
left join puppetdb_certname_facts q on n.certname = o.hostname AND q.fact = 'kernelrelease'

group by
    o.hostname
,      o.ipaddress
,      o.operatingsystem

,      o.hardware_servicetag
,      o.oracle_sizeofd02
,      o.oracle_spacedused_d02
,      o.is_virtual
,      o.lsbdistdescription
,      o.uptime
,      o.productname
,      o.processorcount
,      o.memorysize
,      o.appname
,m.value
,n.value
,p.value
,q.value


order by reportdate desc

Before add this kernelrelease i had 256 records now i am getting 8000 above records,


This is actual table, when i run then i get one single records.
select * from [dbo].[puppetdb_certname_facts] where fact = 'kernelrelease' and certname ='xxxxxx'

How can i calculate to get a single record. Please help!