#SolutionArchitect#Freelancer#SCCM Expert#Citrix Expert #Public and Private Cloud Consultant#SQL Expert#Corporate Trainer #Automation Consultant

Tag: Reporting

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 ›

Translate