I have a bit of a SQL issue that i cant seem to solve. I want a one to many list in one row per PC and not one row per user who has logged onto it (using the console user data). 

Here is an example of what I get now - 

PC1 | Bob |

PC1 | Sally |

PC2 | Tom |

What I want

PC1 | Bob, Sally |

PC2 | Tom |

Is that doable?

Yes it is doable. Look for a blog post from John Nelson and IP address.

Are you using SSRS reporting?

If not, here is the common way: http://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/