Para verificar computadores inativos nas últimas 4 semanas.
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.UserAccountControl =
"4096"
Links úteis http://technet.microsoft.com/pt-br/library/cc730720(WS.10).aspx Erick Albuquerque | Moderator at Technet Brasil http://iisbrasil.wordpress.com/ | http://erickalbuquerque.com.br/ Twitter: @_ealbuquerque
Richard Mueller edited Revision 7. Comment: Fixed HTML <h> tag so header line shows in TOC
Luiz Henrique Lima Campos edited Revision 6. Comment: Adicionado TOC ao artigo.
Thiago Cardoso Luiz edited Revision 5. Comment: Incluido informações do SCCM
Erick Albuquerque edited Revision 4. Comment: Corrigindo formatacao.
Erick Albuquerque edited Revision 3. Comment: Atualizacao de assinatura