How to get property info from Powershell object?

Question

I have this object in Powershell which I obtained from a query against the SSRS Web Service:

$ds|gm


TypeName: Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3tServer_ReportService2010_asmx.DataSource

Name        MemberType Definition
----        ---------- ----------

Equals      Method     bool Equals(System.Object obj)                    
GetHashCode Method     int GetHashCode()
GetType     Method     type GetType()
ToString    Method     string ToString()
Item        Property   Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3tServer_ReportService2010_asmx.DataSourceDe...
Name        Property   string Name {get;set;}

If I list the $ds object:

$ds|fl

Name : AHPUsersData
Item : Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3tServer_ReportService2010_asmx.DataSourceReference

What I need is the value of "Item" which actually appears to be the type of an object stored in "Item". I've try assigning $ds.Item to a new object but it just turns into a Powershell custom object and all that info goes away. I've tried various combinations of GetType with no success. Ultimately what I need is the last part of:

Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy3tServer_ReportService2010_asmx.DataSourceReference

Which is the "DataSourceReference" string. This part can have two values, "DataSourceReference" or "DataSourceDefinition" and I need to test that to determine the code to execute next.

Relative newbie to Powershell and this one is a bit obtuse for me. Any help is greatly appreciated.

what does $ds | select -expand Item return?

Martin Brandl
– Martin Brandl

2016-07-18 12:07:32 +00:00
Commented Jul 18, 2016 at 12:07 — Martin Brandl
– Martin Brandl, Commented Jul 18, 2016 at 12:07
Perfect!!! Want to post as an Answer so I can flag it?

Richard Schaefer
– Richard Schaefer

2016-07-18 15:50:03 +00:00
Commented Jul 18, 2016 at 15:50 — Richard Schaefer
– Richard Schaefer, Commented Jul 18, 2016 at 15:50
Sure. Glad it worked :)

Martin Brandl
– Martin Brandl

2016-07-18 16:41:07 +00:00
Commented Jul 18, 2016 at 16:41 — Martin Brandl
– Martin Brandl, Commented Jul 18, 2016 at 16:41

Martin Brandl · Accepted Answer · 2016-07-18 16:40:46Z

1

Just expand the Item with Select-Object:

$ds | select -expand Item

answered Jul 18, 2016 at 16:40

Martin Brandl

59.4k16 gold badges151 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DarkLite1 · Accepted Answer · 2016-07-18 13:51:58Z

0

I don't know exactly what you need, but you could also create your own custom PSCustomObject like this:

[PSCustomObject]@{
    Name                = $ds.Name
    DataSourceReference = $ds.Item.DataSourceReference
    SomethingElse       = $ds.Item | Select-Object -ExpandProperty DataSourceReference
}

At first you select the PropertyName and then the PropertyValue, which can be anything you like. Hopefully this helps you out.

answered Jul 18, 2016 at 13:51

DarkLite1

14.9k46 gold badges138 silver badges239 bronze badges

Collectives™ on Stack Overflow

How to get property info from Powershell object?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related