Click the image to pop up a view of this script's
output showing added Count columns:
Records, Filters, Active Links, Guides.

These scripts are in the Meta-Update distribution and may be run with a trial license. They are fully documented in the Meta-Update User's Guide

Creates a CSV from an SQL Query on arschema adding count columns for number of records, filters, active links, guides.

• How to use a QuerySql=
• How to use Output= to create a file
• How to define an output File with standard CSV formatting.
• How a File's field definition can include substitutions
• How to interpret a Remedy Time field when using QuerySql=
• How to use a LookUp= to issue other QuerySql= in the assignments

A great beginner's next step script with a very useful function.

Uses a QuerySql= to iterate through rows of arschema and an Output= to add to a CSV file.

Each row returned from the QuerySql= causes a new file row by processing the assignment statements.

In some of these, several additional QuerySqls are done to LookUp record and work-flow counts.

Both the Output= field definitions and the QuerySql= fields, this script uses transformation rules on the values when reading the Sql fields and writing the CSV fields.