Author Archives: shankarkannappa

SCCM server clients size and scale

Hi Below consolidated sheets can be used for reference for clients counts against each role. Server Role Child role support Connections Other Notes CAS 25 Primary 700,000 desktops (computers that run Windows, Linux, and UNIX) 25,000 devices that run Mac … Continue reading

Posted in SCCM server clients size and scale | Leave a comment

To Record all softwares machine wise

This query can be used to record all softwares machines against collection. NOTE :- This is very expensive query on your database, please use carefully. select v_R_System.Netbios_Name0‘Computer Name’, v_GS_OPERATING_SYSTEM.Caption0 ‘OS Details’, v_R_System.User_Name0 ‘User name’, v_R_System.User_Domain0‘User domain’, v_RA_System_IPAddresses.IP_Addresses0‘IP Address’, v_RA_System_IPSubnets.IP_Subnets0‘Subnet’, MAC.MAC_Addresses0 … Continue reading

Posted in Uncategorized | Leave a comment

Count of all softwares

The below query can be used find count of all the softwares registered in your hierarchy   select  app.DisplayName0‘Program name’,app.Version0,app.Publisher0 ‘Publisher’, COUNT (*)‘Count of Instance’ from v_Add_Remove_Programs app group by DisplayName0,app.Publisher0, app.Version0  

Posted in Uncategorized | Leave a comment

Server Rejected registration Request: 3 (ClientIDManagerStartup.log)

Issue :- we can see below error message in ClientIDManagerStartup.log Server Rejected registration Request: 3 Solution :- 1)    Identify the system. 2)    Delete the c:\windows\smscfg.ini file 3)    Run CCMDELCERT on the client 4)    Restart the SMS agent Host service. 5)    … Continue reading

Posted in Troubleshooting | Tagged | Leave a comment

Enable CLR in SQL 2008

 Problem :- You will find below error in statesys.log when your CLR of SQL is disabed. *** [42000][6263][Microsoft][ODBC SQL Server Driver][SQL Server]Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option. Solution :- First run … Continue reading

Posted in Troubleshooting | Tagged | Leave a comment

Track movies, mp3 and photos from SCCM 2007

Agenda Track movies, mp3 and photos from SCCM 2007 solution :- To acheive this, we need to enable inventory all requested format in SCCM 2007.   After enabling the above settings, use the below query to get the details. select … Continue reading

Posted in SMS Query | Tagged , , | Leave a comment

0x8004100e in distmgr.log

error CWmi::Connect(): ConnectServer(Namespace) failed. – 0x8004100e in distmgr.log If you see this error in distmgr.log on a DP, then take the following steps: 1. Windows server 2008 : Using Server manager, the the IIS 6 WMI Metabase compatibility feature and … Continue reading

Posted in Troubleshooting | Tagged , | Leave a comment