Post reply

Whois lookup from stored procedure

  • October 28, 2004 at 2:41 pm

    #102254

    Anybody out there have any experience or suggestions for a stored procedure to perform a whois lookup on an ip and write the data back to the record?

    Thanks,

    Mark

  • October 28, 2004 at 2:44 pm

    #528344

    Need an external control to do this. You could use sp_oacreate to instantiate some COM object that can handle this. Or run a program from DOS and pipe the output to a file. The read the file into SQL Server.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • October 28, 2004 at 2:53 pm

    #528345

    To extend on Steve, here's a code snippet that might give you some ideas

    set nocount on

    declare @ip varchar(255), @cmd varchar(100)

    set @cmd = 'ping ' + HOST_NAME()

    create table #temptb (grabfield varchar(255))

    insert into #temptb exec master.dbo.xp_cmdshell @cmd

    select @ip = substring(grabfield,  charindex('[',grabfield)+1,

    charindex(']',grabfield)-charindex('[',grabfield)-1) from #temptb  where left(grabfield,7) = 'Pinging'

    print @ip

    drop table #temptb

    set nocount off

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply