Report Show Computers logged onto

[Ismail]

I'm requesting a report that shows user "DOMAIN\Administrator" all computers logged onto with the dates.

Something like when I log on to the webconsole and search for the user and a list of "Computer logged onto"

The problem is that i can not export this list and I require a list of more than 50.

I have attached a jpeg showing for better understanding.

[Ismail]

Thanks for your input, I think this looks better:

Select tblComputers.Computer, tblComputers.Domain, tblCPlogoninfo.logontime,
  tblCPlogoninfo.Username, tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
  tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblCPlogoninfo.Username = 'Administrator'
Order By tblCPlogoninfo.logontime Desc 

Just posting this as it might be useful for other people as well.

Thanks!

[Hemoco · Accepted solution]

try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblCPlogoninfo.logontime, tblCPlogoninfo.Domain,
  tblCPlogoninfo.Username, tblCPlogoninfo.Ipaddress
From tblComputers Inner Join
  tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Order By tblComputers.ComputerUnique, tblCPlogoninfo.logontime Desc