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

Failed to Add Update Source for WUAgent of type (2) and id ({XXXXXX}). Error = 0x80004005.

Failed to Add Update Source for WUAgent of type (2) and id ({XXXXXX}). Error = 0x80004005.

OR

Software Update Error 0x80004005 on client systems

*******This is Generic error message*******

WUAHandler.log

Updatedeployment.log

UpdatesHandler.log

Updates scan completion received, result = 0x80004005.

Solution: 

This issue appears to be with currupted policy info locally on the machine.
There are few reasons why Windows update will not work properly with SCCM Agent.

Here are way to fix this issues

• Stop the SMS agent services.
• Rename the Registry.pol file

 C:\windows\system32\GroupPolicy\Machine\Registry.pol to 

 C:\windows\system32\GroupPolicy\Machine\Registry.pol.old

•    Restart the SMS agent service

•   Go to control panel -> configuration Manager ->

Run the Software update Scan cycle and Software Update deployment Evaluation Cycle in 

Configmgr Action tab.

And review the WuaHandler.log and UpdateDeployment.log

WUAHandler.log:

Waiting for 2 mins for Group Policy to notify of WUA policy change...  
Waiting for 30 secs for policy to take effect on WU Agent.
Added Update Source ({BC44D0B-2643-48E8-9245-9F2B78DD53}) of content type: 2
Async searching of updates using WUAgent started.
Async searching completed.
Successfully completed scan

  

I hope this will help you !!!!!!

 

Note: Please find My Youtube video's Click Here