Hi everyone ,
A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database .
from v_RA_System_IPAddresses AS IP
inner join v_R_System AS S
where operatingSystem0 like ‘%Server%’;
My requirement was for servers , but if you want desktops and servers both you can modify the query accordingly .