Has this happened to you – you’re doing a SELECT query from powershell doing your thang, but when you’re trying to output the fruits of your query labour all it says is System.Data.DataRow? You’re sure you did the query right, while the issue seems to be common the internet is not helping you out either and you feel like the scripting world is against you! Don’t worry the Scriptigator got yo’ back brotha/sista!
Okay in all seriousness, the issue does seem fairly widespread and weirdly did not happen to me before except this one time. Output is just “System.Data.DataRow” without outputting the contents of the query. The issue is that PowerShell seems to encapsulate the entire row in an object.
<query_result>.Item to the rescue!!! *this is only needed if the query returns just 1 row.
<query_result>.Item("<item_name>")The item name is the column name that you want to output. As an example the code would look like this
#printing out the query results
Write-Host $query_result.Item("column_name")And there it is, a fairly simple answer to a frustrating issue.
