content

» Script Library: CI Relationships Report

CI Relationships Report

This script generates a CSV listing all CI relationships with identifying info from the relationship and both related CIs.

Demonstrates

This simple script demonstrates how to process a Query= statement fired on a single table, load related records for each relationship record, and create a single CSV file containg data from all three recordsL relationship, parent CI, child CI.

Loading

Nothing is needed for this script. Just run the script and look at the resulting CSV file in Excel. If you are in a language setting that uses semi-colons as separators, edit the separator in the file definition section of the script - Fout

Running

Simply specify the output file name as the only argument.

 SthMupd.exe  VerCiCi.ini -p CiAssociations.csv  

Sample output

Click the Sample Output to open a
new window with an enlarged image.

More Information

These scripts will need to be edited to fit your requirements. They will also need Meta-Update installed and licensed to run.

Downloads

    Save the zip, expand in your samples or scripts directory. The zip file may contain different versions of the script and a tutorial document.

  • zip
  • Script Source
  • Output Example