About SAS Environment Manager Data Mart Tables

The following topics contain an overview of the use and contents of the tables in the SAS Environment Manager Data Mart. Although the topics list the columns in the tables that contain metric or inventory information, the tables also contain other columns that are not listed. Those columns provide information such as the date and time that a metric was recorded, the ID and name of the involved resource, and the time zone offset and shift for when the metric was recorded.
The columns listed for each table represent the metric and inventory data that is collected by default. If you use SAS Environment Manager to start collecting data for a metric that is not currently activated, a column for the new metric appears in the appropriate table. If you stop collecting data for a metric, the corresponding column remains in the data table because the SAS Environment Manager Data Mart retains 45 days of historical data. The column for the deactivated metric remains in the table even after 45 days have passed, although the column is blank.
Last updated: February 22, 2018