Book Image

VMware vRealize Configuration Manager Cookbook

By : Abhijeet Shriram Janwalkar
Book Image

VMware vRealize Configuration Manager Cookbook

By: Abhijeet Shriram Janwalkar

Overview of this book

VMware vRealize Configuration Manager (VCM) helps you to automate IT operations, manage performance, and gain visibility across physical and virtual infrastructure. It is continuously being used by enterprises to audit the configurations of the VMware infrastructure as well as the Windows, Linux, and UNIX operating systems. This book is filled with practical recipes through which you will learn about the latest features of vRealize Configuration Manager 5.8.X, starting with installation of various tiers of VCM followed by configuration management across physical and virtual servers. Throughout this book, you will explore how VCM can perform tasks such as patch management, compliance assessment, and software package distribution along with Machine filters for new platforms such as RHEL 7 and Windows 10. This book will ease your troubles while upgrading from the existing VCM to the latest version by providing you with step-by-step instructions about the process of migration along with upgrade and maintenance support. This book will help you understand how to integrate vRealize Configuration with other applications along with schedule management and also guide you on how to handle security issues. After reading this book, you will have a clear understanding of how VCM fits in the overall picture of the data center design from a patching and compliance perspective.
Table of Contents (18 chapters)
VMware vRealize Configuration Manager Cookbook
Credits
About the Author
Acknowledgments
About the Reviewer
www.PacktPub.com
Preface
11
Understanding VCM Console

Decommissioning VMs – scheduled VM record purge


In the era of the cloud, we would like VM decommissioning to be done automatically so that our operations team can do more creative stuff than cleaning up the VCM database.

Getting ready

You must have access to the SQL server where the VCM database is hosted. You must know the basics of SQL Management Studio.

How to do it...

The following stored procedure can be implemented on the VCM database (VCM) as a scheduled task. This will purge the records of the VMs that haven't been contacted in the last 3 weeks.

Change the value of @expire int = xx (the number of days for which the machine has not been contacted) in the script:

USE [VCM] 
GO 
/****** Object:  StoredProcedure [dbo].[ecmSVC_sp_remove_noncollected_machines]    Script Date: 11/20/2012 11:40:58 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
ALTER PROCEDURE [dbo].[ecmSVC_sp_remove_noncollected_machines] 
@expire int = 21, 
@value NVARCHAR...