APM Tables

These tables are located in the directory [levelroot]/Web/SASEnvironmentManager/emi-framework/Datamart/artifacts.

ARTIFACT.RELATIONSHIPS Table

The ARTIFACT.RELATIONSHIPS table contains information about the relationships between artifacts that are defined in other tables.
By default, this table contains the following metric data columns:
artifact1 relationshipSubType
artifact2 distance
relationshipType _loadtm

ARTIFACT.ARTIFACTS Table

The ARTIFACT.ARTIFACTS table contains information about the artifacts (such as libraries, directories, and stored processes) in your environment.
By default, this table contains the following metric data columns:
ID type
Name _loadtm
Desc path
Created physicalPath
Updated

ARTIFACT.ARTIFACTSPHYSICALLOCATION Table

The ARTIFACT.ARTIFACTSPHYSICALLOCATION table contains information about the physical location of artifacts.
By default, this table contains the following metric data columns:
ID type
Name _loadtm
Desc path
Created physicalPath
Updated directoryName

ARTIFACT.ARTIFACTUSAGEDETAILS Table

The ARTIFACT.ARTIFACTUSAGEDETAILS table contains usage information about artifacts.
By default, this table contains the following metric data columns:
HostName elapsedUserCPUTime
TotalIOCount hour
TotalMemoryUsage level
_loadtm measurementSubType
artifact measurementType
artifactType minute
client_context parentUsage
currentUsage sourceId
datetime startSystemCPUTime
datetimeMinute startUserCPUTime
dayOfMonth stopSystemCPUTime
dayOfWeek stopUserCPUTime
elapsedSystemCPUTime subType
elapsedTime type
elapsedTotalCPUTime usageId

ARTIFACT.ARTIFACTUSAGESESSIONS Table

The ARTIFACT.ARTIFACTUSAGESESSIONS table contains usage information about artifacts in a session.
By default, this table contains the following metric data columns:
HostName hour
_loadtm level
artifact measurementType
artifactType minute
client_context parentUsage
currentUsage sourceId
datetime stopdt
datetimeMinute subType
dayOfMonth type
dayOfWeek usageId
elapsedTime

ARTIFACT.AUDIT_ACCESSC Table

The ARTIFACT.AUDIT_ACCESSC table contains audit records for object access events.
By default, this table contains the following metric data columns:
A_ACT_Message A_ObjType
A_ActiveUserid A_RecordEvent
A_IdentityName A_RecordT
A_Level A_Thread
A_ObjID Log_Line

ARTIFACT.AUDIT_ADMUSER Table

The ARTIFACT.AUDIT_ADMUSER table contains audit information for the administrative user activities.
By default, this table contains the following metric data columns:
A_ActiveUserid A_Thread
A_Level Log_Line
A_RecordT

ARTIFACT.AUDIT_GROUP Table

The ARTIFACT.AUDIT_GROUP table contains audit information for identity groups.
By default, this table contains the following metric data columns:
A_ActiveUserid A_ObjID
A_IdentityName A_ObjType
A_IdentityTargetName A_RecordEvent
A_IdentityTargetObjID A_RecordT
A_IdentityTargetType A_Thread
A_IdentityType Log_Line
A_Level

ARTIFACT.AUDIT_TRANSACTIONS Table

The ARTIFACT.AUDIT_TRANSACTIONS table contains audit information for transactions.
By default, this table contains the following metric data columns:
A_ACT_Message A_MetaUserid
A_ActiveUserid A_ObjID
A_AuthDomain A_ObjType
A_ClientID A_PermissionName
A_ClientIPAddr A_PermissionType
A_ClientPort A_RecordEvent
A_IdentityName A_RecordT
A_IdentityTargetName A_Repository
A_IdentityTargetObjID A_Thread
A_IdentityTargetType Client_Context
A_IdentityType Log_File
A_Level Log_Line

ARTIFACT.AUDITACCESSCONTROLDETAIL Table

The ARTIFACT.AUDITACCESSCONTROLDETAIL table contains detailed audit information about access requests.
By default, this table contains the following metric data columns:
A_ActiveUserid Insert
A_ClientID Read
A_ObjID ReadMetadata
Administer References
Alter_Table Select
CheckInMetadata Update
Create User_Group
Create_Table Write
Delete WriteMemberMetadata
Drop_Table WriteMetadata
Execute

ARTIFACT.AUDITIM Table

The ARTIFACT.AUDITIM table contains audit information recorded by time.
By default, this table contains the following metric data columns:
A_ActiveUserid A_ObjID
ActionID Path
Action Map
ActionType resourceType
SessionID webApp

ARTIFACT.DTINFOALL Table

The ARTIFACT.DTINFOALL table contains information about log file access.
By default, this table contains the following metric data columns:
ArchiveLoc file
_loactm maxDT

ARTIFACT.LIBRARIES Table

The ARTIFACT.LIBRARIES table contains information about the SAS libraries in the environment.
By default, this table contains the following metric data columns:
libname orapath
ServerContext host
AuthDomain install_loc
port LASR_Name
tag desc
hpath libref
opt engine
sqldatasrc

ARTIFACT.SERVERTYPEBYUSER Table

The ARTIFACT.SERVERTYPEBYUSER table contains information about server access.
By default, this table contains the following metric data columns:
ServerType description
ServerUser sourceId
dayOfMonth user
dayOfWeek

ARTIFACT.SERVERUSAGEBYUSER Table

The ARTIFACT.SERVERUSAGEBYUSER table contains usage information about SAS servers recorded by user.
By default, this table contains the following metric data columns:
ServerType description
ServerUser sourceId
dayOfMonth user
dayOfWeek