Showing posts from January, 2012

How to Turn on Remote Desktop Using Regedit


Find all Obsolete computerobject in SCCM 2007

When you have a big Microsoft SCCM 2007 environment, it’s very handy to have an overview of all the obsolete computerobject within the SCCM database. This query gives you this overview.1.) Create a new Collection. (In my example it is All Obsolete Computerobjects)
2.) Create a new query. (In my example it is Query All Obsolete Computerobjects)
3.) Edit the query statement. Use the following query:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Obsolete = 1

4.) Run the “Update Collection Membership”
5.) View the result This entry was posted on Wednesday, April 6th, 2011 at 11:30 am and is filed under Microsoft SCCM 2007. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

How to remove the Null Entries from SCCM

Run this query select SYS1.ResourceID,SYS1.ResourceType,SYS1.Name,SYS1.SMSUniqueIdentifier,SYS1.ResourceDomainORWorkgroup,SYS1.Client from SMS_R_System as sys1 inner join SMS_R_System as sys2 on sys2.NetbiosName = sys1.NetbiosName where (sys1.ResourceId < sys2.ResourceId) to find system with null entries
Run this query Select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name = s1.Name where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId and R.Client = null to find system with Null Entries in the console having properties with values "blocked=Null,Client Type=Null,Obsolete=Null,Active=Null" moreover their Hardware id Null System UUID is null and SMS unique identifier is null.Resolution:These are not obsolete clients, they are what we call “timing issue records” this happens when a PC regis…



Remote Server Administration Tools for Windows 7 is missing

About Remote Server Administration ToolsYou can install the Administration Tools pack on computers that are running the Windows 7 operating system, and use the Administration Tools pack to manage specific technologies on computers that are running either Windows Server® 2008 R2, Windows Server 2008, or, in some cases, Windows Server 2003.The Administration Tools pack includes support for remote management of computers that are running the Server Core installation option of either Windows Server 2008 R2 or Windows Server 2008. However, Remote Server Administration Tools for Windows 7 cannot be installed on any versions of the Windows Server operating system.Administration Tools are secure by default. The default Administration Tools configuration opens only those ports and enables only those services and firewall exceptions required for remote management to work.System requirementsRemote Server Administration Tools for Windows 7 can be installed on computers that are runnin…