Microsoft Windows and SQL Server infrastructure details reports

  • Release version: Yokohama
  • Updated January 30, 2025
  • 2 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Microsoft Windows and SQL Server infrastructure details reports

    The Microsoft Windows and SQL Server infrastructure details reports provide ServiceNow customers with insights into their SQL Server and Windows Server deployments across major cloud providers such as Microsoft Azure, AWS, and GCP. These reports help customers understand their cloud infrastructure, license usage, and potential cost savings, especially when leveraging licensing models like Azure Hybrid Benefit (BYOL).

    Show full answer Show less

    Azure BYOL Realized Savings Report

    This specific report focuses on Microsoft Azure deployments and highlights the cost savings achieved by using the Azure Hybrid Benefit (BYOL) licensing model for Microsoft SQL Server and Windows Server. It enables customers to compare the costs of running virtual machines (VMs) with and without Azure Hybrid Benefit, thus providing actionable visibility into potential and actual savings.

    Key Features

    • Cloud Provider Coverage: Visibility into SQL Server and Windows Server infrastructure across Azure, AWS, and GCP.
    • Azure BYOL Realized Savings Report Availability: Accessible only via the Software Asset Workspace in ServiceNow, not in the classic Software Asset Management application.
    • Detailed Cost and Usage Metrics: Reports include VM details (such as vCPU count, OS and SQL Server version, hardware type), Azure host type and location, and Azure Hybrid Benefit enablement status.
    • Cost Comparison Fields: Displays standard and actual VM costs per month with and without Azure Hybrid Benefit, calculated assuming full monthly uptime or actual runtime hours.
    • Savings Metrics: Shows potential and realized savings from Azure Hybrid Benefit on both Windows Server and SQL Server deployments.

    Practical Use for ServiceNow Customers

    By using these reports, customers can:

    • Gain comprehensive visibility into their SQL Server and Windows Server cloud infrastructure.
    • Understand the impact of licensing models on cloud costs, especially the benefits of Azure Hybrid Benefit.
    • Make informed decisions to optimize license usage and reduce cloud infrastructure costs.
    • Access these insights directly within the ServiceNow platform via the Software Asset Workspace, streamlining cost management processes.

    You can use the Microsoft Windows and SQL Server infrastructure details reports to gain visibility into the SQL Server and Windows Server deployments and infrastructure for different cloud providers including Microsoft Azure, AWS, and GCP.

    License types on cloud

    Bar graph showing BYOL and License Included license types on cloud providers such as Azure, AWS, and GCP

    Chart showing Microsoft products across hybrid environment such as AWS, Azure, GCP, and On Premise

    Azure BYOL Realized Savings report

    You can use the Azure BYOL Realized Savings report to gain visibility into the potential and actual cost savings for your Microsoft SQL Server and Microsoft Windows Server deployments on Microsoft Azure when using Azure Hybrid Benefit, which is the bring your own license (BYOL) licensing model for Microsoft Azure.

    The Azure BYOL Realized Savings report is generated only if you have requested and installed the ServiceNow® Cloud Cost Management application from the ServiceNow Store. See Cloud Cost Management application for more information on Cloud Cost Management.

    Note:
    This report is available only in the Software Asset Workspace. This report isn’t available in the Software Asset Management classic application.

    To view this report, launch the Software Asset Workspace by navigating to Software Asset > Software Asset Workspace on your ServiceNow instance. From the Software Asset Workspace, navigate to License usage > Reports > Azure BYOL Realized Savings Report.

    Table 1. Azure BYOL Realized Savings report
    Field Description
    Virtual Machine Azure virtual machine (VM) that Microsoft SQL Server or Microsoft Windows Server is running on.
    Host Type Type of Azure host that the Azure VM is running on. The options are Shared and Dedicated.
    Location Geographic location that the Azure host resides in.
    vCPU Number of virtual CPUs (vCPUs) that are assigned to the Azure VM.
    Hardware Type Hardware type of the Azure host.
    Operating System Operating system (OS) version and edition that is running on Azure.
    SQL Server Microsoft SQL Server version and edition that is running on the Azure VM.
    AHB on Windows Server Field indicating if Azure Hybrid Benefit is enabled for Microsoft Windows Server.
    AHB on SQL Server Field indicating if Azure Hybrid Benefit is enabled for Microsoft SQL Server.
    Standard price per month without AHB Potential VM cost per month when Azure Hybrid Benefit isn’t enabled. This value is based on the assumption that the VM is running for the entire month (720 hours).
    Standard price per month with AHB Potential VM cost per month when Azure Hybrid Benefit is enabled. This value is based on the assumption that the VM is running for the entire month (720 hours).
    Standard Savings Realized Potential VM cost saved per month by using Azure Hybrid Benefit. This value is based on the assumption that the VM is running for the entire month (720 hours).
    Actual price per month without AHB Actual VM cost per month when Azure Hybrid Benefit isn’t enabled. This value is based on the actual number of hours that the VM was running for within a month.
    Actual price per month with AHB Actual VM cost per month when Azure Hybrid Benefit is enabled. This value is based on the actual number of hours that the VM was running for within a month.
    Actual Savings Realized Actual VM cost saved per month by using Azure Hybrid Benefit. This value is based on the actual number of hours that the VM was running for within a month.