Here is another report today ,to list all the computers with their maintenance window setting and are part of which collection. The maintenance window information( collection ID,Description,time etc.) is available from SQL view called v_ServiceWindow. Below is the report to display all the computer with their maintenance window settings .You can also limit this collection to specific with the help of Prompts. select v_FullCollectionMembership.Name as Computername ,v_Collection.Name as CollectionName, v_ServiceWindow.Description as “Next Maintenance Window” from v_ServiceWindow inner join v_FullCollectionMembership on (v_FullCollectionMembership.CollectionID = v_ServiceWindow.CollectionID) inner join v_Collection on (v_Collection.CollectionID = v_FullCollectionMembership.CollectionID) order By v_Collection.Name
Author: Eswar Koneti
Report to list all the computer where the discovery agent time shows older than 30 days. This you can find out if you right click on the computer ,go to properties and see Agent name[0] (ex:SMS_AD_SYSTEM_DISCOVERY) respect to Agent time[0] for the above discovery method which will be the recent date. select a.Name0,b.AgentName,b.AgentTime from v_R_System a join v_AgentDiscoveries b on b.ResourceId=a.ResourceId where (AgentName like 'Heartbeat Discovery' and DATEDIFF(Day,AgentTime,Getdate())>=30 ) OR (AgentName like 'SMS_AD_SYSTEM_DISCOVERY_AGENT' and DATEDIFF(Day,AgentTime,Getdate())>=30 ) group by name0 ,agentname,AgentTime Order by Agentname You can add other discovery methods if you enabled in your site to the above report.
Today,I come across several advertisement status message IDs for a particular advertisement which can be viewed under system status--->advertisement status. I,Thought of sharing the excel sheet with you about all the advertisement status message ID’s with its description along with. This might be helpful in creating reports or collections with status message ID’s. Download the file from here http://wmug.co.uk/cfs-file.ashx/__key/CommunityServer.Components.PostAttachments/00.00.00.39.42/All-Advertisement-Staus-message-ID_2700_s-with-its-Discription.zip
I would like to list some of the basic SCCM Site hirarchy terminology that will be used in Planning and designing Primary and secondary sites and child sites as well.http://technet.microsoft.com/en-us/library/bb680436.aspx and http://technet.microsoft.com/en-us/library/bb693570.aspx Choose Between Primary Sites, Secondary Sites, and Branch Distribution Points What is Primary site : •It has its own site database •Primary site can Managed directly through Configuration Manager console installed on site server •Only a primary site can be a parent •First site installed must be a primary site What is Secondary site: •A secondary site, is a specific site type with limitations compared to a primary site and no demand…
Seen Lot of questions/help in many forums on the SCCM client issues like client is not reported in SCCM console ,site code unsuccessful, Client is installed but Console shows NO and other problems. Thought of preparing basic check list that will help configmgr guys to start troubleshooting the issue and fix the problem. Here is the check list which i have prepared to follow in brief when you do perform client installation using your method . There are a various types of Client deployment methods that are available to you when installing the client. Each has its advantages and disadvantages along with the need to…
If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and how do you get that. Right click on computer and go to resource explorer to identify the computer is Laptop or Desktop ? You can identify if the computer is Laptop or Desktop based on its chassis Types. Below are listed the Chassis types available to create SCCM collection or reports. For Laptops Chassis Types : 8 , 9, 10, 11, 12, 14, 18, 21,30,31,32 For Desktop Chassis Type : 3, 4, 5, 6, 7, 15, 16 For server Chassis …
How to Identify the computers which has What version of BITS(Background intelligence Transfer service) installed onto it. Background Intelligent Transfer Service (BITS) transfers files (downloads or uploads) between a client and server and provides progress information related to the transfers. You can also download files from a peer and it is Needed in Asynchronously transfer files in the foreground or background. Preserve the responsiveness of other network applications. Automatically resume file transfers after network disconnects and computer restarts. To determine the version of BITS on the client computer,check the version of QMgr.dll. To find the version number of the DLL:…
This article describes how to troubleshoot Microsoft Systems Management Server (SMS) 2003 Advanced Client and Microsoft System Center Configuration Manager 2007 Client installation issues when you use the Client Push installation method. There are some issues that can potentially occur when you deploy a client by using the Advanced Client Push install method. This article describes the installation process, some common issues and their solutions, and the tools and procedures for troubleshooting. Please note that the contents below reference the SMS 2003 Advanced Client and the Advanced Client Push Installation method but the same information is applicable to the System…