Virtualization Discovery and Inventory Details Custom Views
The two views described in the attached documents aim to provide more visibility into virtualized infrastructures, particularly clusters.
-
A first Virtualization Discovery details provides information on Hypervisors (vCenters, HyperV, Oracle VMs hosts, ESX servers) that have been discovered online by the beacons.
-
A second view deep dives into vCenter inventory: list of vCenters (not visible in FNMS), Clusters, Hosts and Virtual Machines, including the virtual machines not inventoried by FNMS (that are not visible in FNMS UI).
To create the report in a multi-tenant environment, use the SetTenantID store procedure before the report creation section, for instance.
GO
EXEC SettenantID @TenantID = 2
DECLARE @ViewName nvarchar(64), @tenant int
SET @ViewName = 'Virtualization Overview incl. vCenters (NR)' -- Unique Name you want to display for object
SET @tenant = 2 -- Tenant for which this view applies
EXEC ComplianceCustomViewRegister
@TenantID = 2,
@ComplianceSavedSearchSystemID = NULL,
@SearchName = @ViewName,
@SearchNameResourceName = NULL,
@Description = '(v7) This view catches all, particularily VMs inventoried by vCenter but not by an inventory tool (SCCM, FNIM...), with their hosts, clusters and vCenters',
@DescriptionResourceName = NULL,
@SearchGridLayout = NULL,
@SearchXML = NULL,
@SearchSQL = 'EXEC dbo.nr_VirtualInfraInclMissingVMsAndvCentersCustView',
@SearchSQLConnection = 'Live',
@SearchMapping = NULL,
@ComplianceSearchType = 'Custom',
@ComplianceSearchFolderSystemID = -17,
@CanDelete = 1,
@CanChangeMasterObject = 0