search

NetSPI / PowerUpSQL

PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server
Other
2.47k stars 462 forks source link

Adding the Ability to Include IP Address Restrictions #23

Closed 0xbadjuju closed 6 years ago

0xbadjuju commented 6 years ago

Example:

$servers = Get-SqlInstanceDomain -IncludeIP; 
$servers | Select ComputerName, Instance, IPAddress

ComputerName                Instance                         IPAddress
------------                --------                         ------
computer1.test.local        computer1.test.local,1433        192.168.1.100
computer2.test.local        computer2.test.local,1433        192.168.1.200
computer3.test.local        computer3.test.local,1433        10.0.0.100

$logins = $servers | Get-SQLConnectionTestThreaded -IPRange 192.168.1.0/24;
$logins 

ComputerName                Instance                         Status
------------                --------                         ------
computer1.test.local        computer1.test.local,1433        Accessible
computer2.test.local        computer2.test.local,1433        Not Accessible
computer3.test.local        computer3.test.local,1433        Out of Scope