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

Reporting rss

Orchestrator runbook for disabling AD account and moving the object in a different OU

(0)
December 15, 2016

Hi Guys , For those of you wanting to automate the decommission of servers or desktops or users you can use the following powershell script or runbook for disabling the AD account provided the service account has the rights to do disable the AD account and then move the account to the desired OU location… 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 ›

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