Generating lifecycle reporting on devices

[Bill Girard1]

We have been trying to build a report that includes the following:

Publisher, Product, Full Version, Edition, Software Model, Discovery Model, Lifecycle Phase, Phase Start Date, Installed on, Class, Environment, and IP Address.

However, it seems the details are located on multiple tables and I just can't seem to figure out how to put these things together to provide the requestor with a CSV extract that contains all the details they need. 

I was hoping some of you have worked out something similar and could share your thoughts.

[Rahul Talreja]

Hi Bill,

I faced similar kind of issue few days back with a client where they were expecting to create a report which uses data from more than 2 tables.Her is what I figured out that might help you.

If you have to create a report based in two tables connect to each other ( that are visible in Related list) you can directly do it by applying related list filters in reporting.

If we have to club more than two tables this can be achieved by creating a database view and than finally generating a report on that view. (Refer here)

Second is you can write a script include, where you can fetch records from different tables perform operations, filter out the desired sys_id's and return them. Than you can call this script include in your report to get that desired output in the way of report.

Hope you find this information useful. If you are looking for something else please let me know.


Please mark my answer correct/helpful as applicable!!

Thanks and Regards,
Rahul

[Rahul Talreja]

Hi Bill,

Is your query resolved?

Regards,
Rahul

[Bill Girard1]

Thanks Rahul. I think Scott's link to Hardik Benani's solution for a Report on Software Product End of Life or End of Service will work for us. However, I do need to learn a bit more on this, I appreciate you including the reference link

[Scott Halverso1 · Accepted solution]

This article should get you close.  You'll need to dot walk the installed on field to get the CI's class, environment and IP Address attributes.