→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ismail
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
Ismail
Engaged Sweeper II
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
Lansweeper Alumni
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