How to enable multi-tenant mode and set tenant ID

[#1]

Summary

Sometimes FNMP system is initially installed in single tenant mode. This KB article describes how to configure it to multi-tenant mode afterwards and how to set the tenant ID if you want to work directly with FNMP or data warehouse databases.

Synopsis

Sometimes FNMP system is initially installed in single tenant mode. This KB article describes how to configure it to multi-tenant mode afterwards and how to set the tenant ID if you want to work directly with FNMP or data warehouse databases.

Discussion

You can run the following SQL stored procedure to enable mult-tenant mode. This needs to be applied to the FNMP database (default name is ManageSoft) and FNMP data warehouse (default name FNMPDataWarehouse) if you are using one. This needs to be re-applied after applying any FNMP service packs as well.

EXEC ConfigureMultiTenancy 1

Once the FNMP system is set to multi-tenant mode, if you are working on FNMP database directly for a particular tenant, first you need to find the TenantID from table "Tenant", then you can run the following SQL query to set the TenantID. All the other SQL queries you do afterwards will be in this tenant's context.

EXEC SetTenantID <TenantID>

Additional Information

If any data was imported before multi-tenant mode was enabled you may receive an error message similar to the following when performing a compliance import. For Technical Support to investigate this further please provide the compliance import trace log or importer log from when the compliance import was performed.

"Error: The DELETE statement conflicted with the REFERENCE constraint &quot;FK_VirtualMachine_ComplianceComputerID&quot;. The conflict occurred in database &quot;ManageSoft&quot;, table &quot;dbo.VirtualMachine_MT&quot;, column

'ComplianceComputerID'. ".