cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Author: Nicolas Rousseau
  • Author Email Address: nrousseau@flexera.com
  • Solution Type: Custom Report
  • Flexera Product & Version: FlexNet  Manager 2016-2020R1
  • Environment: On Premise Only
  • Development Effort (Days): 2
  • Implementation Effort (Days): 0.1
  • Disclaimer: Read Disclaimer

Summary

Create custom views for virtualization discovery and inventory.

Synopsis

The two views described in this document aim providing 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

  • VirtualizationInclvCenters.png

 

Was this article helpful? Yes No
No ratings
Comments
FrankEckert
By
Level 2

Hello,

we run the script on the sql server. Where can I find the "Virtualization Overview incl. vCenters (NR)" view (second view).

Kind Regards

Frank

 

 
kclausen
By
Flexera Alumni

Looking at the SQL, it should be creating both reports at the top level of the Report Structure.

Tooling42
By
Level 7

Hi @kclausen,

the scripts are working fine for an existing folder.

Now I have created a new folder :
Reports ► Discovery and Inventory ► Virtualization Discovery and Inventory
and checkeed the database for the ComplianceSearchFolderSystemID
of the new folder. But ComplianceSearchFolderSystemID = NULL.

Where I can find the ComplianceSearchFolderSystemID of the new folder
'Virtualization Discovery and Inventory' ?

Best regards

kclausen
By
Flexera Alumni

@Tooling42 

Try the following SQL:

 

select * from ComplianceSearchFolder
where name like '%virtual discovery and inventory%'

Tooling42
By
Level 7

@kclausen 
yes, I have used it on our multi-tenant system and found: ComplianceSearchFolderSystemID = NULL

Here my query, it shows me also the 'root' folder:

SELECT * FROM [FNMSCompliance].[dbo].[ComplianceSearchFolder_MT]
WHERE TenantID = '2' and
ComplianceSearchFolderSystemID = '-17' or Name = 'Virtualization Discovery and Inventory'

kclausen
By
Flexera Alumni

Your SQL will not work as the search on the folder name must be a LIKE:

Please try the following and use the EXACT syntax:

select * from ComplianceSearchFolder_MT
where name like '%virtual discovery and inventory%'

 

Tooling42
By
Level 7

Please see above, I wrote:
-------------------------------------------------------------------------------------------------------
Now I have created a new folder :
Reports ► Discovery and Inventory ► Virtualization Discovery and Inventory
-------------------------------------------------------------------------------------------------------
And I want to see the folder 'Virtualization Discovery and Inventory'
So,
Name = 'Virtualization Discovery and Inventory' is working
and
name like '%virtual discovery and inventory%' will not working.

But any way,
all folders which I created in the UI has: ComplianceSearchFolderSystemID = NULL

My problem is that the script 'Virtualization Discovery Details (NR)'  didn't accept ComplianceSearchFolderSystemID = NULL.

That means we can use the script for the view 'Virtualization Discovery Details (NR)' only for  ‘default’ folders, there is a limitation of the stored procedure dbo.ComplianceCustomViewRegister.

No problem, I will use a default folder, e.g.
Discovery and Inventory ► Inventory

So I used:
@ComplianceSearchFolderSystemID = -25

Thanks

Tooling42
By
Level 7

I have checked the result of the view, we got more than 500 results returned,
e.g. more than 100 [ProductName]: VMware vCenter Server.

But the number of vCenters of the tenant is less 10. I afraid there is no filter
on the tenants.

--------------------------------------------------------------------------------------------------
CREATE PROCEDURE dbo.nr_custReportVirtualizationDiscovery AS

SELECT
vpn.ProductName
, Protocol
,dd.DeviceName
,dd.IPAddress
,Port
,APIType
,APIVersion
,ProductNameID
,ProductVersion


FROM DiscoveredDeviceVirtualizationInfo_MT ddv
INNER JOIN DiscoveredDevice_MT dd on dd.DeviceID = ddv.DeviceID
INNER JOIN VirtualizationProductName vpn on vpn.VirtualizationProductNameID = ddv.ProductNameID
--------------------------------------------------------------------------------------------------

Atm I can see data from all tenants, because we have a multi-tenant system.
e.g. in the UI I found also [ProductName]: Oracle VM Manager.
but for this tenant we are not using it.

I will create a case for my request

Version history
Last update:
‎Jun 03, 2021 01:43 AM
Updated by: