PENDING SCCM Win Server Collection

[itsmeroger2018]

Hi Experts
I want to create a Collection for windows server 2008 R2, Windows Server 2008 x64, Windows Server 2008 x86, Using the below query i can create Windows Server 2008 R2 Collection and if i change the version to 6.0 i will get windows server 2008 but how can i get collection for Windows Server 2008 32bit and 64bit.
select
SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System
where
SMS_R_System.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%6.1%"
=================================================================

2. In the above query is it possible to get ip address and domain name. Since i have SCCM server in Domain A and i am managing Domain B and Domain C servers from Domain A, please help me with the syntax

=================================================================

3. I have created Windows Server 2008 R2 collection using the above query and if need to delete it. Do i need to check the box delete each collection member from the database. if i check the box will it delete all my servers from sccm?

=================================================================
4. I want to export all the servers in this collection to CSV file since i can know on which servers SCCM agent is active or not, when i right click the collection and export i can see MOF File name(specify a file for this export). is it possible to export the servers from this collection to a csv file

 

[Garth]

You can get the OS version from SMS_G_System_SYSTEM view, using the systemtype column.

 

[itsmeroger2018]

Will the below syntax work
select
SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System
SMS_G_SYSTEM.view
where
SMS_R_System.OperatingSystemNameandVersion like "%Server%"
and
SMS_R_System.OperatingSystemNameandVersion like "%6.1%"

 

[Garth]

first add the g_system view just as you did to create this query from there you will find the systemtype column.