Pretty unhappy with the out of the box reports this week so wrote a new version that answers previous people asking for this report
select distinct
ac.Name,ac.[Client Date],ac.[Hardware Serial Number],ac.[OS Name], ac.[System Type],
pri.[Device ID], pri.[Default], pri.[Port Name], pri.[Server Name], pri.[Share Name]
from
Inv_AeX_AC_Identification ac
left join inv_hw_printer_windows pri
on pri._ResourceGuid =ac._ResourceGuid
where
ac.[Client Date] > GETDATE ()-20
and pri.[Port Name]is not null
and pri.[Port Name] not like '%xps%'
and pri.[Port Name] not like '%onenote%'
and ac.[OS Name]not like '%server%'
and pri.[Device ID] not like '%pdf%'
and pri.[Device ID] not like '%onenote%'
and pri.[Device ID] not like 'efile%'
and pri.[Device ID] not like 'webex%'
order by ac.Name asc
ps if this helped you mark it as a solution !