Configuration Manager 2007: The flag's meaning for the records in Collection
Client: YES/NO
This flag is used to flag whether the ConfigMgr client registered on the site server. In ConfigMgr 2007, the RDR or UDR files can mark this flag.
RDR and UDR files are sent to the assigned MP, it means if the client belongs to the second site boundaries, the RDR and UDR files would still send to its parent site MP directly.
Assigned: YES/NO
This flag is marked based on the boundaries setting. The DDR file is used to update this flag.
Site Code: Primary site code/Secondary site code
DDR would update this flag. For the client belongs secondary site boundaries, before the 1st heartbeat DDR inserts into the database, other discovery method can mark the site code as the secondary site code. Once the heartbeat DDR file comes, it would mark as its assigned site(it is always Primary Site).
Obsolete: Yes/No
A record that is marked obsolete typically was superseded by a newer record for the same client. The newer record becomes the client's current record, and the older record becomes obsolete.
Normally, it happens when the same machine reinstalled the OS or the same machine’s hardware ID changes.
Active: Yes/No
If a client computer is marked as obsolete, this state is set to No.
Blocked:Yes/No
This flag is set manually, used to block the client to server data, not block the client downloads the policy from the server.
Approval: Yes/No
Only the clients that are approved can receive policies containing sensitive data.
Here comes more information.