Microsoft Windows and SQL Server infrastructure details reports

  • Release version: Xanadu
  • Updated August 1, 2024
  • 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 in ServiceNow provide comprehensive insights into your SQL Server and Windows Server deployments across major cloud providers such as Microsoft Azure, AWS, and GCP. These reports enable you to understand the infrastructure details and license usage, helping optimize your cloud resources and costs.

    Show full answer Show less

    Specifically, the Azure BYOL Realized Savings report focuses on cost savings associated with Microsoft Azure deployments using the Azure Hybrid Benefit (BYOL licensing model).

    Key Features

    • Cross-cloud visibility: View detailed infrastructure data for SQL Server and Windows Server across Azure, AWS, and GCP environments.
    • Azure BYOL Realized Savings report: This report highlights potential and actual cost savings when using Azure Hybrid Benefit for Microsoft SQL Server and Windows Server on Azure.
    • Report availability: The Azure BYOL Realized Savings report is accessible exclusively in the Software Asset Workspace after installing the ServiceNow® Cloud Cost Management application from the ServiceNow Store.
    • Detailed cost and usage metrics: The report provides granular data such as virtual machine details, host type, location, vCPU count, hardware type, operating system and SQL Server versions, and Azure Hybrid Benefit status.
    • Cost comparison: It compares standard and actual monthly costs with and without Azure Hybrid Benefit enabled, showing both realized and potential savings based on VM runtime hours.

    Practical Use for ServiceNow Customers

    By leveraging these reports, ServiceNow customers can:

    • Gain clear visibility into Microsoft Windows and SQL Server deployments across multiple cloud platforms.
    • Identify opportunities to reduce costs by applying the Azure Hybrid Benefit licensing model for their Azure workloads.
    • Track and quantify actual savings achieved through BYOL licensing on a monthly basis.
    • Make informed decisions about license management and infrastructure optimization using detailed VM and cost data.
    • Access the Azure BYOL Realized Savings report easily through the Software Asset Workspace for streamlined cost management.

    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.