Moving Lansweeper to another Sewrver

[bernardo]

Hi, I have Lansweeper installed in one PC, and often the cpu process go high. I´m thinking to migrate product to a server that now its free. Can anyone tell me, wich steps should I follow for migration?

Regards,
Bernardo

[bernardo]

I ran the query as you send to me, and I received the following error message:

Mens. 208, Nivel 16, Estado 1, Línea 2
Invalid object name 'web40repActiveComputers'

So, I modified the query, deleting the followings lines, because I see You dont use any fields in this table:

Inner Join web40repActiveComputers
On web40repActiveComputers.Computername = tblComputers.Computername


Now, with the new query I obtnained this result:

PC399VM LONGVIE 5415
NB485VM Dirección LONGVIE 4777

What that´s mind?

[Hemoco]

I would first suggest to try this report:

Select Top 100 Percent tblComputers.Computername, tblOperatingsystem.Description, tblComputers.Domain, Count(tblAutorun.AutorunID) As [Total Autorun] From tblComputers Left Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Inner Join web40repActiveComputers On web40repActiveComputers.Computername = tblComputers.Computername Inner Join tblAutorun On tblComputers.Computername = tblAutorun.Computername Group By All tblComputers.Computername, tblOperatingsystem.Description, tblComputers.Domain Having Count(tblAutorun.AutorunID) > 100 Order By Count(tblAutorun.AutorunID) Desc

Misconfigured autorun on some computers is often the problem.