BookmarkSubscribeRSS Feed
LewG007
Calcite | Level 5

SAS Documentation on Enterprise Manager Repository Tables appears to be incomplete; there appears to be no data dictionary for the Tables within ACM, ART, and KIT.  I am most specifically interested in getting a description of the columns in ACM.HOSTPLATFORMS and ART.ARTIFACTUSAGEDETAILS.  I know these tables contain metrics on system utilization but there is no documentation on what each fields actually represents and what unit of measure is employed.  Some are more obvious than others -- I have to believe someone has documented these tables.  Any help greatly appreciated.

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hello @LewG007,

 

I think the information is there, although I agree you need to trace it back a little bit.

 

On the SAS Environment Manager Users Guide, you can find information of the tables, their meaining, and the columns, although not much information at the column level:

 

https://support.sas.com/documentation/cdl/en/evug/69029/PDF/default/evug.pdf

http://documentation.sas.com/?cdcId=evcdc&cdcVersion=2.5_M1&docsetId=evug&docsetTarget=n1fg7s4wpd6d9...

 

In other hand, you have documentation on all the reports generated by the ACM, APM, Audit, Datamart, Events/Alerts, etc, etc:

https://support.sas.com/rnd/emi/SASEnvMgr/EVSAF/Report_Center_Report_Listings.pdf

 

On the reports for the Datamart, I can see:

  • Data Mart ACM Listing: Data Mart ACM Listing of Tables, Attributes and Variables
  • Data Mart Artifact Listing:  Data Mart Artifact Listing of Tables, Attributes and Variables
  • Data Mart Proc Contents Full Listing: Data Mart Contents Listing

 

Those reports should be able to provide you with more information.

 

Please let us know if this information helped you.

 

Best regards,
Juan

 

 

 

 

 

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 714 views
  • 2 likes
  • 2 in conversation