Removing Multiple Assets from the FNMS Database

Yes

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.

Removing Multiple Assets from the FNMS Database