SCCM QUERY TO FIND INSTALLED APPLICATION FROM "ADD OR REMOVE PROGRAMS" - SCCM 2012

Select DISTINCT SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.DisplayName0, SP.Publisher0, SP.Version0, SP.InstallDate0
from  v_Add_Remove_Programs sp
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = 'SMS00001'
ORDER By SYS.Netbios_Name0, SP.DisplayName0, SP.Publisher0, SP.Version0, SP.InstallDate0


Note: 'SMS00001' is All systems collection ID, you can change to any other collections ID and generate the report.

SCCM SQL QUERY TO FIND "MS-OFFICE PRODUCTS REGISTERED IN ADD or REMOVE PROGRAMS"

select distinct (a.Netbios_name0), a.Creation_date0,a.User_name0,a.client0, a.ad_site_name0,a.obsolete0,b.sms_installed_sites0 as 'sitecode',
os.Caption0 + ' '+ os.CSDversion0 as 'Operating System',addr.DisplayName0,addr.Version0,addr.Publisher0,addr.InstallDate0
from v_r_system a
left outer join v_RA_System_SMSInstalledSites b on a.resourceid=b.resourceid
left outer join v_GS_WORKSTATION_STATUS c on a.resourceid=c.resourceid
left outer join v_GS_Operating_system OS on os.resourceid=a.resourceid
inner join v_GS_ADD_REMOVE_PROGRAMS addr on addr.resourceid=a.resourceid
where (addr.DisplayName0 like 'Microsoft Office 2%'
 OR addr.DisplayName0 LIKE 'Microsoft % Professional%'
 OR addr.DisplayName0 LIKE 'Microsoft % Enterprise %'
 OR addr.DisplayName0 LIKE '%Microsoft % Standard%' )
 ORDER BY Netbios_Name0 ASC

COMMAND LINE TO INSTALL SCCM CLIENT ON WINDOWS 10 SYSTEMS

Windows-10 32Bit OS: “ccmsetup.exe /skipprereq:WindowsUpdateAgent30-x86.exe”

Windows-1064Bit OS: “ccmsetup.exe /skipprereq:WindowsUpdateAgent30-x64.exe”

SCCM Collection query to find "WINDOWS 8" and "WINDOWS 8.1" Systems

WQL Query to find Windows 8 Systems and Windows 8.1

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.OperatingSystemNameandVersion like "%Workstation%"   and SMS_R_System.OperatingSystemNameandVersion like "%6.3%"  or SMS_R_System.OperatingSystemNameandVersion like "%Workstation%"   and SMS_R_System.OperatingSystemNameandVersion like "%6.2%"

Running Configuration Manager 2012 Remote Control standalone

In some scenarios you may want for instance servicedesk or helpdesk personnel run the Configuration Manager 2012 Remote Control without having to install the Admin Console and grant them permissions to use the Admin Console when they really only need to run Remote Control.

Here is how to do it, the following files are needed.

From the directory where the AdminConsole is installed, example: E:\Program Files\Microsoft Configuration Manager\AdminConsole\bin\i386, copy the following files:

In the directory 0000409 you need one file as well.

Copy the whole directory with these files present to the computer you want to run Remote Control from so you have a folder structure like this:
And then simply launch the CmRcViewer.exe and you are good to go:

Important information, if you want the standalone Remote Viewer to report back to the SCCM Site Server which client is remote controlled and by who, you can add the registry value below on the client as well. 

For 32 bits

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ConfigMgr10\AdminUI\Connection]
“Server”=”Site Server Name”

For 64 bits
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\Connection]
“Server”=”Site Server Name”

VBSCRIPT TO RENAME LOCAL BUILTIN "ADMINISTRATOR" AND "GUEST" ACCOUNT

'This specifies the local computer
strComputer = "."

'This tells it what name to look for
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colAccounts = objWMIService.ExecQuery _
("Select * From Win32_UserAccount where localaccount = True and Description = 'Built-in account for administering the computer/domain'")
'This tells it what to rename the account to
For Each objAccount in colAccounts
    objAccount.Rename "ADMIN"
Next

'This tells it what name to look for
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colAccounts = objWMIService.ExecQuery _
("Select * From Win32_UserAccount where localaccount = True and Description = 'Built-in account for guest access to the computer/domain'")
'This tells it what to rename the account to
For Each objAccount in colAccounts
    objAccount.Rename "Guest"
Next