IP address lookup

[Pollak]

Is there a way to lookup by IP?


Thanks,
Niles

[taeratrin]

You'll need to modify web30ajaxcomp in the stored procedures. Where it says :

UNION
SELECT DISTINCT IdentifyingNumber AS Computer, 'icons/assettag.gif' AS ComputerImage
FROM         dbo.tblComputerSystemProduct
WHERE     (IdentifyingNumber <> '')) DERIVEDTBL

change it to :

UNION
SELECT DISTINCT IdentifyingNumber AS Computer, 'icons/assettag.gif' AS ComputerImage
FROM         dbo.tblComputerSystemProduct
WHERE     (IdentifyingNumber <> '')
UNION
SELECT DISTINCT IPAddress AS Computer, 'icons/assettag.gif' AS ComputerImage
FROM         dbo.tblNetwork
WHERE     (IPAddress <> '')) DERIVEDTBL

After that, restart the WWW Publishing service.