Usuário com melhor resposta
Visualizar collections do Windows 2008 e Windows XP SP3

Pergunta
-
Respostas
-
Boa noite,
vc vai precisar criar 1 collection baseada numa query..
da 1 olhada nessas queries
para W2k8
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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%Server 6.0%"
XP sp3
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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%Workstation 5.%" and
SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 3"
[EDITADO]
Lista dos possiveis nomes:
Microsoft Windows NT Server 5.0 (Windows 2000)
Microsoft Windows NT Server 5.2 (Windows 2003 R2)
Microsoft Windows NT Server 6.0 (Windows 2008)
Microsoft Windows NT Workstation 5.1 (Windows XP)
Microsoft Windows NT Workstation 5.2 (Windows XP 64)
Microsoft Windows NT Workstation 6.0 (Windows Vista)
Microsoft Windows 7 Ultimate 6.1 (Windows 7)
espero ter ajudado,
Raphael - MCP/MCSA Security/MCSE Security/MCTS: SCCM & MDOP & W2k8/MCITP - http://www.dotnetwork.com.br- Marcado como Resposta Orlando Souza segunda-feira, 30 de março de 2009 14:37
Todas as Respostas
-
Boa noite,
vc vai precisar criar 1 collection baseada numa query..
da 1 olhada nessas queries
para W2k8
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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%Server 6.0%"
XP sp3
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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion like "%Workstation 5.%" and
SMS_G_System_OPERATING_SYSTEM.CSDVersion = "Service Pack 3"
[EDITADO]
Lista dos possiveis nomes:
Microsoft Windows NT Server 5.0 (Windows 2000)
Microsoft Windows NT Server 5.2 (Windows 2003 R2)
Microsoft Windows NT Server 6.0 (Windows 2008)
Microsoft Windows NT Workstation 5.1 (Windows XP)
Microsoft Windows NT Workstation 5.2 (Windows XP 64)
Microsoft Windows NT Workstation 6.0 (Windows Vista)
Microsoft Windows 7 Ultimate 6.1 (Windows 7)
espero ter ajudado,
Raphael - MCP/MCSA Security/MCSE Security/MCTS: SCCM & MDOP & W2k8/MCITP - http://www.dotnetwork.com.br- Marcado como Resposta Orlando Souza segunda-feira, 30 de março de 2009 14:37
-