How to search for a representation by name?

Just to wrap things up,  I was able to use a SQL query to find all the representations named batch and then use the DeleteRepUtil to delete them.  I chose to use this method because it was faster and had less impact on the running production server.  The same results could be achieved using just the utility, but it was much more resource intensive and disruptive to the server and user performance was noticeably affected.

My Procedure:

1. Log into DB server
2. Start MS SQL Server Management Studio
   1. Login as db user
3. Run SQL query
4. Save results to text file.
5. Copy text file to APP server.
6. Break single large text file into smaller files of approximately 5000 lines each as needed to minimize impact to performance.
7. Start Windchill shell
8. Run DeleteRepUtil  with the -f option to read the file.

SQL Queries:  (Note, I am new to SQL, and borrowed heavily from the Community to put this together.  Also there may be better ways to accomplish the same thing...)

SQL Query (Product):  Change name for each product to run this against.

select

  derived.idA2A2

from

  DerivedImage derived, WTPart part , PDMLinkProduct prod

where

  part.idA2A2=derived.idA3theRepresentableReferenc and

  part.idA3containerReference =prod .idA2A2 and

  prod.namecontainerInfo ='<product name=">' and

  derived.name='batch'

Union All

Select

  derived.idA2A2

from

  DerivedImage derived, EPMDocument epmdoc , PDMLinkProduct prod

where

  epmdoc.idA2A2=derived.idA3theRepresentableReferenc and

  epmdoc.idA3containerReference =prod .idA2A2 and

  prod.namecontainerInfo ='<product name=">' and

  derived.name='batch' ;

SQL Query (Library): Change name for each library to run this against

select

  derived.idA2A2

from

  DerivedImage derived, WTPart part, WTLibrary lib

where

  part.idA2A2=derived.idA3theRepresentableReferenc and

  part.idA3containerReference=lib.idA2A2 and

  lib.namecontainerInfo='<library name=">' and

  derived.name='batch'

UnionAll

Select

  derived.idA2A2

from

  DerivedImage derived, EPMDocument epmdoc, WTLibrary lib

where

  epmdoc.idA2A2=derived.idA3theRepresentableReferenc and

  epmdoc.idA3containerReference=lib.idA2A2 and

  lib.namecontainerInfo='<library name=">' and

  derived.name='batch';

Note:  Replace <library name="> with name of library.   Likewise for <product name=">, replace with name of product.

Sample utility line syntax:

windchill com.ptc.wvs.server.util.DeleteRepUtil -f D:\20150902-batchreps\batchreps01.txt -u siteadmin -p password -q