Eventually, you’re going to want to send information from clients (create records) to a database. There are many ways to do this, but using PowerShell is the most modern way.
This script accesses the ‘Test’ DB, and creates a record with the client computer name and timestamp.
[String]$dbname = "Test";
$computername = $env:COMPUTERNAME
$timeformat='MM-dd-yyyy hh:mm:ss tt'
$time = (Get-Date).ToString($timeformat)
# Open Connection with Windows authentication to local SQLSERVER.
$con = New-Object Data.SqlClient.SqlConnection;
$con.ConnectionString = "Data Source=.;Initial Catalog=Test;Integrated Security=True;";
$con.Open();
# Create the record.
$sql = "INSERT INTO Inventory.ComputerInfo ([ComputerName],[AcquiredDate])
VALUES('{0}','{1}')" -f
$computername,$time
$cmd = New-Object Data.SqlClient.SqlCommand $sql, $con;
$cmd.ExecuteNonQuery();
# Write-Host "Computer Name: $computername";
# Write-Host "Time: $time";
# Write-Host "SQL Command: $sql";
Write-Host "Record has been created";
# Close and Clear all objects.
$cmd.Dispose();
$con.Close();
$con.Dispose();