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

Reporting Services rss

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

(0)
December 14, 2016

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 ›

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 ›

Upgrading to IE 11 through SCCM using Batch File

Hi Guys , For those of you who have issues in their environments upgrading to IE 11 and also want to make sure that the respective updates for IE get installed with the IE installation since now the updates being offered for IE 11 are coming as cumulative updates  . That means great news for… Read More ›

Translate