Author Archives: shankarkannappa

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

SCCM collection for systems with IE 9

Use the below Query to create collections for the systems with Internet explorer 9 Note :- This query will work only, when you have enabled inventory collection for *.exe files. select distinct SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_R_System.LastLogonUserDomain, SMS_R_System.SMSAssignedSites, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner … Continue reading

Posted in SMS Query | Tagged , | Leave a comment