Chargeback is a new feature in SCSM 2012 SP1 that enhances reporting by providing financial management for Clouds in SC 2012 SP1. This is first part of blog series that you will be able to learn more about this feature if you haven’t used it already.
Tag: report
Hyper-V and SQL 2012 – better together
Microsoft gave the task to Enterprise Strategy Group (ESG) to make Workload Performance Analysis of using Microsoft Windows Server 2012 with Hyper-V and SQL Server 2012. Findings of this report you can find in this article.
Find Missing Hotfixes on Cluster Nodes with PowerShell
Rick Bergman a Microsoft PFE created nice and powerful script that generates report and shows missing patches on nodes of a cluster. You just have to enter the cluster names and the script will find all nodes, compare hotfixes and generate a nice report. Download and find more on the script here.
VMM SQL Extravaganza Scripts
Here 21 SQL queries that you can run against VMM Database and get useful information. The scripts are kindly provided by Murat Demirkiran a Senior Virtualization Expert at Denizbank in Infrastructure & System Management Group.
- VMM SQL Extravaganza01 – General VM Information
- VMM SQL Extravaganza02 – General VM Information 2
- VMM SQL Extravaganza03 – General Host Information
- VMM SQL Extravaganza04 – Host VM Count
- VMM SQL Extravaganza 05 – Empty Hosts List
- VMM SQL Extravaganza06 – VMs Placement
- VMM SQL Extravaganza 07 – VMs Storage Placement
- VMM SQL Extravaganza 08 – Stopped VMS List
- VMM SQL Extravaganza 09 – VMs with Pass-Through Disk List
- VMM SQL Extravaganza 10 – Last 10 VM Creation
- VMM SQL Extravaganza 11 – Host VM Count below 10
- VMM SQL Extravaganza 12 – Host VM Count 10 and above 10
- VMM SQL Extravaganza 13 – Host VM Average
- VMM SQL Extravaganza 15 – VMs Addition Count
- VMM SQL Extravaganza 16 – Host VMM Agent Version Details
- VMM SQL Extravaganza 17 – VMs Operating System Count
- VMM SQL Extravaganza 18 – VMs Operating System Details
- VMM SQL Extravaganza 19 – Hosts Available Memory
- VMM SQL Extravaganza 20 – Yearly created VMs
- VMM SQL Extravaganza 21 – Monthly created VMs