etc

~ scripts and random things

git clone https://github.com/djnnvx/etc.git

commit b52b6473a1443e0f4eb51ec9804f698a5fdc47e9
parent 8dc4b92dc0213796905f0b04ce94b6386b2351a0
Author: djnn <[email protected]>
Date: Wed, 3 Sep 2025 11:00:36 +0900

feat: quick & dirty script to make MSSQL queries

Diffstat:

pentest/ps1/sql.ps1

+++++++++++++++++++++++++++++++++++++++++++++

1 file changed, 45 insertions(+), 0 deletions(-)

diff --git a/pentest/ps1/sql.ps1 b/pentest/ps1/sql.ps1
@@ -0,0 +1,45 @@
+function Run-SQL
+{
+    param (
+        [Parameter(Mandatory=$true)]
+        [string]$instance,
+
+        [Parameter(Mandatory=$true)]
+        [string]$query,
+
+        [Parameter(Mandatory=$false)]
+        [string]$username,
+
+        [Parameter(Mandatory=$false)]
+        [string]$password
+    )
+
+    try {
+        $connectionString = "Server=$instance;"
+
+        if ($PSCmdlet.MyInvocation.BoundParameters.ContainsKey('username')) {
+            $credential = New-Object System.Data.SqlClient.SqlCredential($username, $password | ConvertTo-SecureString -AsPlainText -Force)
+            $connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
+            $connection.Credential = $credential
+        }
+        else {
+            $connectionString += "Integrated Security=True;"
+            $connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
+        }
+
+        using ($connection) {
+            $connection.Open()
+            $command = $connection.CreateCommand()
+            $command.CommandText = $query
+
+            $dataTable = New-Object System.Data.DataTable
+            $dataTable.Load($command.ExecuteReader())
+
+            return $dataTable
+        }
+    }
+    catch {
+        Write-Error "An error occurred while executing the SQL query: $($_.Exception.Message)"
+        return $null
+    }
+}