Share via


SCRM 2006 SCRS_SoftwareInventory_Fact_View

SCRS_SoftwareInventory_Fact_View describes which files have been installed on each managed node.

SCRS_SoftwareInventory_Fact_View

Column Type Constraint Description

SoftwareInventoryEndTimeKey

int

Null values allowed

End of the time period that this row was valid. A NULL value indicates this row contains the current information. A non-NULL value indicates the last time that this row was known valid.

SoftwareInventoryEndDateKey

smallint

Null values allowed

End of the time period that this row was valid. A NULL value indicates this row contains the current information. A non-NULL value indicates the last date that this row was known valid.

SoftwareInventoryEndDateLineageKey

int

Null values allowed

Key that references the DTS lineage of the package that first detected that this file entry no longer existed in the SMS site database.

SoftwareInventoryStartTimeKey

int

Not Null

Start of the time period that this row was known valid. Indicates the time that this file was first inventoried by SMS.

SoftwareInventoryStartDateKey

smallint

Not Null

Start of the time period that this row was known valid. Indicates the time that this file was first inventoried by SMS.

SoftwareInventoryStartDateLineageKey

int

Not Null

Key that references the DTS lineage of the package that first detected that this file entry first appeared in the SMS site database.

SoftwareInventoryFileModifiedDate

datetime

Not Null

The last modified date and time stamp of the file in the operating system.

FileKey

int

Not Null

Foreign key that references a unique file in the File 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.

See Also

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures