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