Compare and query creation handy tool

Compare and query creation handy tool

This tool will be useful in creating query for adding bulk of machine in CM12 device collections. This will reduce the time taken to form the query structure. Just placing the input and clicking the button will provide the querystructure and the device information can be compared.

Click here to Download

Created  SCCM Query for Adding bulk of machines in collection:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_r_System.Name in ("mnop","ijkl","efgh","abcd") and SMS_R_System.Obsolete != "1" and SMS_R_System.Client = "1"

Compare:

Comparing strings in two columns and identifying the availability of stings in both the column.

If we are part of Patch Deployment and release work, this options make our work easier