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
{
// 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>();
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);
}
