select distinct (name0) ,creation_date0,datediff(day, creation_date0, {fn Now()}) as Age, CLIENT0,ad_site_name0,active0

 from v_r_system


where (1=1)

--and ad_site_name0 is null
--and client0 is null
--and ad_site_name0 is not null
and operating_system_name_and0 not like '%mac%'

and operating_system_name_and0 not like '%server%'

--GROUP BY NAME0
 and (datediff(day, creation_date0, {fn Now()}) < 8)

ORDER BY NAME0, age DESC