How to mange Client whith GUID is null and Client=NO !

[kimouneji28]

Hi all,

 

I created a collection with computers that have a NULL GUIDs :

 

All Clients with GUIDs is NULL : (303 PCs)

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.SMSUniqueIdentifier is NULL

 

 

And then i created a collection limited to this collection whith client = no : (279 PCs)

 

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 Client is NULL and OperatingSystemNameandVersion like "%Workstation%"

 

Finally, I have 303 PCs with GUIDs is NULL including 279 that are Client = NO !!!!

 

how to manage that?