IP address lookup

[Pollak]

Is there a way to lookup by IP?


Thanks,
Niles

[davis226]

Will Lansweeper 4.0 be able to sort and group by IP address? I would like to have a page where computers are sorted by subnet and all those computers would be grouped under one link.

[Hemoco]

davis226 wrote:
Will Lansweeper 4.0 be able to sort and group by IP address? I would like to have a page where computers are sorted by subnet and all those computers would be grouped under one link.

No, but it's a good idea to add it to the wishlist.

[Emort]

ahh nice...

[Hemoco]

Next version will do this, one week patience...

[Emort]

Does this fix/hack still work?
or is there a new way to do this in lates version.

[Pollak]

Awsome, that worked.



Thanks,
Niles

[taeratrin]

OK, figured it out. You also need to run the following script :

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[web30compsearch](@comp varchar(80))
AS SELECT dbo.tblComputers.Computername, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain, dbo.tblOperatingsystem.Caption, CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar) + ' Mhz' AS Processor, CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar) + ' MB' AS Memory, dbo.tblComputers.Lastseen AS [Last seen], CASE ISNULL(dbo.tblOperatingsystem.Description, 'NOT SCANNED') WHEN 'NOT SCANNED' THEN 1 ELSE 0 END AS Notscanned
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername LEFT OUTER JOIN
dbo.tblComputerSystemProduct ON dbo.tblComputers.Computername = dbo.tblComputerSystemProduct.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername LEFT OUTER JOIN
dbo.tblNetwork ON dbo.tblComputers.Computername = dbo.tblNetwork.Computername
WHERE (dbo.tblComputers.Domain LIKE @comp + '%') OR
(dbo.tblOperatingsystem.Description LIKE @comp + '%') OR
(dbo.tblComputers.Computername LIKE @comp + '%') OR
(dbo.tblComputerSystemProduct.IdentifyingNumber = @comp) OR
(dbo.tblNetwork.IPAddress = @comp)
ORDER BY dbo.tblComputers.Computername

This will modify the web30compsearch procedure to include the lines I have marked in bold.

[taeratrin]

Sorry, didn't test in that far. I'm trying to find what else needs to be modified. Please be patient.

[Pollak]

Okay that does allow me to type in IP address in the computer field and I see a history list, but when I selecet or press the magnifying glass nothing is displayed.


Please advise,
Niles