InTrust comes with a set of scripts and utilities that serve a variety of purposes. Using these tools, you can do the following:
Some reports may create temporary tables (which have prefixes such as T_QCWP_TEMP_, TEMP_MACRO_ and TEMP_) in the data sources they work with. To avoid excessive database size growth, you can periodically remove temporary tables using the DBCleaner.exe command-line utility. This tool is located in the InTrust\Tools\Database CleanUp folder of your InTrust distribution.
When running the DBCleaner.exe utility, specify the following parameters:
Also, you can use the /from and /to parameters to delete tables created in the specified time interval. The date format is YYYY-MM-DD hh:mm:ss.
The format of the command line to run the utility should be like the following:
DBCleaner[.exe] /p[refix]:PREFIX /u[ser]:TABLE_OWNER [/from:DATE_FROM] [/to:DATE_TO] /c[onnection string]:CONNECTION_STRING
DBCleaner.exe /p:TEMP_ /u:DBO /from:2007-12-31 /to:2008-01-31 /c:"provider=SQLOLEDB; data source=DBServer; initial catalog=DBName; UID=UserName; PWD=test"
Caution: Be careful when specifying the prefix. If no prefix is specified or the prefix is specified incorrectly, necessary tables can be deleted.
The TempCleaner_2000.sql and TempCleaner_2005.sql scripts are located in the same folder as the DBCleaner.exe command-line utility and have the same functionality.
To customize the parameters, edit them directly in the script code before running the scripts.
The ITCustomAlertSeverity utility allows you to define custom severity level for InTrust real-time alerts.
It is located in <installation_folder>\Server\ADC\SupportTools\Win32.
Below are the examples of command line syntax that should be used when running the utility:
ITCustomAlertSeverity -add <name> <severity_value> <color> <icon_file>
ITCustomAlertSeverity –remove <name>
ITCustomAlertSeverity –export-icon <name> <icon_file>
The options are as follows:
Adds a custom alert severity level to the configuration; the following arguments must be specified:
|-REMOVE||Removes the severity level (not the alerts!) specified by the <name> argument from configuration.|
List all currently defined severity levels.
Export the icon associated with a severity level to an image file; the following arguments must be specified:
Use the adcsrvacc command-line utility to change the account of the Quest InTrust Server and Quest InTrust Real-Time Monitoring Server services. The adcsrvacc utility also lets you create a Service Connection Point (SCP) container and change its permissions and properties after starting the InTrust Server service.
This utility is located in <InTrust_installation_folder>\Server\ADC\SupportTools.
To provide automatic creation of SCP or changing its permissions and properties by InTrust means, you should perform one of the following procedures before running adcsrvacc:
Run the utility with the following parameters:
adcsrvacc.exe -user <user> [-password <password>] [-restart] [-nocheck]
Here, <user> is the name of the user account (in the DomainName\UserName format) you want the services to use from now on; <password> is an optional parameter specifying the password of this account. If the password is not supplied, you will be asked to specify it in a secure prompt.
The optional -restart parameter automatically restarts the services after the account change.
The optional -nocheck parameter makes the utility skip the step where it checks whether the new account has the necessary privileges for access to the InTrust configuration database.
For information about the privileges required by the InTrust Server account, see System Requirements.