Tracking # of consumable assets issued to users

kjh1138
Tera Expert

I would like to be able to assign consumable assets to individual users.  For a given consumable model I want to know who has how many of a model - I don't care which specific CI they have  i.e I want to be able to track who has been issued a 24" Standard monitor but I don't care which specific serial number they have.  Any suggestions on how i should proceed?

1 ACCEPTED SOLUTION

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI, 


You create a report on alm_consumable table. You can group this report by model and check which user is assigned this asset. So that you can get a list of user for specific asset. See below report:

 

find_real_file.png

 

THanks,
Ashutosh

View solution in original post

4 REPLIES 4

akash_mehta
ServiceNow Employee
ServiceNow Employee

kjh1138:  This is OOB capability with ServiceNow Asset Management.  We have many docs that you can look at on our doc site:

 

https://docs.servicenow.com/bundle/madrid-it-service-management/page/product/asset-management/concep...

 

Hope that helps,

Akash

Ashutosh Munot1
Kilo Patron
Kilo Patron

HI, 


You create a report on alm_consumable table. You can group this report by model and check which user is assigned this asset. So that you can get a list of user for specific asset. See below report:

 

find_real_file.png

 

THanks,
Ashutosh

kjh1138
Tera Expert

Thanks for the quick response - follow on question:

 

If I go into a stockroom and select one of the consumables I have an option to 'Consume' some or all of the asset.  When I click on it a dialogue opens which is titled for the consumable in question i.e. 'generic keyboard' and it has fields for me to fill in the Quantity, User and Asset.  When the asset field is left blank everything works as expected but...

find_real_file.png

1) What's the deal with the Asset filed on the Consume dialogue - is it UI design error or does it play a role that I'm ignorant of?    

2) I'm assuming it would be fairly straightforward to add a [Location] field to the dialogue and update the back-end script to update that info on the resulting alm_consumable record that is created - if not please disabuse me of the notion 

 

Never mind.  The asset field is there for association purposes.  i.e I can associate my consumable with a non-consumable asset