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

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,
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 you want desktops and servers both you can modify the query accordingly .



Tagged as: , , , ,

Categorised in: Reporting, Reporting Services, SCCM, SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


%d bloggers like this: