This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

List SQL instance port

MathieuJM over 4 years ago

Hi,

I have a powershell script to list the SQL Server instance port that is fully functional on the server itself but that return nothing when executed by SAM. The server is monitored through a SolarWinds agent.

The script is:

$path = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\*\MSSQLServer\SuperSocketNetLib\Tcp\IPAll'
$name = "TcpPort"
[array]$value = (Get-ItemProperty -Path $path -name $name)
$v = $value.TcpPort
Write-Host "Message: VALUE: $v"
write-host "Statistic: $($v.count)"

the output on the server is:

Message: VALUE: 54046 57782 57650 53162 53932 55822 60945 50526
Statistic: 8

The output from SAM is:

Message.Statistic: VALUE:

Statistic.Statistic: 0

I have try to execute the script with and without specifying an account.

Have you already have the need to gather this information and how do you have implemented it in SolarWinds ?

Any idea how to get this info, knowing that this info has to be an input for another part of the script.

Cheers

0 tomiannelli over 4 years ago
MathieuJM What is the Execution Mode [ Create a Windows PowerShell monitor ] of the Component set to?
This component monitor runs a Windows PowerShell script on the Orion server or a remote target node to collect metrics as follows:
The monitor checks if the execution mode is Local Host or Remote Host.
If Local Host, the script executes using the script arguments on the Orion server.
If Remote Host, the script connects via SSH connection to run the script on the target server.
Cancel
Vote Up 0 Vote Down

Cancel
0 MathieuJM over 4 years ago in reply to tomiannelli

We are using Agent to monitor the server and also to monitor the application
We use local host with agent polling method.
Cancel
Vote Up 0 Vote Down

Cancel
0 tomiannelli over 4 years ago in reply to MathieuJM

MathieuJM I am checking with the SolarWinds product team. It is straight forward how the scripts will be executed when you have the Preferred Polling Method = Agentless. But when it is set to Agent how does that affect the Execution Mode? I'll let you know when I hear back.
Cancel
Vote Up 0 Vote Down

Cancel
0 tomiannelli over 4 years ago in reply to tomiannelli

OK I found an article by jbiggley that answers my confusion on behavior. [Agent Polling and PowerShell Scripts ]
So the other thing I am wondering is permissions to the path. If you tweak your script something like this what result do you see?
$path = 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\*\MSSQLServer\SuperSocketNetLib\Tcp\IPAll';
$name = "TcpPort";
IF (test-path -path $path)
{
[array]$value = (Get-ItemProperty -Path $path -name $name);
$v = $value.TcpPort;
Write-Host "Message: VALUE: $v";
write-host "Statistic: $($v.count)";
Write-Host $value;
}
else
{
Write-Host "Message: No Such Path $path";
exit 1;
}
Cancel
Vote Up 0 Vote Down

Cancel