Microsoft Windows and SQL Server infrastructure details reports

  • Release version: Washingtondc
  • Updated February 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 provide insights into SQL Server and Windows Server deployments across various cloud platforms, including Microsoft Azure, AWS, and GCP. These reports are vital for understanding your software asset utilization and ensuring cost-effective license management.

    Show full answer Show less

    Key Features

    • Azure BYOL Realized Savings Report: This report highlights potential and actual cost savings when deploying Microsoft SQL Server and Windows Server on Azure using the Bring Your Own License (BYOL) model.
    • ServiceNow Integration: The report is accessible through the ServiceNow Software Asset Workspace, which must be enabled by installing the ServiceNow Cloud Insights application.
    • Detailed Reporting Fields: Key fields in the report include virtual machine details, host type, geographic location, operating system, SQL Server version, pricing with and without Azure Hybrid Benefit (AHB), and realized savings.

    Key Outcomes

    By utilizing these reports, ServiceNow customers can effectively track their SQL Server and Windows Server costs, optimize license usage, and better leverage Azure Hybrid Benefits to realize significant savings on their cloud infrastructure expenses. Accessing this information helps ensure informed decision-making regarding cloud deployments and licensing strategies.

    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 license types on cloud

    Microsoft products across hybrid environment

    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 is not 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 is not 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 is not 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.