which computers user was logged on

[sisman]

Hi,

is it possible to generate report like this:

-list of users who were logged on on more than one workstation in last 30 days-

[Hemoco]

Add top 1000000

Select top 1000000 tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
  Count(tblCPlogoninfo.Computername) As total
From tblCPlogoninfo   
Where tblCPlogoninfo.logontime > GetDate() - 30
Group By tblCPlogoninfo.Username, tblCPlogoninfo.Domain
Order By Count(tblCPlogoninfo.Computername) Desc

[sisman]

can not save this query as report.

[Hemoco]

try this:

Select tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
  Count(tblCPlogoninfo.Computername) As total
From tblCPlogoninfo   
Where tblCPlogoninfo.logontime > GetDate() - 30
Group By tblCPlogoninfo.Username, tblCPlogoninfo.Domain
Order By Count(tblCPlogoninfo.Computername) Desc