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 you want desktops and servers both you can modify the query accordingly .
Categories: Reporting, Reporting Services, SCCM, SQL
sukhdeepblogs
You made some decent factors there. I looked on the internet for the problem and found most people will go along with together with your website.
LikeLiked by 1 person
Good blog! I truly love how it is simple on my eyes and the data are well written. I’m wondering how I could be notified whenever a new post has been made. I’ve subscribed to your RSS feed which must do the trick! Have a great day!
LikeLiked by 1 person