Monday, June 12, 2017

How to reset theme back to window 7 through command line






Is there a way to change themes from the command-line, without showing the "Personalization" window?



If you are looking change theme by command line so please use below batch script to change theme.

Please save this script as theme_change.bat and run the script and see the magic.

This script will be very helpful when you are trying to change in remote desktop computer.

For Basic Theme:


rundll32.exe %SystemRoot%\system32\shell32.dll,Control_RunDLL %SystemRoot%\system32\desk.cpl desk,@Themes /Action:OpenTheme /file:"C:\Windows\Resources\Ease of Access Themes\basic.theme"

For Classic Theme:

rundll32.exe %SystemRoot%\system32\shell32.dll,Control_RunDLL %SystemRoot%\system32\desk.cpl desk,@Themes /Action:OpenTheme /file:"C:\Windows\Resources\Ease of Access Themes\classic.theme"


You can change theme according to you. 

C:\Windows\Resources\Ease of Access Themes\








Note:  Please find My Youtube video's  Click Here


Wednesday, June 7, 2017

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

Saturday, June 3, 2017

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