$computerName = (Resolve-DnsName $ip).NameHost
$os = (Get-WmiObject -Computer $ip -Class Win32_OperatingSystem).CaptionJenkins is a continuous integration (CI) tool primarily used for building and testing software projects.
Ansible is a configuration management and orchestration tool for automating infrastructure and application deployment, setup, and administration.
Почему не использовать Python + nmap?А зачем? Штатных средств достаточно для этой задачи...
$sql = "IF NOT EXISTS...;"
$cmd = New-Object Data.SqlClient.SqlCommand $sql, $conn;
$cmd.ExecuteNonQuery();