Hi, Is it possible in SCCM 2007 to write a query for a collection which can give me all the machines running on windows server along with hostname, IP address, location, domain and OS Version? Any help will be appreciable. Ta.Share your knowledge. It's a way to achieve immortality.

You don't want IP address in a report and Location can't be determine without more details. But this will get you started. http://tinyurl.com/3bfxxr2 http://www.enhansoft.com/

Just added some parameters to query mentioned by Garth...however I considered location as a AD site.. ------- Select DISTINCT SYS.Name0 AS [Server Name], ip_addresses0 = replace((select ip_addresses0 AS [data()] from v_RA_System_IPAddresses where v_RA_System_IPAddresses.resourceid = SYS.ResourceID FOR XML PATH ('')), ' ', ',' ), SYS.AD_Site_Name0, OSYS.Caption0 AS [Operating System], OSYS.CSDVersion0 AS [Service Pack], COM.Manufacturer0, COM.Model0 FROM v_R_System SYS INNER JOIN v_GS_COMPUTER_SYSTEM COM on SYS.ResourceID= COM.ResourceID INNER JOIN v_GS_OPERATING_SYSTEM OSYS on SYS.ResourceID= OSYS.ResourceID INNER JOIN v_FullCollectionMembership FCM ON SYS.ResourceID = FCM.ResourceID WHERE FCM.CollectionID = 'XYZ00100' Regards, Sachin

I excluded the IP address condition and based on SITE code found out the location of the servers. Thanks guys, appreciated.Share your knowledge. It's a way to achieve immortality.