MicroStrategy ONE

Create Contact statement

Creates a contact.

Copy 
CREATE CONTACT "contact_name" [DESCRIPTION "description"] [ADDRESSES NAME "address_name1" PHYSICALADDRESS "physical_address" DELIVERYTYPE (EMAIL | FILE | PRINT) DEVICE "device_name" 
 [SETASDEFAULT (TRUE | FALSE) [, .. NAME "address_nameN" PHYSICALADDRESS "physical_address" DELIVERYTYPE (EMAIL | FILE | PRINT) DEVICE "device_name" 
 [SETASDEFAULT (TRUE | FALSE)]] [LINKMSTRUSER "user_id"] 
 [(ENABLED|DISABLED)];

where:

  • CONTACT "contact_name" is the name of the new contact, of type string.

  • DESCRIPTION "description" is a description of the contact, of type string.

  • ADDRESSES is a comma-separated list of address information for the contact:

    • NAME "address_name1..N" is the name of the address, of type string, such as "Email."

    • PHYSICAL ADDRESS "physical_address" is the address, of type string, such as "mcwhite@workplace.com" if the DELIVERYTYPE is EMAIL.

    • DELIVERYTYPE indicates how information is delivered to the address:

      • EMAIL indicates that the physical address is an email address.

      • FILE indicates that the physical address is a file address.

      • PRINT indicates that the physical address is a print address.

    • DEVICE "device_name" is the name of the device used to deliver messages to this address, of type string.

    • SETASDEFAULT indicates whether to set this address as the default address for the contact.

  • LINKMSTRUSER "user_id" is the MicroStrategy user to link to the contact. The security profile settings for the linked user are assigned to the contact.

  • ENABLED | DISABLED indicates whether the contact can have deliveries made to it in the MicroStrategy system. Disabling a contact does not disable the user account in MicroStrategy.

Example

Copy 
CREATE CONTACT "Michael 
 White" ADDRESSES NAME "Email" PHYSICALADDRESS "mwhite@workplace.com" 
 DELIVERYTYPE EMAIL DEVICE "Generic Email" SETASDEFAULT TRUE, 
 NAME "Print" PHYSICALADDRESS "Microsoft XPS Document Writer" 
 DELIVERYTYPE PRINT DEVICE "User selected printer", NAME "File" 
 PHYSICALADDRESS "C:\Desktop\Deliveries" DELIVERYTYPE FILE DEVICE 
 "User selected location" LINKMSTRUSER "mwhite" ENABLED;