TeamcenterKnowledge

Query utilities

find_released_item_rev

Allows you to create a query based on date and object type. The query is performed on the Teamcenter database and generates the released item revision list to identify released item revisions. Use a date before the earliest assembly was created to ensure a listing of all released items. Syntax find_released_item_rev [-u=user-id {-p=password | -pf=password-file} -g=group] -start_date=DD-MMM-YYYY HH:MM:SS -end_date=DD-MMM-YYYY HH:MM:SS -obj_type=object-type [-out_file=output-filename | -outItemRevKeyFile=output-filename] -h Arguments -u Specifies the user ID. This is a user with Teamcenter administration privileges. Note If Security Services single sign-on (SSO) is enabled for your server, the -u and -p arguments are authenticated externally through SSO rather than being authenticated against the Teamcenter database. If you do not supply these arguments, the utility attempts to join an existing SSO session. If no session is found, you are prompted to enter a user ID and password. -p Specifies the password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. For more information about managing password files, see Manage password files. This argument is mutually exclusive with the -p argument. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -start_date Defines the date and time from which the item revisions are searched. The time specifies a time in the current time zone for the machine where the program is running. This argument is required. Use the following format: dd-mmm-yyyy hh:mm:ss. For example, 01-Jan-2002 13:00:00. -end_date Defines the date and time before which the item revisions are searched. The time specifies a time in the current time zone for the machine where the program is running. Use the following format: dd-mmm-yyyy hh:mm:ss. For example, 01-Jan-2002 13:00:00. If this argument is not defined, the item revisions are searched until the current date. This argument is optional. -obj_type Specifies the object type to be searched. This argument is optional; if not defined, objects of all types are searched. -out_file Specifies the name of the file to which the list of item revisions is sent. This argument is optional; if not defined, the output is written to the standard output. The output includes key values. -outItemRevKeyFile Specifies the name of the item revision key file to which the list of item revisions is sent. This argument is optional; if not defined, the output is written to the standard output. -h Displays help for this utility. Environment This utility should be run from a shell where the Teamcenter environment is set. Files As specified in Log files produced by Teamcenter. Restrictions None. Examples To list all the item revisions released after January 01, 2002: Copy $TC_ROOT/bin/find_released_item_rev -start_date="01-Jan-2002 00:00:00" -out_file=released_items.txt

Source: https://docs.sw.siemens.com/documentation/external/PL20251212545240207/en-US/tc_help/utilities_reference/jhb1737253704745/find_released_item_rev.html · retrieved Fri Jul 31 2026 00:00:00 GMT+0000 (Coordinated Universal Time)