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... Continue Reading →
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... Continue Reading →
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... Continue Reading →