Custom column, prefilled

This topic contains 2 replies, has 2 voices, and was last updated by Profile photo of Ian Fermer Ian Fermer 1 year, 8 months ago.

  • Author
    Posts
  • #30182
    Profile photo of Ian Fermer
    Ian Fermer
    Participant

    Hi,

    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
    Profile photo of Chris Wolfenden
    Chris Wolfenden
    Participant

    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
    Profile photo of Ian Fermer
    Ian Fermer
    Participant

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

You must be logged in to reply to this topic.