automated scripting telnet or portqry

Question

Need an advise on how to create an automate script to check connectivity from multiple servers to one server (DB) within Windows server environment either with telnet/portqry and also the script will create a .txt file for unsuccessful connection

Thanks in advance for your help Claudia

What about perl's `Net::Ping`? – Slaven Rezic Aug 24 '13 at 07:08 — Slaven Rezic, Aug 24 '13 at 07:08

score 0 · Answer 1 · edited May 23 '17 at 12:24

0

Why don't you just ping it?

if ping -q -c 1 yourserver; then
    echo 'server is online'
else
    echo 'server is offline'
fi

I think this question is similar.

This is bash because you have used bash tag

If you need to check specific port, then you can use this code:

timeout 10 "telnet server port"
if [[ $? == 124 ]]; then # timeout is going to exit with 124 code if it timeouts because of the telnet
    echo 'server is online'
else
    echo 'server is offline'
fi

edited May 23 '17 at 12:24

Community

1
1

answered Aug 23 '13 at 22:36

Aleks-Daniel Jakimenko-A.

10,335
3
41
39

no cannot use ping as need to have the connectivity to SQL Server port – Claudia Benete Aug 23 '13 at 22:42

score 0 · Answer 2 · answered Aug 23 '13 at 22:37

0

Take a look at IPSentry. We've been using it for a number of years in a mixed Windows/UNIX/Linux environment and found it works well.

answered Aug 23 '13 at 22:37

Al Maki

123
5

we want to avoid to install some tools on our server – Claudia Benete Aug 23 '13 at 22:43

score 0 · Answer 3 · answered Aug 24 '13 at 08:40

Since you claim in the comments that you are really trying to test connectivity into a Sql Server, why not use .Net SqlConnection class? Like so,

$server = "server\instance"
$conStr = "Data Source=$server;Integrated Security=true;Initial Catalog=master;Connect Timeout=3;"
$sqlConn = new-object ("Data.SqlClient.SqlConnection") $conStr
try {
    $sqlConn.Open()
    if ($sqlConn.State -eq 'Open') {
        $sqlConn.Close();
        write-host "$server is alive."
    } else {
        write-host "$server connection problem: $($sqlConn.State.ToString())"
    }
} catch {
    write-host "$server is unavailable:"
}

automated scripting telnet or portqry

3 Answers3