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.
You must have access to the SQL server where the VCM database is hosted. You must know the basics of SQL Management Studio.
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...