Configuring SPF and Windows Azure Pack for IaaS usage and metering

After configuring VMM and OM for IaaS usage and metering in the previous blog post (here) it’s now time to configuring SPF and Windows Azure Pack to import Usage data from Operations Manager Data Warehouse into Windows Azure Pack (WAP) Usage Database.

The series includes the following posts:

Service Provider Foundation has a usage module that WAP uses to collect data from Operations Manager data warehouse. In this blog post we will go over how to configure the following:

  • Configure SPF to extract data from Operations Manager Data Warehouse
  • Configure WAP to connect to SPF Usage Service
  • Verify that Data is being stored in the WAP usage database

The following things must be configured before starting on this guide

The Environment:

Operations Manager Server: OM01.contoso.com
Operations Manager Database Server: DB04.contoso.com
VMM Server VMM01.contoso.com
SPF Server VMM01.contoso.com
WAP Server WAP01.contoso.com
WAP Database Server: DB02.contoso.com
Service Reporting Server VMM01.contoso.com
Service Reporting Database DB06.contoso.com
SharePoint Server SP01.contoso.com

Configure SPF to extract data from Operations Manager Data Warehouse

The usage module in SPF needs to be configured using PowerShell. With SPF there is a set of commands that enables you to configure settings in SPF. By using these commands you can tell SPF where the Operations Manager Server and Data Warehouse database are located.

To configure SPF Usage do the following:

1. Logon to the SPF server as an Administrator

2. Open IIS Manager Console

3. Select Application Pools

4. Check the identity for the Usage Application (eg. Contoso\!spf)

image 

5. Close the IIS console

6. Open Computer Management Console > Local Users Groups > Groups

7. Verify that the user you will later use to query SPF for data from WAP is member of the local SPF_Usage users group, if not add the user to the Group. In this scenario I’m using SPF Usage Application Identity user. Any other user can be used as long as it’s member of the Usage security Group.

    image

8. Open PowerShell console with administrative privilege

9. Run the following commands (change values in “<>” with your own values):

    Import-module spfadmin

    # Provide server name to the OM DW SQL instance

    $OMDWSqlServer = "<SCOM DW DB SQL Server>”

    Example: $OMDWSqlServer = "DB04.contoso.com"

    # Provide server name to the OM RMS Server

    $OMServer = "<SCOM RMS Server Name>"

    Example: $OMServer = "OM01.contoso.com"

    # Register the SCOM Data Warehouse instance to SPF usage metering

    $stamp = Get-SCSPFStamp;

    $server = New-SCSPFServer -Name $OMServer -ServerType OMDW -Stamps $stamp[0];

    For SPF Preview use the following command:

    $setting = New-SCSPFSetting -Name $OMDWSqlServer -SettingString "Data Source=$OMDWSqlServer;Initial Catalog=OperationsManagerDW;Integrated Security=True" -SettingType DatabaseConnectionString –Server $server

    For SPF RTM use the following command:

    $setting = New-SCSPFSetting -Name $OMDWSqlServer –Value "Data Source=$OMDWSqlServer;Initial Catalog=OperationsManagerDW;Integrated Security=True" -SettingType DatabaseConnectionString –Server $server

    Example:

    image

    To verify if the setting has been applied to SPF run the following command:

    Get-SCSPFSetting

    image

10. Logon to the SQL Server that hosts the SCOM DW DB as SQL Admin

11. Start SQL Management Studio

12. Select Security > Logins

13. Right Click on Logins folder and select “New Login”

14. Add the SPF Usage Application Identity user for Login name. eg. Contoso\!spf

15. Select User Mapping under “Select a page”

16. Select OperationsManagerDW and select OpsMgrReader under “Database role membership”

17. Click Ok

18. Right Click OperationsManagerDW under Database and select Properties

19. Select Permissions and pick the user just added under User and Roles.

20. Verify that the user has Execute permission on the database, if not assign this permission as shown below.

      image

21. Close SQL Management Studio

Configure WAP to connect to SPF Usage Service

The Usage module inside WAP uses SPF to collect data from Operations Manager Data Warehouse. For WAP usage to collect this data we need to tell WAP where the SPF Usage service is located.

To enable this in WAP do the following

1. Start a browser that has access to the WAP Admin Portal and login in as administrator

2. Select VM Clouds from the main menu

3. Select the VM Clouds Configuration from the VM Clouds menu

image

4. Select Register Service Provider Usage

5. Provide information for each field as given in the example below and Click Ok.

   image

Username is the user you added to the SPF_Usage Group under step 7 for Configure SPF to extract data from Operations Manager Data Warehouse.

NB: Remember to add /Usage after the port number for the SPF usage service.

    Verify that Data is being stored in the WAP usage database

    To verify that IaaS data is being stored in the WAP Usage Database do the following:

    1. Logon the WAP Database as Administrator

    2. Start SQL Management Studio

    3. Select Databases > Tables

    4. Right Click on Usage.Records and select “Select Top 1000 Rows”

    5. Verify that the result returns Data with ResourceId “VM Utilization”

    image

    6. Close the SQL Management Studio Console

    Now that we see data in the WAP Usage DB, we have successfully integrated SPF and Windows Azure Pack.

    This will now enable us to configure Service Reporting and using billing adapters against Windows Azure Pack.

    In the next blog post I will go through how Service Reporting can be configured.

    My colleague KR Kandavel is working on a series of blog posts explaining how you can build a billing adapter.

    • Link to blog post coming soon

    See you next time for more blogging about Windows Azure Pack & System Center 2012 R2 🙂