The ACM.FILEMOUNTS table contains usage data for the file mounts in your SAS environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

diskWrites1m	DiskQueue
diskReads1m	DiskSeviceTime
UsePercent	DiskReadBytes1m
TotFsFree	DiskWriteBytes1m
Capacity

ACM.GROUPINVENTORY Table

The ACM.GROUPINVENTORY table contains data about the resource groups that are defined in SAS Environment Manager. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following inventory columns:

id	desc
name

ACM.EVENTS Table

The ACM.EVENTS table contains data about the events that are logged by SAS Environment Manager.

By default, this table contains the following metric data columns:

msg	resource_id
fixdate	status
datetime	what
duration	who
eventType

ACM.HOSTPLATFORMS Table

The ACM.HOSTPLATFORMS table contains metrics for the platforms. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

MemFree	PercentUsedSwap
SwapUsed	ZombieProcesses
CpuUsage	PercentFreeSwap
LoadAverage1	RunningProcesses
CpuSoftLrq	TcpInErrs1m
CpuStolen	SwapPagesOut1m
SwapFree	TcpPassiveOpens1m
TotalProcesses	TcpRetransSegs1m
CpuLrq	Commit1m
CpuSys	Write1m
CpuNice	TcpEstabResets1m
TcpOutboundConnections	Read1m
CpuIdle	TcpOutRsts1m
LoadAverage2	TcpAttemptFails1m
MemUsed	TcpActiveOpens1m
ActualMemUsed	SwapPagesIn1m
PercentFreeMemory	Access1m
PercentUsedMemory	FileSystemReadsWrites1m
CpuUser	SwapTotal
LoadAverage0	ActualMemFree
CpuWait	NumCPUs
TcpInboundConnections	MemTotal

ACM.HTTPCHECKS Table

The ACM.HTTPCHECKS table contains metric data for HTTP checks of web services. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

AllInboundConnections	ResponseTime
InboundConnections	OutboundConnections
AllOutboundConnections	ResponseCode
StateTIME_WAIT	LastModified

ACM.IOMSERVERS Table

The ACM.IOMSERVERS table contains metric data for SAS IOM server resources. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

ServerState	NumProcesses
UnauthorizedAccesses	TotalClients1m
LastAccessState	CurrentClients
CurrentRunningServers_Local	Usage
ActivePeers	ResidentMemSize
CurrentPendingClients	MemSize
TotalWaitingTime	TotalTime1m
CurrentWaitingClients	UserTime1m
CurrentConnectedClients	SystemTime1m
TotalTimedOutClients	TimeInCalls1m
CurrentWaitingClients_Local	TotalCalls1m
CurrentRunningServers

ACM.MEASUREINVENTORY Table

The ACM.MEASUREINVENTORY table contains data about the measurements that are being performed.

By default, this table contains the following inventory columns:

measurement_id	UNITS
resource_id	type
enabled	MONITORABLE_TYPE_ID
NAME	category
PLUGIN	resource_desc
ALIAS	deleted

ACM.METADATASVRS Table

The ACM.METADATASVRS table contains metric data for the SAS Metadata Servers in the environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

serverState	ProcessShare
ProcessEnd_Last_Time	SystemTime
HighestThreadCount	health
ProcessStartTime	UserTime
CurrentClients	ProcessThreads
ProcessUserID	Usage
ProcessGroupID	ProcessMajorFaults
CounterJournalSpaceAvailable	TotalCalls1m
HighestMemoryUsage	CounterJournalDataWrite1m
CurrentThreadCount	ProcessPageFaults1m
CurrentMemoryUsage	CounterJournalTransProcessed1m
TotalClients1m	ProcessMinorFaults1m
ProcessResidentMemorySize	TimeInCalls1m
TotalTime	CounerJournalTransQueued1m
ProcessVirtualMemorySize

ACM.NETWORKINTERFACE Table

The ACM.NETWORKINTERFACE table contains metric data for the network performance in your environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

BitsIn1s	RxDropped1m
PacketsOut1m	BytesOut1m
BitsOut1m	TxCollisions1m
PacketsOut1m	TxDropped1m
RxErrors1m	BytesIn1m
TxErrors1m

ACM.RESOURCEINVENTORY Table

The ACM.RESOURCEINVENTORY table contains information about the resources in the SAS Environment Manager inventory. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following inventory columns:

name	invLevel
type

ACM.TCSSERVERMGRS Table

The ACM.TCSSERVERMGRS table contains metric data for tcServers in the system. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

rejectedSessions1m	activeSessions
sessionCreateRate	sessionExpireRate
sessionAverageAliveTime	processingTime

ACM.WEBAPPSERVER Table

The ACM.WEBAPPSERVER table contains metric data for SAS web applications. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

HeapMemoryMax	HeapMemoryUsed
HeapMemoryFree	DeadlocksDetected
PercentUpTimeinGarbageCollection	OpenFileDescriptionCount
Uptime	ThreadCount1m
HeapMemoryCommitted

ACM.WIPDATADB Table

The ACM.WIPDATADB table contains metric data for the SAS Web Infrastructure Platform. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.

By default, this table contains the following metric data columns:

DataSpaceUsed	seq_scan1m
idx_tup_read1m	idx_blks_read1m
tup_fetched1s	xact_rollbacks1s
numbackends	xact_commit1s
blks_hit_p	blks_read1s
granted_locks	tup_altered1s

Last updated: February 22, 2018