.

Wednesday, November 10, 2010

SCCM Report Non Client and AD computer Active. Caso do Dia

A query de ontem precisou de mais alguns filtros... mostrar o cliente ativo no Ad e tb as mqauinas que nao estao com o cliente Ativo.

Desenvolvi este report:
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.Client = 0 or SMS_R_System.Client is null ) and SMS_R_System.UserAccountControl = "4096"

No comments: