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