Tracking computer usage

[markdeacon]

Hi all,

We have been using lansweeper for a while now, awesome software!

Just been asked to try and get a report of the usage of computers.

I think lansweeper has the data available to track how many times a computer is logged onto. So I think it should be possible to generate some sort of report of which computers get logged onto the most/least.

Has anyone ever tried anything similar using the custom reports tool?

Thanks in advance,

Mark

[Hemoco · Accepted solution]

Please try the report below. It returns a count per computer of the number of logons in the last 7 days.

Select Top 1000000 tblComputers.ComputerUnique, tblComputersystem.Manufacturer, tblComputersystem.Model, Count(tblCPlogoninfo.Computername) As Total From tblComputers Inner Join tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where tblCPlogoninfo.logontime > GetDate() - 7 Group By tblComputers.ComputerUnique, tblComputersystem.Manufacturer, tblComputersystem.Model Order By Count(tblCPlogoninfo.Computername) Desc

[markdeacon]

Lansweeper wrote:
Please try the report below. It returns a count per computer of the number of logons in the last 7 days.

Select Top 1000000 tblComputers.ComputerUnique, tblComputersystem.Manufacturer, tblComputersystem.Model, Count(tblCPlogoninfo.Computername) As Total From tblComputers Inner Join tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername Inner Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Where tblCPlogoninfo.logontime > GetDate() - 7 Group By tblComputers.ComputerUnique, tblComputersystem.Manufacturer, tblComputersystem.Model Order By Count(tblCPlogoninfo.Computername) Desc

Thanks, thats perfect!

[markdeacon]

Yeah it records the logons somewhere but im not sure how to access them as a number.

The perfect report would be a list of computer names, models and the ammount of times logged onto over a specified date range.

Thanks,

Mark