Remove Asset Class from Model Categories

tschenke · ‎12-01-2014

Before implementing Software Asset Management, someone assigned an asset class (alm_asset) to the Software category in the Model Categories. This was done in a much earlier version of Service Now, and I'm not sure why this would have been done but now we seem to be stuck with about 68K software instance records in our Asset table. I can run a background script to remove those asset records, but I can not remove the alm_asset asset class from the category. I've been told there is a way to do it but I'm not having much luck finding the way. I am guessing I could delete the category and recreate it but I want to make sure that I am not going to break anything in the process. Is there a better way of doing that or am I stuck with 68K useless records?

Community Alums · ‎12-01-2014

Tony,

The Model Category identifies corresponding CI and Asset classes to determine what CIs to make Assets for and vice versa. After the Asset is created from the CI, the Model Category does not do much beyond classification. You should be fine to delete the category and recreate it without the Asset class. All new Software moving forward would then no longer get an associated asset record.

Then you would need to go through and break the connections for the existing Software Asset/CI items so that you don't delete the Software CI information when you delete the Asset (unless you just plan on having your discovery source repopulate it). This could get ugly for 68K records unless you script it.

That being said, I do always like to recommend trying in a test environment first if this is an option for you.

I hope this helps get you started.

Ben

View solution in original post

tschenke · ‎01-21-2015

I finally got around to trying this last week and it won't let me delete the Software model category. It tells me that there are assets associated to that category so I can't delete it. it looks like I'll have to delete all of the software assets first and then delete and recreate unless you know of any tricks.

Community Alums · ‎01-21-2015

If you are not looking to keep the assets around anyway, you could delete the assets first. If you want to have the new Model Category in place, rename the old one, and create the new one. Then you can delete the old assets and the old Model Category.