Summary

The following SQL statements illustrate an example of how to add a custom asset type to FlexNet Manager Suite:

declare @AssetTypeResourceName nvarchar(512) = 'MyOrgAssetType.ITDevice'
declare @AssetTypeName nvarchar(128) = 'IT Device'
declare @ManagedType bit = 0
declare @BitwiseValue int
select @BitwiseValue = 2 * MAX(bitwisevalue) from AssetType

exec dbo.ComplianceTranslationPutByResourceStringCultureTypeResourceValue @AssetTypeResourceName, 'en-US', @AssetTypeName

insert into AssetType(AssetTypeResourceName, AssetTypeName,ManagedType, BitwiseValue) 
values (@AssetTypeResourceName, @AssetTypeName, @ManagedType,  @BitwiseValue)

To remove this newly created asset type the below command can be used by replacing 'IT Device' with the asset type name to be deleted.

exec AssetTypeRemoveByName 'IT Device'

Additional information

Refer the System Reference for additional information about adding custom asset types (and other types of data model customizations): Adding a Custom Asset Type.

Note that custom asset types cannot be added to Flexera One ITAM organizations. If this capability would be of interest to you, please vote for the following Idea: ITAM-I-153: Custom status and type for asset and contract.