Category: SCCM

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 […]

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 […]