$datagridview - System.String[]? not correct value?

[lontru]

Hi all

PowerShell Studio 2018 v5.5.154

Trying to build af tool for SCCM.
Why do i get this "System.String[]" i want the macaddr "{00:0A:E4:1E:8F:6E}" in the cell.

Code: Select all

[Codebox=powershell file=Untitled.ps1]

$button_search_Click={
	$textbox_devicename.Text
	$combo_item = Get-CMDevice -Name "*$($textbox_devicename.Text)*" -ForceWildcardHandling | Select-Object -Property Name, MACAddresses, CreationDate
	Update-DataGridView -DataGridView $datagridview_device -Item $combo_item
}
[/Codebox]

ISE Code


Powershell Studio

[jvierra]

MacAddresses is an array of MAC addresses. You need to subscript it to get the address. You can also use "-join" to concatenate the array. Use a computed property to display the addresses.

[lontru]

could you provide a sample on how to do that?

[jvierra]

The following will help you understand how to use computed parameters. See Ex #4
help select-object -Examples

[lontru]

[/Codebox]

Code: [Select all] [Expand/Collapse]

1. $button_search_Click={
2.  
3.     $CMDevices = Get-CMDevice -Name "*$($textbox_devicename.Text)*" -ForceWildcardHandling -Fast | Select-Object -Property ResourceId
4.  
5.     $CMDeviceObjects = @()
6.  
7.     foreach ($CMDevice in $CMDevices)
8.  
9.     {
10.  
11.         $CMResource = Get-CMResource -ResourceId "$($CMDevice.ResourceId)" -Fast | Select-Object -Property Name, MACAddresses, CreationDate, LastLogonUserName
12.  
13.         $CMResource.Name
14.  
15.         $CMDeviceObject = New-Object -TypeName psobject
16.  
17.         $CMDeviceObject | Add-Member -MemberType NoteProperty -Name Name -Value $CMResource.Name
18.  
19.         $CMDeviceObject | Add-Member -MemberType NoteProperty -Name MACAddresses -Value $($CMResource.MACAddresses -join ", ")
20.  
21.         $CMDeviceObject | Add-Member -MemberType NoteProperty -Name CreationDate -Value $CMResource.CreationDate
22.  
23.         $CMDeviceObject | Add-Member -MemberType NoteProperty -Name LastLogonUserName -Value $CMResource.LastLogonUserName
24.  
25.         $CMDeviceObjects += $CMDeviceObject
26.  
27.     }
28.  
29.     Update-DataGridView -DataGridView $datagridview_device -Item $CMDeviceObjects
30.  
31. }
32.  
33.  

GeSHi © Codebox Plus Extension

[lontru]

The following will help you understand how to use computed parameters. See Ex #4
help select-object -Examples

With above i came to this solution.

Code: [Select all] [Expand/Collapse]

1. Get-CMDevice -Name *9999* -ForceWildcardHandling | foreach {(Get-CMResource -ResourceId "$($PSItem.ResourceId)" -Fast | Select-Object -Property Name,CreationDate,@{Name="MACAddresses"; Expression = {$($_.MACAddresses) -join ", "}})}

GeSHi © Codebox Plus Extension

[lontru]

Code: [Select all] [Expand/Collapse]

1. $button_search_Click={
2.  
3. $CMDevices = Get-CMDevice -Name "*$($textbox_devicename.Text)*" -ForceWildcardHandling -fast | foreach { (Get-CMResource -ResourceId "$($PSItem.ResourceId)" -Fast | Select-Object -Property Name, CreationDate,LastLogonUserName,@{ Name = "MACAddresses"; Expression = { $($_.MACAddresses) -join ", " } }) }
4.  
5. Update-DataGridView -DataGridView $datagridview_device -Item $CMDevices
6.  
7. }

GeSHi © Codebox Plus Extension

Thank you. Think above code is the best solution. Learned about the -join and 'Name and Expression keys'

[lontru]

How do i autosize to the whole macaddress is visible? and the name space is smaller?

[jvierra]

Ok. Now lets simplify you code and make it readable and easier to maintain:

Code: Select all

$button_search_Click={
    $properties = @(
        'Name',
        'CreationDate',
        'LastLogonUserName',
        @{ n='MACAddresses'; e = {$_.MACAddresses -join ', '}}
    )
    $CMDevices = Get-CMDevice -Name "*$($textbox_devicename.Text)*" -ForceWildcardHandling -fast | 
        ForEach-Object{
            Get-CMResource -ResourceId $PSItem.ResourceId -Fast
        } |
        Select-Object $properties
    Update-DataGridView -DataGridView $datagridview_device -Item $CMDevices
}

Avoid long code lines by using PowerShell's capability to use advanced arguments and syntax formatting.

[jvierra]

How do i autosize to the whole macaddress is visible? and the name space is smaller?

Set the autosize property of the grid.