mrobson316
Posts: 61
Score: 1 Joined: 11/17/2003 Status: offline
|
Figured this out, after much hair loss!! The 'All Unknown Computers' collection was defined as: select SMS_R_UNKNOWNSYSTEM.ResourceID,SMS_R_UNKNOWNSYSTEM.ResourceType,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name from SMS_R_UnknownSystem where Decommissioned = "0" Now, there are 4 entries in my UnknownSystem table, 2 decommissioned & 2 not. Once the collection was updated to include the 2 decommissioned entries I had in the table, it worked a treat. Strange.
|