Microsoft Windows and SQL Server infrastructure details reports

  • Release version: Zurich
  • Updated July 31, 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 detailed visibility into their SQL Server and Windows Server deployments across multiple cloud providers, including Microsoft Azure, AWS, and GCP. These reports help track infrastructure specifics and licensing usage to optimize cost management and operational insights.

    Show full answer Show less

    Azure BYOL Realized Savings Report

    This specific report focuses on Microsoft Azure environments and highlights potential and actual cost savings when using the Azure Hybrid Benefit (AHB) licensing model, which allows customers to bring their own licenses (BYOL) for Microsoft SQL Server and Windows Server.

    Key points about the Azure BYOL Realized Savings report:

    • Available exclusively in the Software Asset Workspace within ServiceNow (not in the classic Software Asset Management application).
    • Requires installation of the ServiceNow Cloud Cost Management application.
    • Accessible by navigating to Software Asset > Software Asset Workspace > License usage > Reports > Azure BYOL Realized Savings Report in your ServiceNow instance.

    Key Report Fields and Their Practical Use

    The report provides detailed fields that enable customers to analyze their Azure VM deployments running SQL Server or Windows Server and understand cost implications with and without Azure Hybrid Benefit:

    • Virtual Machine: Identifies the Azure VM hosting SQL Server or Windows Server.
    • Host Type: Indicates whether the VM runs on a shared or dedicated Azure host.
    • Location: Shows the geographic region of the Azure host, helping align deployments with regional cost and compliance considerations.
    • vCPU and Hardware Type: Details CPU allocation and hardware specifics, aiding capacity planning and cost analysis.
    • Operating System and SQL Server: Displays version and edition, supporting software asset management and upgrade planning.
    • AHB on Windows Server and SQL Server: Flags whether Azure Hybrid Benefit is enabled, critical for understanding licensing cost savings.
    • Cost Metrics: Includes standard and actual monthly VM costs with and without AHB, based on assumed (720 hours) and actual VM uptime, enabling precise financial tracking.
    • Savings Realized: Shows both potential and actual cost savings achieved by leveraging Azure Hybrid Benefit, empowering cost optimization decisions.

    Benefits for ServiceNow Customers

    By using these reports, customers can:

    • Gain clear visibility into their cloud-hosted Microsoft SQL Server and Windows Server environments.
    • Understand licensing models and their financial impact, particularly leveraging Azure Hybrid Benefit BYOL licensing.
    • Track potential versus realized cost savings, facilitating informed licensing and cloud resource optimization.
    • Use detailed infrastructure data to support capacity planning, compliance, and operational efficiency.

    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.