This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Using the AREntryCounter utility

You can use the AREntryCounter utility to estimate total data size and delta data migration run time. The utility allows you to get the number of entries in the forms that are part of the DDM package. The utility can be run in the following ways:

  • Before delta data migration: You can run it to get the counts for all the forms for the date for which you want to use delta data migration. This gives you an idea of the total amount of data you have in your forms and how long delta data migration might take to migrate that data.
  • After delta data migration: You can run it to get the total counts for all the forms that delta data migration used. You can run it for your source and destination servers separately and compare the counts.

The following table describes the available options:

<options> value

Definitions

-d <DDM date>

Count entries that were created or modified after a specific date

The <DDM date> format is as follows:

mm/dd/yy hh:mm:ss

For example:

06/14/12 11:57:29

-k <package>

Construct the form list from the given Migrator package file

-o <output file>

The output file for the result report

-p <password>

The password for authenticating with the AR System server

-s <server>

The AR System server name

-u <user>

The user name for authenticating with the AR System server

-x <port>

The AR System server port.

Use the following syntax to run the utility for your package files (forms). Make sure to replace the keywords with your Migrator installation path and the server and version information.

Run the utility from the \DeltaDataMigration\Utilities\migratorutilities folder from a command prompt. You must run the counts for each product. The output file is available in the same folder where you ran the Delta Data Migration Tool.

AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\ARCore\<YOUR VERSION>\AR_Core_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "USERNAME" -p "PASSWORD" -x PORT -o AR_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\Atrium\CMDB\<YOUR VERSION>\AtriumPackage.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o AtriumCMDB_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\Atrium\AIE\<YOUR VERSION>\AIE_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o AtriumAIE_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\Atrium\ProductCatalog\<YOUR VERSION>\ProductCatalogpackage.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o AtriumPCT_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\ITSM\<YOUR VERSION>\ITSM_AST_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o Asset_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\ITSM\<YOUR VERSION>\ITSM_Change_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o Change_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\ITSM\<YOUR VERSION>\ITSM_SD_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o ServicDesk_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\ITSM\<YOUR VERSION>\ITSM_Fnd_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o ITSMFoundation_counts.txt 

 
AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\SRM\<YOUR VERSION>\SRM_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o SRM_counts.txt 

AREntryCounter.bat -k "<MigratorInstallationPath>\DeltaDataMigration\Packages\SLM\<YOUR VERSION>\SLM_Package.xml" -d "DDM DATE" -s "SERVERNAME" -u "Demo" -p "PASSWORD" -x PORT -o SLM_counts.txt

Where to go from here

Loading KMS:Associations form data

Was this page helpful? Yes No Submitting... Thank you

Comments

  1. David Petter

    Note to the link/reference below does not process successfully:

    Where to go from here

    Making modifications for Remedy Knowledge Management 7.5.x

    Oct 24, 2013 01:24
    1. Bruce Cane

      Thanks for pointing this out David. The link appears to be obsolete. I have replaced it with the current link, which appears to be working ok now. Let me know if you have any further issues with it.

      Oct 24, 2013 02:37
  2. Julio Goncalves

    It seems obvious but the DDM date above will work with the date format configured to your system.

    Please fix this page accordingly.

    Oct 24, 2013 09:21
    1. Bruce Cane

      Hello, I spoke to a subject matter expert who suggested that it is best to use the date format given in the documentation, because that is the format the tool understands to give correct counts.

      Let us know if you have further questions.

       

      Oct 29, 2013 12:30
  3. Earl Edwards

    Hello, the link for "Where to go from here"

    Making modifications for Remedy Knowledge Management 7.5.x

    Does not appear to be working correctly again; it takes you to a create page action.

    Could you please look into this again?

    Jun 17, 2014 11:49
    1. Bruce Cane

      Hello Earl, thanks for pointing this out. It looks like that information has changed and been moved to a different topic. I updated the link at the bottom of the page.

      Jun 25, 2014 09:15
  4. John Hood

    Was this utility removed for v8.1x? It does not exist anywhere beneath my "\Migrator" install path. I also checked all folders beneath my "\BMC Software" path and could not locate the batch file.

    Mar 04, 2015 10:07
    1. Bruce Cane

      Hello John,

      I'll check with my team and get back to you.

      -Bruce.

       

       

      Mar 04, 2015 02:39
      1. John Hood

        Disregard - A colleague pointed out some other oddities, so I've reinstalled Migrator. Apparently something went awry the first time as everything seems to be in place now. Sorry for jumping the gun.

        -JDH

        Mar 04, 2015 03:24
        1. Bruce Cane

          Great! I'm glad you got to the bottom of it. Thanks for letting us know.

          Mar 05, 2015 01:17