Summary
Instructions for batch removing asset records from the FNMS database
Synopsis
Instructions for batch removing asset records from the FNMS database.
Discussion
Before carrying out these steps, ensure you have taken a full back of your database
If you have a list of assets you which to remove, run the following SQL script on your FNMS Compliance Database:
drop table #asset
SELECT *
INTO #Asset
FROM [FNMSCompliance].[dbo].[Asset]
where ShortDescription in ('Asset1''Asset2','Asset3')
exec dbo.AssetRemoveBatch
*Note: Add the asset names to the 'where ShortDescription in ('Asset1''Asset2','Asset3') ' line.
This will delete all the assets specified.
Related KB Articles
Salesforce: 00822366
