• Contents
  • About
  • Accessibility
  • About This Book
  • Introduction
    • General Overview
      • Introduction to SAS IT Resource Management
      • Lockdown Feature
      • Architecture and Basic Principles for Data Administrators
      • How to Locate Documentation
      • National Language Support (NLS)
      • Terminology Changes
    • Preparing to Work with the SAS IT Resource Management Client
      • Working with SAS Management Console
      • Working with SAS Enterprise Guide
      • Working with Metadata
      • Additional Requirements for z/OS
    • Working with the SAS IT Resource Management Client
      • Overview of the SAS IT Resource Management Client
      • Features of the SAS IT Resource Management Client
      • Working with Wizards
      • SAS IT Resource Management Transformations
      • Icons for SAS IT Resource Management Objects
  • Accessing and Processing IT Data
    • IT Data Mart
      • About the IT Data Mart
      • Working with IT Data Marts
      • Importing, Exporting, and Promoting Metadata
    • Adapters
      • About Adapters
      • Working with Template Tables
      • Maintaining Template Tables and Staged Tables Based on Adapter Changes
    • Formulas
      • About Formulas
      • Working with Formulas
    • Staging the Data
      • About Staging the Data
      • Working with Staging Transformations
      • Working with Staged Tables
      • Columns in Staged Tables
      • Computed Columns in Staged Tables
      • Staging VMware Data Using Local Time
      • Understanding External Names of Staged Tables and Columns
      • How to Add Columns to Existing MXG Staged Tables
      • How to Use Imported Columns
      • Insufficient Disk Space
    • Aggregating the Data
      • Overview of the Aggregation Transformation
      • About Aggregation Tables
      • Preparing to Create an Aggregation Table
      • Creating an Aggregation Table with the Simple Aggregation Table Wizard
      • Creating Aggregation Tables with the Summarized Aggregation Table Wizard
      • Creating Aggregation Tables with the Aggregation through the Template Wizard
      • Cloning an Aggregation Table
      • Adding a New Column to an Aggregation Table
      • Deleting an Aggregation Table
      • Editing or Modifying an Aggregation Table
      • Publishing an Aggregation Table as Template
      • Purging Contents of an Aggregation Table
      • Renaming an Aggregation Table
      • Indexing an Aggregation Table
      • Working with Aggregation Transformations
      • Working with Aggregation Transformation Filters
    • Exception Analysis Processing
      • Overview of Exception Analysis Processing
      • How to Use the Exception Analysis Feature
      • How Are Exceptions Evaluated?
      • About the Exception Transformation
      • Working with the Exception Transformation
      • Defining an Exception Definition with the New Exception Definition Wizard
      • Exception and Exception Condition Tables
      • Examples of the Exception Analysis Process
    • Adapter Setup Wizard
      • About the Adapter Setup Wizard
      • Using the Adapter Setup Wizard
      • What Does the Adapter Setup Wizard Create?
      • Domain Categories
      • Deploy and Run Jobs That the Adapter Setup Wizard and Add Domain Category Wizard Create
    • Add Domain Category Wizard
      • About the Add Domain Category Wizard
      • Using the Add Domain Category Wizard
      • What Does the Add Domain Category Wizard Create?
    • Information Maps
      • About Information Maps
      • About Information Map Transformations
      • User-Specified Information Map Transformations
      • Information Map Objects That Are Generated by the Adapter Setup Wizard and the Add Domain Category Wizard
      • Working with Information Map Filters
      • Using SAS Information Map Studio
      • Troubleshooting Information Maps Problems
    • User-Written Staging Code
      • User-Written Staging Transformations
      • Guidelines for Processing Data with User-Written Staging Transformations
      • Working with User-Written Staging Transformations
      • Using the Additional Generated Code
      • What Are the Properties of the User-Written Staging Transformation?
    • Jobs
      • Jobs That Process IT Data
      • Working with Jobs
      • Running Jobs
      • Running an “Overall” Job with the %RMRUNETL Macro
      • Allocating the Raw Data File Externally
  • Appendixes
    • SAS IT Resource Management Components
    • Data Sources Supported by SAS IT Resource Management Adapters
      • Data Sources Supported by SAS IT Resource Management Adapters
      • Supported Adapters
      • MXG Adapters — Accessing Raw Data
      • Amazon CloudWatch — Accessing Raw Data
      • BMC Perf Mgr — Accessing Raw Data
      • CSV Adapter - Accessing Raw Data
      • DT Perf Sentry — Accessing Raw Data
      • Ganglia — Accessing Raw Data
      • HP Perf Agent — Accessing Raw Data
      • RRDtool — Accessing Raw Data
      • SAR — Accessing Raw Data
      • SNMP — Accessing Raw Data
      • Web Log — Accessing Raw Data
      • Database Adapters: HP Reporter, MS SCOM, SAP ERP, SAS EV, and VMware
      • HP Reporter - Accessing Data
      • MS SCOM - Accessing Data
      • SAP ERP - Accessing Data
      • SAS Environment Manager (SAS EV) — Accessing Data
      • VMware vCenter - Accessing Data
      • Working with the VMware Lookup TableVMware
      • VMware Data Acquisition Jobs
      • Working with IBM SMF Custom Tables
      • Working with MXG Code to Stage Data
      • How MSU and MIPS Columns Are Included in Staged Tables for the SMF Adapter
    • Staging Parameters
      • Staging Parameters
      • Staging Parameters for Supported Adapters
      • User-Written Staging Parameters
    • Jobs That the Adapter Setup and the Add Domain Category Wizards Create
    • Duplicate-Data Checking
      • Duplicate-Data Checking Overview
      • How Is Data Checked for Duplicates?
      • Control Data Sets for Duplicate-Data Checking
      • Working with Duplicate-Data Checking Macros
      • How to Implement Duplicate-Data Checking from a Staging Transformation
      • Additional Details for the MS SCOM and HP Reporter Database Adapters
      • Duplicate-Data Checking for User-Written Staging Code
      • Examples
    • Data Model
      • Overview of the SAS IT Resource Management Data Model
      • Data Model Adapter and Domain Category Specifications
      • What Are Key Metrics?
      • Key Metrics for the Server Performance Domain Category
    • Naming Standards
      • About Naming Standards for SAS IT Resource Management Objects
      • Naming Standards and Location of Objects
    • Macros
      • Introduction to the Macros in SAS IT Resource Management
      • %RMDELETE
      • %RMDELPVT
      • %RMDMPATH
      • Duplicate-Data Checking Macros
      • %RMMSBMCP
      • %RMMSDTPS
      • %RMMSSCOM
      • %RMMSSNMP
      • %RMPROINT
      • %RMRUNETL
      • %RMVINST
      • Backup and Recovery Macros
      • Macros to Handle Large Data Volumes
      • Macros for SAS Visual Analytics Integration
    • Best Practices and Troubleshooting Tips
      • How to Back Up SAS IT Resource Management
      • How to Backload Raw Data
      • How to Set the Logging Level for the Web Application Server
      • Debugging Problems in SAS IT Resource Management
      • Use the Apply Button to Update Metadata
      • Tips for Working with the IT Data Mart
      • Tips for Working with Aggregations
      • How to Maintain the Latest Raw Value in an Aggregation Table
      • Tips for Working with Information Maps
      • Tips for Configuring and Administering SAS IT Resource Management
      • Handling Holidays
      • Performance Issues
    • Method for Overriding Locations at Execution Time
      • Overriding Locations at Execution Time
      • Processing Large Files of Data
      • Processing Multiple Files of Data
      • Overriding Locations in the Information Map Transformation
      • Overriding Locations in the Exception Transformation
      • Overriding Locations in the Performance Report Transformation
    • Calculations Performed by SAS IT Resource Management
    • RRDtool for Open-Source Management Tools
    • Using a Command Line to Deploy Jobs
    • Working with SAS Visual Analytics in SAS IT Resource Management
      • Working with SAS Visual Analytics in SAS IT Resource Management
      • Using SAS Visual Analytics Designer with SAS IT Resource Management Data Sources
      • SAS Visual Analytics Macros
  • Recommended Reading


ProductRelease
SAS IT Resource Management
Type
Administration
Copyright Date
February 2016
Last Updated
16Feb2016