NEW How to list all servers in the environment in a search - in SCCM

[Naldo Silva]

Hi Prajwal
What query should I do to list all servers in devices in the environment?

Tks

 

[Garth]

Hi Prajwal
What query should I do to list all servers in devices in the environment?

Tks

What do you have for a query now? what is not working for you?

 

[Naldo Silva]

What do you have for a query now? what is not working for you?

Hello Garth
I need to create a collection where I list all the servers in the environment.
How do you create this type of collection?
What do you have for a query now? what is not working for you?

Today my search also brings all workstations, I need to filter only the servers



Tks

 

[Garth]

Today my search also brings all workstations, I need to filter only the servers



Tks

Exactly what does your query look like?

 

[pauljebastin]

Hi Prajwal
What query should I do to list all servers in devices in the environment?

Tks

You can use below query to create a collection to list all the servers:

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_System.OperatingSystemNameandVersion,
SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client
from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "Server%"
OR SMS_R_System.OperatingSystemNameandVersion like "%Server%"

 

[Naldo Silva]

Você pode usar a consulta abaixo para criar uma coleção para listar todos os servidores:

selecione SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_System.OperatingSystemNameandVersion,
SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client
de SMS_R_System onde SMS_R_System.OperatingSystemNameandVersion como "Server%"
OU SMS_R_System.OperatingSystemNameandVersion como "%Server%"

Obrigado pela ajuda Pauljebastin