We’ve seen this issue come up a couple of times so I wanted to give it a mention here just in case you run into it. The problem is that you may notice that a System Center Configuration Manager 2007 (ConfigMgr 2007) Secondary Site Server is unable to do any type of AD discovery in another forest. The forest trust is working fine, and you may see some errors in the adsysdis.log on the secondary site server similar to the following: ERROR: Failed to bind to 'LDAP://domainname/rootDSE' (0x8007203B) ERROR: Failed to enumerate directory objects in AD container LDAP://FQDN SMS_AD_SYSTEM_DISCOVERY_AGENT 11/16/2011…
Author: Eswar Koneti
For those who have/do not have environment to explore system center configuration manager 2012 and its features before the product is launched and get ready for it ,Microsoft has few labs (hope will have more labs on all the features of it soon). This lab should be off help to see how it looks like and its roles and much more. TechNet Virtual Lab: Introduction to System Center Configuration Manager 2012 TechNet Virtual Lab: Migrating from Configuration Manager 2007 to Configuration Manager 2012 http://go.microsoft.com/?linkid=9796179- TechNet Virtual Lab: System Center 2012 Configuration Manager: Application Management http://go.microsoft.com/?linkid=9796558 - TechNet Virtual Lab: System…
Long back i posted report http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ to get computer information like computer name,Serial number,Processor,Physical memory,service Pack,computer model etc In this post ,i have modified the report little bit from previous post to add more fields that gives you lot more information about the computer . It is very simple and straight forward report that just use Where class what columns do you get after running this report ? Name,Serialnumber, Manufacturer,Model,Processor,Memory (KBytes),Size (MBytes),MAC Adress,IP Adress,AD Site,Last user logged in,Operating System,Service Pack,Creationdate in SMS,Last Hardware Scan SELECT distinct sys.name0 as 'Computer Name', sys.AD_Site_Name0 as 'AD Site', CS.domain0 as 'Domain', sys.User_Name0 as 'Last Logged On…
The collection listed below might help you to identify if any computers in organization that do not follow the standard naming convention . Below collection is created to list servers and do not contain specific words in computer name: select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion from SMS_R_System where (SMS_R_System.OperatingSystemNameandVersion like "%Server 6.%" or SMS_R_System.OperatingSystemNameandVersion like "%Server 5.%") and SMS_R_System.ResourceId not in (select ResourceID from SMS_R_System where SMS_R_System.Name like "%xxx%") The Logic is : list all servers with criteria given above and computer do not have xxx word in it. Please change the bold letters as per the requirement.
Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could be of anything like softwares,file names anything that do not have. In this post,I will go through step by step procedure how to make it simple. Step 1: To get list of computers that do not have xxxx,create a collection query that has xxxx. I think this is pretty much easy how to do it using criteria. Create new collection and edit the query . Click on Criteria Tab , click Yellow Burst In the Criterion properties page, click on…
Use Subselected query to get the results: select * from SMS_R_System where SMS_R_System.NetbiosName like "%rts%" and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "rtvscan.exe" AND SMS_R_System.Client = 1)
In my previous post,we saw how to create SCCM report to list clients with its heartbeat time stamp . In this post ,we are going to see ,how to create Create a collection to list clients that are not sending or not reported to SCCM since X days based on its heartbeat (DDR) agent time. To get clients that are not sending heartbeat DDR ,we will use sub selected query which means ,we first create collection that list all clients have heartbeat DDR < 23 days and use this in subselected query to list clients that are not in first created query.…
System Center solutions help you manage your physical and virtual IT environments across datacenters, desktops, and devices. Using these integrated and automated management solutions, you can be a more productive service provider for your business. System Center captures and aggregates knowledge about systems, policies, processes, and best practices so that you can optimize your infrastructure to reduce costs, improve application availability, and enhance service delivery. For more info about avilable Pre-Release products and downloads ,please read http://technet.microsoft.com/sv-se/evalcenter/hh505660.aspx?ocid=otc-n-se-loc