Custom column, prefilled

This topic contains 2 replies, has 2 voices, and was last updated by  Ian Fermer 2 years, 9 months ago.

  • Author
  • #30182

    Ian Fermer


    I'm doing a get-wmiobject and selecting objects to export to a csv, however I also want a custom column in there with a variable for each row that has data

    So far I have

    $user = [Environment]::UserName

    Get-WmiObject Win32_MappedLogicalDisk | select name, providername | Export-Csv c:\temp\mapped.csv -Append -notypeinformation

    So trying to get a username column in there with each row having $user in

  • #30183

    Chris Wolfenden

    In general when you want to add a custom column you can just add a hashtable to your Select Statement:

    $user = [Environment]::UserName
    Get-WmiObject Win32_MappedLogicalDisk | select name, providername,@{Name="Username";Expression={$user}} | Export-Csv c:\temp\mapped.csv -Append -notypeinformation
  • #30184

    Ian Fermer

    I was so close to getting this one, thank you!

You must be logged in to reply to this topic.