Query for all Computers and Logonuser History

[LANuser99]

Hi.

Can´t figure this out, so i´m trying to post here.

I have about 1000 machines in my LANsweeper and now i want
a Report on all machines ( Machine name ) and the History
of ALL logon users.
I would like the ouput Grouped by machine name - so i don´t end
up with 100000+ rows - One row for every machine, but just differnt
users.

I have alot of users login in on the same machine - that gives me the
result of many rows in the report - but the same computer.

I would like the report to show the Computer and ALL the users that
have been using the machine - In one row ( Just so the report doesn´t
end up with alot of rows, with the same machine )

Is there anyone out there, that has the Report syntax to do this report ?

// Thanx

[LANuser99]

This is what I have today.

Select tblComputers.Computer, tblComputersystem.Model, tblUsershist.Name,
tblUsershist.Fullname
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblUsershist On tblComputers.Computername = tblUsershist.Computername
Group By tblComputers.Computer, tblComputersystem.Model, tblUsershist.Name,
tblUsershist.Fullname

But this end up with, ex.
COMPUTERNAME USER
---------------------------
NR1 user1
NR1 user2
NR1 user3
NR1 user5

i would like something like this...

COMPUTERNAME USER
---------------------------
NR1 user1,user2,user3,user5

// Thanx

[Hemoco · Accepted solution]

LANuser99 wrote:

i would like something like this...

COMPUTERNAME USER
---------------------------
NR1 user1,user2,user3,user5

// Thanx

I'm afraid this won't be possible.