Generating lifecycle reporting on devices

Go to solution
Bill Girard1
Tera Contributor

‎05-27-2022 11:47 AM

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.

 

  • 1,421 Views
1 ACCEPTED SOLUTION

Go to solution
Scott Halverso1
Mega Guru
Mega Guru

‎05-30-2022 08:27 PM

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.

View solution in original post

6 REPLIES 6

Go to solution
Bill Girard1
Tera Contributor
In response to Scott Halverso1

‎05-31-2022 01:00 PM

Thanks Scott. I think I saw this in my search, but didn't realize it was was referencing the same. I was trying database views using different tables and where clauses and I think this is pretty much spot on. I just have to wrap my head around picking the right tables and getting that where clause right. Thanks again for the help.
0 Helpfuls

Go to solution
Nagaraju D
Tera Contributor
In response to Bill Girard1

‎12-08-2023 05:42 AM

Did you get solution for this?

0 Helpfuls