c# get result from wql inner join with SCCM 2016

Question

From Task Sequence I need to have 2 informations in 2 different classes

public static readonly string TSPackageClassString = "SMS_TaskSequencePackage";
public static readonly string TSContainerItem = "SMS_ObjectContainerItem";

My WMI Query

string query = string.Format(CultureInfo.InvariantCulture,
               "SELECT {0}.PackageID, {0}.Name, {0}.SecuredScopeNames, {0}.ObjectPath, {1}.ContainerNodeID " +
               "FROM {0} INNER JOIN {1} ON {1}.InstanceKey = {0}.PackageID " +
               "WHERE {1}.ObjectType = 20",
                TSPackageClassString, TSContainerItem);

Run query

IResultObject listOfTaskSequences = connection.QueryProcessor.ExecuteQuery(query);

Enumerate through the collection of objects returned by the query

foreach (IResultObject TS in listOfTaskSequences)
{
     MessageBox.Shox(TS.ToString());
}

The MessageBox
Screenshot

Then I don't find the way to browse results like that :

string packageID = TS["PackageID"].StringValue;
string folderID =  TS["ContainerNodeID"].StringValue;
// or ...
string packageID = TS["SMS_TaskSequencePackage.PackageID"].StringValue;
string folderID =  TS["SMS_ObjectContainerItem.ContainerNodeID"].StringValue;

Thanks for your help !

score 0 · Accepted Answer · answered Apr 11 '18 at 06:20

You would have to write it like this (needs a reference to System.Management for the System.Management.ManagementBaseObject):

using System.Management;

string folderID = ((ManagementBaseObject)TS["SMS_ObjectContainerItem"].ObjectValue)["ContainerNodeID"].ToString();

// or

ManagementBaseObject tsp = TS["SMS_TaskSequencePackage"].ObjectValue as ManagementBaseObject;
string packageID = tsp["PackageID"].ToString();

That being said imo the whole working with ManagementBaseObjects can be very unnecessary complex and annoying and WMI in general is slow, so if you have the possiblity to do the SCCM Queries in the DB directly instead of in the WMI DB you will get it faster, without strange intermediate DataTypes and also get the possiblity to use the much more powerful SQL over WQL

Thanks a lot !!! I had proposed this (SQL) to my client but he refused. Only in WQL :( — Arnaud Lord Sesstyle, Apr 12 '18 at 12:42
Yeah I was afraid you might have some restrictions, but I thought I mention it just in case. Great to hear that it worked! — Syberdoor, Apr 12 '18 at 15:00

c# get result from wql inner join with SCCM 2016

1 Answers1