Workstation Status Class

This class contains information about when inventory was last collected on a client computer.

Table B.58 Workstation Status Class (SMS_G_System_WORKSTATION_STATUS)

PropertyData typeExampleNotes
GroupIDuint321Key. Within one ResourceID (one SMS client), GroupID distinguishes one instance of a class from another. Objects with the same ResourceID and GroupID are “deltas” of one another, describing the same hardware inventory instance at different points in time.
LastHardwareScandatetimeSee “Date and Time Formats” at the beginning of this appendix.Indicates the date and time that SMS last inventoried the client computer’s hardware.
LastSoftwareScandatetimeSee “Date and Time Formats” at the beginning of this appendix.If present, indicates the date and time that SMS last inventoried the client computer’s software.
ResourceIDuint323Key. Indicates an identifier for the resource that is unique to this site. System Resource Type inventory items with the same ResourceID were all discovered on the same SMS client.

A ResourceID is an integer generated for the sake of SQL. It is not unique outside the site and should be used only for short-term querying purposes.
RevisionIDuint3293Objects with the same ResourceID and GroupID are deltas, differentiated from one another by RevisionID number. The highest number is the most recent update.
TimeStampdatetimeSee “Date and Time Formats” at the beginning of this appendix.Indicates the creation time (revision time) of this delta.