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]

Thanks so much Chris,

We ended up building a view as well.  Unfortunately there is no comprehensive solutions from the ServiceNow side.  It is half baked/built imho.

[dimitrisala · Accepted solution]

Hi, 
I had the same scenario and was pointed to the following table:

sn_hamp_assets_capital_planning_view

Not sure how long this has been available but seems to do the trick by creating a view between
cmdb_hardware_product_model

alm_hardware

cmdb_hardware_model_lifecycle

[ndube82]

Wow, thanks so much!  We solved by creating our own views and reporting unfortunately, but this is fantastic and I hope others see this and leverage!!!

[simplyrik]

Do you know if there is a similar table hiding out there for Software?

Thanks

Rik

[dimitrisala]

I don't believe there is for just ITSM - SAM, but if you have SAM Pro there is the OOTB Software Product Lifecycle Report (sam_sw_product_lifecycle_report) in the SAM Workspace. Alternatively, you can dot walk from SW Install > Discovery Model > Lifecycle Report to get to the lifecycle information.