The MS SCOM adapter
can read performance data from the SQL Server Operations Manager data
warehouse. For the MS SCOM adapter, the relational database must be
a Microsoft SQL Server database. The MS SCOM adapter captures the
performance data from Windows environments.
The SAS IT Resource
Management adapter for MS SCOM supplies a data model and reports for
the System Center Management Pack for Windows Server Operating System.
Note: In SAS IT Resource Management
3.6 and later, the data model is updated to extract the 2003, 2008,
and 2012 version measurements. If you are using previous releases
of SAS IT Resource Management and are unable to migrate to SAS IT
Resource Management 3.6 or 3.7, you can use the %RMMSCOM macro. This
macro supports the extraction of the measurements of all other management
packs (from any management pack version later than 2003).
For information about
how to run the %RMMSCOM macro, see %RMMSSCOM.
The MS SCOM data source
is SQL Server Database. Therefore, you need to set up the ODBC server
definition in order to access the data from the database.
The data from the SQL
Server database is input directly into the Adapter Setup wizard.
Once ODBC setup is defined, you can create the database server and
set up the library that points to the database in SAS IT Resource
Management or in SAS Management Console. After the library is defined,
it can be specified as the input database to the MS SCOM staging transformation.