SCCM Query to find machines with a certian HOTFIX installed

Here is described step by step to pull report for installed hot fix.


https://sccmtitbits.blogspot.in/2017/05/how-to-verify-systems-are-patched-for.html


Note: Please find My Youtube video's Click Here

SCCM Query to create collection for Workstation or Server computers

If you are looking SCCM query to create collection for Workstation / Server computer so you can use this query.

Here is the query..

Query for workstation machine: 

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation"

Query for server machine:

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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Server"

If you have any queries please comment below.

Note: Please find My Youtube video's Click Here

SCCM Query to create collection for Virtual or Physical computers

Hi Folks……. again it’s something about SCCM, I think few of my last articles would have helped you in many System administrative aspects…now I am here with SCCM collection query for virtual and physical machines in the given environment.

 Here is the query,

Query for Virtual machines:

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.IsVirtualMachine = "1"

Query for physical machines: 

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.IsVirtualMachine != "1"

Note: Please find My Youtube video's Click Here