%RMMSSCOM

Special Considerations for the Amazon Web Services (AWS) Management Pack

%RMMSSCOM Example 1 for the Microsoft SQL Server 2008 R2 Management Pack

%RMMSSCOM Example 2 for the AWS Management Pack 2012 Management Pack

%RMMSSCOM

%RMMSSCOM reads a management pack file in XML format and creates table and column metadata and formats for the SAS IT Resource Management MS SCOM adapter.

A management pack is a grouping of classes, monitors, object discoveries, rules, tasks, views, and knowledge that provide System Center Operations Manager (SCOM) management servers and agents with the information necessary to monitor an application.

If the management pack is sealed, you need to unseal it first to get the XML file.

Note: Run this program only after you have created an IT data mart and a job that contains an SCOM transformation.

Special Considerations for the Amazon Web Services (AWS) Management Pack

The AWS Management Pack enables Microsoft System Center Operations Manager to access your AWS resources (such as instances and volumes) so that it can collect performance data and monitor those resources. The AWS Management Pack is an extension to MS SCOM. Two versions of the AWS Management Pack are available:

System Center 2012 - Operations Manager
System Center Operations Manager 2007 R2

For information about using %RMMSSCOM to collect AWS Management Pack 2012 data and create the staged table metadata from it, see %RMMSSCOM Example 2. After the program executes, check the SAS log for errors. If executed successfully, the program produces a report of tables and metadata for the AWS 2012 version.

Report Generated by %RMMSSCOM

Tip

Open the existing staging job in the SAS IT Resource Management client to ensure that the staged table for the AWS 2012 version was created.

%RMMSSCOM Syntax

%RMMSSCOM(
MPFILE=path-and-filename-of-the-management-pack
,METAPASS=user-password
,METASERVER=name-of-metadata-server
,METAUSER=user ID
,OUTPUTFILEPATH=path-of-output-text-file
<,APPSERVER=name-of-application-server>
<,FILEDEVICE=type-of-device>
<,FILENOOFVOLUMES=number-of-volumes>
<,FILESPACEPRIMARY=primary-space-allocation>
<,FILESPACESECONDARY=secondary-space-allocation>
<,JOBID=metadata-id-of-staging-job>
<,CREATEMETADATA=Yes | No>
<,METAPORT=metadata-server-port>
<,METAREPOSITORY=name-of-metadata-repository>
);

%RMMSSCOM Required Arguments

MPFILE=path-and-filename-of-the-management-pack

specifies the path to the management pack.

METAPASS=user-password

specifies the password to use in authenticating the user ID to the metadata server. Do not enclose the value for this parameter in quotation marks.

You can use the PWENCODE form of the password. For more information about the PWENCODE procedure, see the Base SAS Procedures Guide.

Tip

If you use the form of the password, be sure to handle embedded braces ({}) carefully. Do not confuse them with square brackets ([]).

METASERVER=name-of-metadata-server

specifies the name of the metadata server. Do not enclose the value for this parameter in quotation marks.

METAUSER=user-ID

specifies the user ID that is to access the metadata server. The user must be able to read and write metadata in the IT data mart. Do not enclose the value for this parameter in quotation marks.

OUTPUTFILEPATH=path-of-output-text-file

specifies the path for a temporary text file called Temp_RMMSCOM.txt. This file will contain the data that is retrieved from the management pack.

%RMMSSCOM Options

APPSERVER=name-of-application-server

specifies the name of the application server.

The default value for this option is SASITRM.

CREATEMETADATA=Yes | No

specifies that the macro is to create the metadata for the staging tables.

The default value for this option is No, which means do not create the metadata. The value No only produces a report of the metadata that would have been created.

FILEDEVICE=type-of-device

specifies the type of device. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.

FILENOOFVOLUMES=number-of-volumes

specifies the number of volumes. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.

FILESPACEPRIMARY=primary-space-allocation

specifies the primary space allocation. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.

FILESPACESECONDARY=secondary-space-allocation

specifies the secondary space allocation. This value is required only if the library and tables are going to be stored on z/OS with a traditional file system.

JOBID=metadata-id-of-staging-job

specifies the metadata ID of the staging job. The metadata-ID should be in the format Axxxxxxxx .Zyyyyyyyy and follow these specifications:

Axxxxxxxx is any set of eight alphanumeric characters preceded by the character “A.”
Z is any alphabetic character.
yyyyyyyy is any set of eight alphanumeric characters.

Note: This option is required if CREATEMETADATA is set to Yes.

METAPORT=metadata-server-port

specifies the port of the metadata server.

The default value for this option is 8561. Do not enclose the value for this parameter in quotation marks.

METAREPOSITORY=name-of-metadata-repository

specifies the name of the metadata repository that contains the IT data mart. Do not enclose the value for this parameter in quotation marks.

The default value for this option is Foundation.

%RMMSSCOM Example 1 for the Microsoft SQL Server 2008 R2 Management Pack

This example reads the Microsoft SQL Server 2008 R2 management pack in XML format and creates table and column metadata and formats for the MS SCOM adapter.

%rmmsscom(
          createMetadata=Y,
          jobID=A5016lHR.BP0001MU,
          metaserver=myServer,
          metauser=myUserid,
          mpfile=c:\msscom\SQLServer2008R2.xml,
          outputfilepath=c:\temp
         );

%RMMSSCOM Example 2 for the AWS Management Pack 2012 Management Pack

This example reads the AWS Management Pack 2012 management pack in XML format and creates table and column metadata and formats for the MS SCOM adapter.

%rmmsscom(
          MPFile="C:\SCOMTEST\aws\Microsoft.AWS.WebServices.2012.Monitoring.xml",
          outputFilePath=C:\SCOMTEST\aws,
          createMetadata=Y,
          jobID=A52ZNBYU.BS000348,
          metaserver=myServer,
          AppServer=SASApp,
          metaport=8561,
          metauser=myUserid,
          metapass=myPassword
         );