public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
int type = (int)PackageType.RegularSoftwareDistribution;
string cmquery = "select * from SMS_PackageBaseclass WHERE PackageType='" + type + "'";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
Name = ResultObjectHandler.GetString(resource, "Name"),
ID = ResultObjectHandler.GetString(resource, "PackageID"),
Description = ResultObjectHandler.GetString(resource, "Description"),
PackageType = ((PackageType)ResultObjectHandler.GetInt(resource, "PackageType")).ToString()
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
string cmquery = "select * from SMS_TaskSequencePackage";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
ID = ResultObjectHandler.GetString(resource, "PackageID"),
Name = ResultObjectHandler.GetString(resource, "Name"),
TaskSequenceType = ((TaskSequenceType)ResultObjectHandler.GetInt(resource, "Type")).ToString()
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// https://docs.microsoft.com/en-us/configmgr/develop/reference/osd/sms_tasksequenceappreferencesinfo-server-wmi-class
string cmquery = "select * from SMS_TaskSequenceAppReferencesInfo";
List <object> retlist = new List <object>();
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
string tsid = ResultObjectHandler.GetString(resource, "PackageID");
string appid = ResultObjectHandler.GetString(resource, "RefAppCI_ID");
propertylist.Add(new { tsid, appid });
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select CollectionID,ResourceID from SMS_FullCollectionMembership";
List <object> retlist = new List <object>();
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
string colids = ResultObjectHandler.GetString(resource, "CollectionID");
string resourceid = ResultObjectHandler.GetString(resource, "ResourceID");
//split the collection list and
foreach (string collectionid in colids.Split(','))
{
propertylist.Add(new { resourceid, collectionid });
}
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_CIRelation WHERE RelationType=6";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
FromCIID = ResultObjectHandler.GetString(resource, "FromCIID"),
ToCIID = ResultObjectHandler.GetString(resource, "ToCIID")
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_Application WHERE IsLatest='TRUE'";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
IsDeployed = ResultObjectHandler.GetBool(resource, "IsDeployed"),
IsEnabled = ResultObjectHandler.GetBool(resource, "IsEnabled"),
IsSuperseded = ResultObjectHandler.GetBool(resource, "IsSuperseded"),
IsSuperseding = ResultObjectHandler.GetBool(resource, "IsSuperseding"),
IsLatest = ResultObjectHandler.GetBool(resource, "IsLatest"),
ID = ResultObjectHandler.GetString(resource, "CI_ID"),
Name = ResultObjectHandler.GetString(resource, "LocalizedDisplayName")
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_R_User";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
ID = ResultObjectHandler.GetString(resource, "ResourceId"),
SID = ResultObjectHandler.GetString(resource, "SID"),
DN = ResultObjectHandler.GetString(resource, "DistinguishedName"),
//dev.OU = ResultObjectHandler.GetString(resource, "SystemOUName"),
Name = ResultObjectHandler.GetString(resource, "Name"),
//dev.CollectionIDs.Add(resource["CollectionID"].StringValue)
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_Collection";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
int typeint = ResultObjectHandler.GetInt(resource, "CollectionType");
propertylist.Add(new
{
ID = ResultObjectHandler.GetString(resource, "CollectionID"),
Name = ResultObjectHandler.GetString(resource, "Name"),
LimitingCollectionID = ResultObjectHandler.GetString(resource, "LimitToCollectionID"),
Comment = ResultObjectHandler.GetString(resource, "Comment"),
IncludeExcludeCollectionCount = ResultObjectHandler.GetInt(resource, "IncludeExcludeCollectionsCount"),
CollectionType = ((CollectionType)typeint).ToString()
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_SoftwareUpdate";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
propertylist.Add(new
{
ID = ResultObjectHandler.GetString(resource, "CI_ID"),
ArticleID = ResultObjectHandler.GetString(resource, "ArticleID"),
BulletinID = ResultObjectHandler.GetString(resource, "BulletinID"),
DateCreated = ResultObjectHandler.GetDateTime(resource, "DateCreated").ToString(),
DateRevised = ResultObjectHandler.GetDateTime(resource, "DateRevised").ToString(),
Name = ResultObjectHandler.GetString(resource, "LocalizedDisplayName"),
IsBundle = ResultObjectHandler.GetBool(resource, "IsBundle"),
IsDeployed = ResultObjectHandler.GetBool(resource, "IsDeployed"),
IsExpired = ResultObjectHandler.GetBool(resource, "IsExpired"),
IsLatest = ResultObjectHandler.GetBool(resource, "IsLatest"),
IsSuperseded = ResultObjectHandler.GetBool(resource, "IsSuperseded"),
Description = ResultObjectHandler.GetString(resource, "LocalizedDescription"),
NumMissing = ResultObjectHandler.GetInt(resource, "NumMissing"),
PercentCompliant = ResultObjectHandler.GetInt(resource, "PercentCompliant"),
SeverityName = ResultObjectHandler.GetString(resource, "SeverityName"),
Size = ResultObjectHandler.GetInt(resource, "Size")
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_AuthorizationList";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
//https://docs.microsoft.com/en-us/configmgr/develop/core/understand/how-to-read-lazy-properties-by-using-managed-code
resource.Get();
int[] lazyupdates = resource["Updates"].IntegerArrayValue;
List <string> updates = new List <string>();
foreach (int i in lazyupdates)
{
updates.Add(i.ToString());
}
propertylist.Add(new
{
id = ResultObjectHandler.GetString(resource, "CI_ID"),
name = ResultObjectHandler.GetString(resource, "LocalizedDisplayName"),
description = ResultObjectHandler.GetString(resource, "LocalizedDescription"),
updates = updates
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
try
{
// This query selects all collections
string cmquery = "select * from SMS_Program";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
string programName = ResultObjectHandler.GetString(resource, "ProgramName");
string packageID = ResultObjectHandler.GetString(resource, "PackageID");
propertylist.Add(new
{
ProgramName = ResultObjectHandler.GetString(resource, "ProgramName"),
DependentProgram = ResultObjectHandler.GetString(resource, "DependentProgram"),
Description = ResultObjectHandler.GetString(resource, "Description"),
PackageName = ResultObjectHandler.GetString(resource, "PackageName"),
PackageID = ResultObjectHandler.GetString(resource, "PackageID"),
ID = packageID + ";;" + programName,
//Name = PackageName + " (" + ProgramName + ")";
Name = programName
});
}
}
}
catch { }
querydata.Properties = propertylist;
return(querydata);
}
public NeoQueryData CollectData()
{
NeoQueryData querydata = new NeoQueryData();
List <object> propertylist = new List <object>();
querydata.Properties = propertylist;
try
{
// This query selects all collections
string cmquery = "select * from SMS_DeploymentSummary";
// Run query
using (IResultObject results = Connector.Instance.Connection.QueryProcessor.ExecuteQuery(cmquery))
{
// Enumerate through the collection of objects returned by the query.
foreach (IResultObject resource in results)
{
string ciid = ResultObjectHandler.GetString(resource, "CI_ID");
if (string.IsNullOrWhiteSpace(ciid))
{
ciid = ResultObjectHandler.GetString(resource, "PackageID");
}
string intent = string.Empty;
switch (ResultObjectHandler.GetInt(resource, "DeploymentIntent"))
{
case 1:
intent = "Install";
break;
case 2:
intent = "Uninstall";
break;
case 3:
intent = "Preflight";
break;
default:
break;
}
propertylist.Add(new
{
CollectionID = ResultObjectHandler.GetString(resource, "CollectionID"),
//CollectionName = ResultObjectHandler.GetString(resource, "CollectionName"),
DeploymentID = ResultObjectHandler.GetString(resource, "DeploymentID"),
DeploymentIntent = intent,
SoftwareName = ResultObjectHandler.GetString(resource, "SoftwareName"),
//PackageID = ResultObjectHandler.GetString(resource, "PackageID"),
//ProgramName = ResultObjectHandler.GetString(resource, "ProgramName"),
CIID = ciid
//FeatureType = ((SccmItemType)ResultObjectHandler.GetInt(resource, "FeatureType")).ToString()
});
}
}
}
catch { }
return(querydata);
}
