Open topic with navigation

Database Commands

NOTE

Use of these commands is not recommended as they are no longer officially supported and may not work as intended.

The following is a list of the internal database commands of FootPrints, with short descriptions of their functions.  Each is discussed in more detail below, with syntax and examples.  

• mrABChange

Change the field of an Address Book Contact

• mrABList

List contacts in the Address Book based on search criteria

• mrABRegister

Create a single new contact

• mrABState

Change the state of a contact

• mrAppend

Append a new description to an Issue

• mrAssign

Assign users to an Issue

• mrAttach

Attach filenames to an Issue

• mrChange

Change the title, user field data, or most recent description data

• mrChangeTime

Change the time tracking date for an Issue

• mrDetails

View the details of an Issue

• mrEscalates

Escalate an Issue

• mrList,mrQuick,mrFast

List Issues based on search criteria

• mrNewPri

Change the priority of an Issue

• mrNewState

Change the status of an Issue/multiple Issues

• mrNewStates

Change the status of multiple Issues

• mrReference

Create a link between Issues

• mrRegister

Create a new Issue in the database

• mrShow

Show various fields for a given Issue

• mrTime

Read or write the time tracking data for an Issue

• mrUnassign

De-assign users from an Issue

• mrWriteHistory

Write the history for an Issue.

Command Syntax

To execute these mr<name> commands in the /bin directory correctly, you must use the correct syntax, which depends on the system on which FootPrints resides.  The mr<name> command is now the first argument to one of the following, which must prefix those commands:

• Windows SQL/Access:

perl\bin\perl mrFile.pl

• MySQL/Oracle/DB2/Postgres (Unix/Linux):

mrFile.pl

Examples:

• Windows SQL/Access:

c:\FootprintsServiceCore\bin\perl\bin\perl mrQuick.pl "mrSTATUS <> '_DELETED_'"

• MySQL/Oracle/DB2/Postgres (Unix/Linux):

mrQuick.pl "mrSTATUS <> '_DELETED_'"

©Copyright 1999, 2009 BMC Software, Inc. © Copyright 1996 - 2017 BladeLogic, Inc. BMC, BMC Software, and the BMC Software logo are the exclusive properties of BMC Software, Inc., are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BMC trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners. FootPrints is the exclusive property of BladeLogic, Inc. and is registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BladeLogic trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners.BladeLogic, Inc. and BMC Software, Inc. Confidential. Click here for the installation guide which includes the provisions described in the BMC License Agreement and Order related to third party products or technologies included in the BMC Product.