Usage: ClmUtil Options -sync CAMachine Synchronize the CA database and the FIM CM database (Certificates table) CAMachine ...

Usage:
  ClmUtil [Options] -sync CAMachine
  Synchronize the CA database and the FIM CM database (Certificates table)
  CAMachine is the path to the CA
  
Options:
  -overwrite     -- Copy all rows across databases.  Default
  -unique        -- Copy rows that do not overlap across databases

  -test          -- View what operations will take place

  -name Type     -- Describes how names are looked up for a certificate in 
                    the CA database. 
                    Type can be one of: subject,requestername,upn,email, or
                    a hard-coded nt4 name. Default is requestername.

  -submitted d e -- Show rows where submitted date is between d and e inclusive
  -submitted +d  -- Show rows where submitted date is after d inclusive
  -submitted *d  -- Show rows where submitted date is before d inclusive

  -completed d e -- Show rows where completed date is between d and e inclusive
  -completed +d  -- Show rows where completed date is after d inclusive
  -completed *d  -- Show rows where completed date is before d inclusive

  -requestid l u -- Show rows where request id is between l and u inclusive
  -requestid +l  -- Show rows where request id is after l inclusive
  -requestid *l  -- Show rows where request id is before d inclusive

Examples:
  ClmUtil -overwrite -sync testpc.mydomain.com	estCA
      Copies all requests from the CA to the Certificates table.
      The database connection string is stored in the ClmUtil configuration file.
      Rows will be overwritten in the Certificates table.

  ClmUtil -unique -sync testpc.mydomain.com	estCA
      Copies those requests from the CA to the Certificates table
      which do not already exist in the Certificates table.  Hence,
      no overwrites will occur.

  ClmUtil -test -overwrite -sync testpc.mydomain.com	estCA
      Displays a list of all the request id's that would be
      copied over to the Certificates table if the '-test' 
      argument were removed.

  ClmUtil -unique -submitted "+{0}" -sync testpc.mydomain.com	estCA
      Copies those requests from the CA to the Certificates table
      which do not already exist in the Certificates table.  Hence,
      no overwrites will occur.  Moreover, only those rows will be
      copied whose submitted date also occurs on or after {1}    
 
  ClmUtil -overwrite -requestid 10 20 -sync testpc.mydomain.com	estCA
      Copies all requests from the CA to the Certificates table whose
      request id is between 10 and 20 inclusive.

  ClmUtil -unique -submitted "*{2} {3}" -sync testpc.mydomain.com	estCA
      Copies those requests from the CA to the Certificates table
      which do not already exist in the Certificates table.  Hence,
      no overwrites will occur.  Moreover, only those rows will be
      copied whose submitted date also occurs on or before {4} {5}  

  ClmUtil -completed "{6}" "{7}" -sync testpc.mydomain.com	estCA
      Copies all rows to the Certificates table which satisfies the constraint
      that the completed date occurs between {8} and {9}
      inclusive    
 

ClmUtil -?        -- Display verb list
ClmUtil -sync -?  -- Display help text for 'sync' command