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_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);
}
