The Community is now in read-only mode to prepare for the launch of the new Flexera Community. During this time, you will be unable to register, log in, or access customer resources. Click here for more information.
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'
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.
on Dec 11, 2018 02:10 AM - edited on Jan 13, 2023 10:34 AM by JohnTech
@mbouwman - the example SQL script that was in this article looks like it was a bit out of date for current FlexNet Manager Suite versions. The example has now been updated, and I think should work better for you.