SQL Powershell Query into Array of values (powershell 1.0 - no additional tools)

$mydb=connect-db($ntadmindb)
$openstatic = 3
$lockoptimistic = 3
$recordset=new-object -comobject adodb.recordset
$recordset.open($sysinfoquery, $mydb, $openstatic, $lockoptimistic)
$sysinfo=$recordset

$sysinfoquery="select tblservermgmt.txtservermgmtname, tblservermgmt.txtservicelevel, tblservermgmt.txtstatus, tblservermgmt.txtsystemsoftware, tblservermgmt.blnserverbuilt, tblservermgmt.txtpsttype, tblservermgmt.txtemailcontact, tblservermgmt.blnrebootprotection, tblservermgmt.txtupdategroup
    from tblserverhardware inner join tblservermgmt on tblserverhardware.intsystemnumber = tblservermgmt.lngsystemnumber
    where (((tblservermgmt.txtstatus) alike ""active"") , ((tblservermgmt.txtsystemsoftware) alike ""%win%"") , ((tblservermgmt.blnserverbuilt)=true));"
                
current array code:

foreach($record in $recordset){
$servernames.add($sysinfoquery.fields.item("txtservermgmtname").value)
}

i have above query working , ready go in sql. question have how put usable form. until point have been using sysinfoquery.fields.item pull individual values works ($servername = $sysinfo.fields.item("txtservermgmtname").value), pulls first value table. how pull of these values array? 

your on right track, need loop through record set , select each value add array.

a couple of issues see have $servernames.add($sysinfoquery.fields.item("txtservermgmtname").value). arrays not have method called add, hash table, and i not see initialized array.

Windows Server  >  Windows PowerShell