End of Life Asset Reporting

[ndube82]

Out of the box, ServiceNow does not provide assets level reporting for various milestones of the product lifecycle.  For instance, if I need to find all assets that are currently past end of life milestone... I must copy and paste the model names into a report.  This is challenging to create repeatable processes in an efficient manner.

Has anyone solved this challenge using the Content Library and views?  Any other solutions?

The goal would be to have a report source/view/table built with minimal customization to be able to forecast future assets expiring, query for those already expired ( End of Life or End of Support (when end of life does not exist) so on and so on.  

Open to any and all suggestions!

[ndube82]

I am unable to reply to thread, these two responses are helpful but the reporting is already available and has been reviewed.  I need to report on the assets not the models.

[Amarjeet Pal]

Hello @ndube82 ,

I am afraid , if you are not able to dot walk we have to create a custom table and save the data there and report on the custom table. Or let the client know reporting is available on models not the assets.

Thank you

[ndube82]

Can someone identify how to dot walk?  Does ServiceNow need to be configured to dot walk in this manner?  I find it very hard to believe that there is no solution for this yet!

[Empire]

Did you ever find a solution to this problem? Dealing with something similar and this thread is the only reference to the issue.

[Chris McBride]

I ended up creating a Database View that joins the cmdb_ci table to cmdb_hardware_model_lifecycle table.  This does result in a table that's a little challenging to deal with in that there will be multiple entries for each CI's Lifecycle Phase Start or End Date.  But filtering enables you to get the data you want.