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]

You can change the "count" of computer to a "group by" field then you will see the actual computer names.

[sisman]

no, this user doesn't have any service running under his account...

[sisman]

export is working now, but Total number is confusing me, for some users it reports over 500, and it is not possible that user was logged on 500 different computers

[Hemoco]

sisman wrote:
export is working now, but Total number is confusing me, for some users it reports over 500, and it is not possible that user was logged on 500 different computers

Could it be the scanning user or a service running as administator?

[Hemoco]

try this:

Select Top 1000000 tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
  IsNull(tblADusers.Displayname, '') As Fullname,
  Count(tblCPlogoninfo.Computername) As total
From tblCPlogoninfo Left Join
  tblADusers On tblADusers.Username = tblCPlogoninfo.Username And
    tblADusers.Userdomain = tblCPlogoninfo.Domain
Where tblCPlogoninfo.logontime > GetDate() - 30
Group By tblCPlogoninfo.Username, tblCPlogoninfo.Domain,
  IsNull(tblADusers.Displayname, '')
Order By Count(tblCPlogoninfo.Computername) Desc

Total = amount of computers

[sisman]

When I add table with Displayname then it report timedout

[sisman]

No, with your query it is ok.
But I need also Displayname in report.
P.S. In your query "total" column represents what? total number of computers that user logged on?

[Hemoco]

Do you get a timeout for the query I provided?

[sisman]

how to add DisplayName connected to Username, I keep getting TimedOut error...