mysql - How to retrieve user logged on by reading computer name from database? -

mysql - How to retrieve user logged on by reading computer name from database? -

i new powershell , have script ping every computer database server. using mysql (yes know people utilize mssql powershell in case have utilize mysql).

the ping works fine, how can retrieve username every computer pings succesfully?

thanks in advance!

below code:

#ping computers database verify if online/offline #create command object $command = new-object mysql.data.mysqlclient.mysqlcommand; $command.connection = $connection # $command = $connection.createcommand() #error #call procedure execute command $command.commandtext = "select w.ws sandbox_maesc4.coordinates c inner bring together softphone_materials_updater.workstations w on c.station_number = w.pod"; #execute command reading each row $reader = $command.executereader(); #read values database $workstation_list = $( while ($reader.read() ){ $reader.getvalue(0) }) #close reader $reader.close() #ping each computer if online, obtain username logged in foreach($pc_db in $workstation_list){ if(test-connection -computername $pc_db -count 1 -erroraction silentlycontinue){ #here code, want retrieve username that's logged on! get-wmiobject -computername $pc_db -class win32_computersystem | select-object -expandproperty username } else{ write-host "$pc_db offline" -foregroundcolor reddish } }#end each loop $connection.close() }#end ping_test function db_conn #execute function

if you're looking username of current logged on user, can reference win32_computersystem wmi object has username parameter containing current logged-in user:

get-wmiobject -computername $pc_db -class win32_computersystem | select-object -expandproperty username

mysql powershell powershell-v2.0 powershell-ise