CI - Hardware Lifecycle Report

[kauzi007]

Hello Experts, We have recently enabled HAM plugin on our Dev instance. 

We have got access to Hardware Models and its Lifecycle Phases like End of Life, End of Support, etc. 

I am trying to build a report where, I need a single view of all my Servers and its Model and its Hardware Lifecycle Phase and its Dates.

I did try database view but i  am unable to get the view. So i need a report which will contain a view which can show me all my Servers and its attributes (Which i can get from my cmdb_ci table) and Hardware model related info like Model Name, Model Number, Model catrgory, Lifecycle Phase, Phase start date. 

I am unable to get this info in a single view.

I have a screenshot attached. Can you tell me how can i my Server and Hardware Model view under a single report.

The idea is with this report, i can see which server has which hardware model and what is the model's lifecycle phase and its dates.

[Chris McBride]

I had the same requirement and could not find an easy answer, but I was able to create a Database View which appears to work for what I need.  

Here's how it was created:

Once thats saved you can then specify the u_cmdb_db_ci_and_lifecycle table in Reports and be able to add columns for Lifecycle Phase and Start date for each CI that has a model in the cmdb_hardware_model_lifecycle table.

[HeatherC1]

What was your thinking on using the cmdb_ci table?  I am wondering if using the hardware table would be just as effective and not have the same overhead that might come with cmdb_ci. 

[dimitrisala]

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

You should be able to also pull in the CI information by dot walking from this table.