#SCCM Expert #Private Cloud Consultant#SQL Expert#Corporate Trainer #Automation Consultant

SCCM rss

Installing SCCM Clients using PSEXEC

(2)
April 12, 2017

  Hi Guys , Today i will be talking about the tool PSEXEC . This is a very import tool to do things remotely . First let’s see how to set up PSEXEC .We can install any software remotely through PSEXEC but for this blog we are discussing install of SCCM client. This requirement came… Read More ›

Unable to install SCOM 2016 agent through SCCM

Unable to install SCOM 2016 Agent. Getting the following error: “MainEngineThread is returning 1603” We will get the following error in the MOMAgentinstall.log Property(S): OpInsightsUnknownErrorDlg_Text = Unknown error was encountered during setup. Please check log file: (%temp%\MonitoringAgent.log). Property(S): OpInsightsServerKeyValidationErrorDlg_Text = The workspace key could not be validated.  The error returned from the service was: Property(S):… Read More ›

Using Update Statement in SQL when using joins

Hi everyone, Let’s discuss the SQL update statement when using joins in SQL. Many of us try to make this complicated when we try to use update statement when dealing with two tables using joins. Please follow along for this short SQL lesson on UPDATE USING JOINS. For example: Suppose we have 2 tables that… Read More ›

System Center Orchestrator runbook for removing SCCM records

Hi Everyone , Hope you are doing great! Today i am writing about an scenario  which talks about automating SCCM record removal through Orchestrator . The runbook once  created will look like the following : You can use the following Powershell script to remove the record from the database : $error.clear() powershell{ cd “D:\Program Files\Microsoft… Read More ›

SQL query for SCCM to pull out Hostname, Ip Address , OU location and Operating system

Hi everyone , A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . Select s.Netbios_Name0,ip.IP_Addresses0, s.Distinguished_Name0,s.operatingSystem0, s.Operating_System_Name_and0 from v_RA_System_IPAddresses AS IP inner join v_R_System AS S on ip.ResourceID=s.ResourceID where operatingSystem0 like ‘%Server%’; My requirement was for servers , but if… Read More ›

SCCM report to show disk utilization for all endpoints

Hi There , Yesterday i had a requirement to go through the  disk space utilization for all the servers in our environment to keep a track before year end . Now remember we are not looking for a report that shows low disk space which you can readily get through SCCM reports . This report… Read More ›

Deploying MS Office 2010 through SCCM 2012 SP1 R2:

Deploying Office 2010 through SCCM 2012 SP1 R2: Hi All, I was going through the office installation today with some custom requirements where we want to deploy Office 2010 with the following components: Excel Word PowerPoint I will be deploying the Volume License edition of Microsoft Office 2010 Standard with SP1. You will need the… Read More ›

Updates not getting applied to OS after reboot

Hello Everyone , Today i will talk about an issue which is very common if you are dealing with patch management . Ever seen that you apply software updates to a system and after reboot when the system comes up we see the below given screen on the system . This means that anything applied to… Read More ›

Unable to see software updates in software center “Sources are not current”

Hi Everyone , Most of us have seen these lines in scanagent.log“Sources are not current” on the client machines . We tend to get confused and fail to understand where the issue is happening . So even if you try to reinstall the client , you will not be able to see any update  in… Read More ›

SQL reporting Services not working and we get access denied error”0x80070005″

Many a times we have seen that when we try to install SQL reporting services to integrate with the Configuration Manager we get an access denied error message on the wbemtest like the one in the following screenshot and the reason for the same is wmi namespace could not be connected remotely from SCCM server to… Read More ›

Translate