SCRM 2006 SCRS_AddRemoveProgram_Fact_View
SCRS_AddRemoveProgram_Fact_View lists the Add Remove Program (ARP) registered programs and the managed nodes on which they were installed.
SCRS_AddRemoveProgram_Fact_View
| Column | Type | Constraint | Description |
|---|---|---|---|
| ARPEndTimeKey | int | Null values allowed | End of the time period that this row was last known valid. A |
| ARPEndDateKey | smallint | Null values allowed | End of the time period that this row was known valid. A |
| ARPEndDateLineageKey | int | Null values allowed | Key that references the DTS lineage of the package that first detected that this ARP registry entry had been deleted from the SMS site database. |
| ARPStartTimeKey | int | Not Null | Start of the time period that this row was known valid. Indicates the time that the ARP registry entry was first inventoried by SMS. |
| ARPStartDateKey | smallint | Not Null | Start of the time period that this row was known valid. Indicates the date that the ARP registry entry was first inventoried by SMS. |
| ARPStartDateLineageKey | int | Not Null | Key that references the DTS lineage of the package that first detected that this ARP registry entry was inserted into the SMS site database. |
| ARPKey | int | Not Null | Foreign key that references a unique ARP registry entry in the ARP dimension. |
| LocationKey | int | Not Null | Foreign key that references a unique node location in the Node Location dimension. |
| NodeKey | int | Not Null | Foreign key that references a unique managed node in the Managed Node dimension. |
| UserKey | int | Not Null | Foreign key that references a unique user in the User dimension. |
| SMSSiteKey | int | Not Null | Foreign key that references a unique SMS site in the SMS Site dimension. |