4 Replies Latest reply on May 30, 2012 9:35 AM by Alon Sadeh

    reporting on CMDB relationships

    Michael Woodward

      I know it is possible to create a query based on the relationship, but the results do not have any 'noticible' indication of the selected relationship.


      example, i want to find all the CI's that have Acrobat Reader 10 installed. 


      the results would just be the CI's  nothing about Acrobat Reader.  Is there away to indicate the 'relationship variable' in the report?

        • 1. reporting on CMDB relationships
          Greg Tucker

          I haven't yet tested this functionality in FPSC11, but as of FootPrints 10 it remains a gap in the product. In fact including any data from related objects (issues, address book contacts, or other CIs) in the search or report is impossible in the CMDB reporting.


          I once developed a workaround by importing the attributes of linked CIs into reported CI. I'm not sure if this makes sense, but as an example, let's say we relate an asset CI (computer) with an owner CI (person). We created a SQL view that joined these separate tables, which we used to import back into the computer CI. Although the data became "static" in the computer CI, it retained the dynamic properties of being updated whenever the relationship changes and the next scheduled import takes place.

          • 2. reporting on CMDB relationships

            Without knowing exactly what you need for a noticeable relationship why don't you try reversing the query, meaning search for all software titles of Adobe 10 which have associated desktops. The result page will list the variances of Adobe 10 and also a hyper link to associated CIs to that software title.  The hyperlink is something new in V11.1 which came out last week.

            Also you can define what attributes you would like displayed for all CIs when viewing them.  The default is something like [CI-Name, CI-Type], but you can change it to show whatever attribute you would like.  This is defined under the miscellaneous opiton area of the CMDB administration screen.


            Hope this helps.



            • 3. reporting on CMDB relationships
              Michael Woodward

              Unfortunately do to some unresolved issues with our migration we were forced to postpone our migration to 11. But hat does sound good, just to clarify, are you saying you only get a link or you can also see the CI name associated with it?


              The way we have to report our data to the auditors is to provide a list of systems that meet a specific criteria.  so in  the scenario you described above, if we needed to report on the systems that had adobe the first results would be a list of adobe and a hyperlink to the system


              on the second description i am not clear, but if we could format it 'Adobe v.10', CI-NAME ... then although we would get a lot of rows with 'Adobe v.10'.  that would be more usable than just a list of items and no way to indicate on a report / form what the criteria was that grouped the system

              • 4. reporting on CMDB relationships


                Sorry for the delayed response as the email from this discussion was lost in the shuffle.  To answer your question, yes, only a hyperlink would be displayed next to the list of Adobe systems to the list of computers that are related, not a list of machines.  You would have to click on the link and then you would be presented with the computers.


                As for what information you can display when viewing a CI, you can list any CI attribute.  As an example if it made sense for you to have every CI have a default display of "CI-Name, CI-Status", or I have an example for a client where they want to display the CI-Name and CI-Blackout date (an attribute that they have for servers and PCs).


                I hope this clears things up.