have you tried grouping by cc.cn instead of hostname?
if you cant make it work, then we need details (create table / insert data scripts) for the other tables...in MS SQL format.
good luck
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day