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.
Author: Eswar Koneti
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
Long back ,I have written a post on www.windows-noob.com how to install SCCM 2007 admin console Via Software Distribution using unattended setup file(.ini). In this post,we will go through how to perform unattended installation of SCCM 2012 RC.We follow the same procedure here as we did in SCCM2007 with minor modifications OR You can use configuration manager 2012 site server to install the console from ConfigMgrSiteServerInstallationPath>\tools\ConsoleSetup for more info read http://technet.microsoft.com/hi-in/library/gg712320(en-us).aspx#BKMK_InstallConsole As a best practice, initiate the Configuration Manager console installation from a site server rather than the System Center 2012 Configuration Manager installation media. The site server installation method copies the Configuration…
The Configuration Manager Team is pleased to announce the release of the International version of Configuration Manger 2012 RC1! It is now available on Connect: https://connect.microsoft.com/ConfigurationManagervnext/Downloads/DownloadDetails.aspx?DownloadID=39749 If you are interested in testing Simplified Chinese or German please install the International build of Configuration Manger 2012 RC1. Be sure to install the same languages on your CAS and all primary sites. We look forward to your feedback for RC1! Please submit your feedback regularly using the TAP Feedback Form (https://connect.microsoft.com/ConfigurationManagervnext/feedback/CreateFeedbackForm.aspx?FeedbackFormConfigurationID=4213&FeedbackType=1). Thank you, Configuration Manager TAP Team
In this post,we will see how to get heartbeat discovery (DDR) time for the clients from specific collection using Reports.For troubleshooting client health issues ,we need to know when was the client last reported its DDR . If you need to create collection to list the clients that are not sending heartbeat DDR for past X days ,please refer http://eskonr.com/2011/11/sccm-collection-based-on-heartbeat-agent/ Report: SELECT Sys.Netbios_Name0 AS Name, case when Sys.Client0='1' then 'Yes' else 'No' end as 'Client Installed?', ad.AgentName, Min(ad.AgentTime) as 'Time Stamp', os.caption0 [OS] FROM v_r_system Sys INNER JOIN v_FullCollectionMembership fcm ON fcm.ResourceID =Sys.ResourceID inner join v_AgentDiscoveries ad ON ad.ResourceId=Sys.ResourceID inner join…