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.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.

No ratings
Comments
mbouwman
By
Level 4

I've added an asset the way shown above. When I add this kind of asset,

the asset type = "[1.002]" with the remark "Please select a value for Asset type."

Did I miss some extra configuration?

ChrisG
By Level 20 Flexeran
Level 20 Flexeran

@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.

Version history
Last update:
‎Jan 13, 2023 10:34 AM
Updated by: