content

» Script Library: AR Tables Report

AR Tables Report

This script generates a CSV listing a few fields from arschema and getting a count of records from regular and join tables. Join tables are identified.

Demonstrates

This script demonstrates the QuerySql interation statement, creating Output CSV files, and performing an SQL Query LookUp assignment.

It also shows a complex assignment for ARS servers pre 7.1 which did not have the ViewName column in arschema.

Loading

Nothing is needed for this script. Just run the script and look at the resulting CSV file in Excel. Note that you may need to import the file into Excel to have it parsed properly.

Running

Change the delimiter for the output file to ";" if desired in section [F-out]. Takes an optional second argument which is a pattern of schema names to search for.

 SthMupd.exe  Do -p arschema-rpt.csv 
 SthMupd.exe  Do -p arschema-rpt-BMC.csv "BMC%"  

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