Guest

Cisco Unified MeetingPlace

MeetingPlace Web Reference Center Profile Request Retrieval

Hierarchical Navigation

Downloads

Document ID: 51043


Contents

Introduction
Prerequisites
      Requirements
      Components Used
      Conventions
Request Procedures
      Using Enterprise Manager
      Using osql.exe Commands
Related Information

Introduction

If the Cisco MeetingPlace Web (MPWEB) Reference Center profile request form is enabled, people can submit Cisco MeetingPlace profile requests to the system administrator. These requests are stored in the Cisco MPWEB Structured Query Language (SQL) database table.

The Cisco MPWEB System Manager's Guide (SMG) contains instructions on how to retrieve these requests from the SQL database using ASP.Net Enterprise Manager. However, Enterprise Manager is only available if you have installed the full version of Microsoft SQL Server 2000. In most cases, you may only have access to the Microsoft SQL Server Desktop Engine (MSDE). In the case of MSDE, you can use Object Structured Query Language (osql) commands.

Prerequisites

Requirements

There are no specific requirements for this document.

Components Used

The information in this document is based on these hardware and software versions.

  • Cisco MPWEB versions 4.3.0.x and later.

Conventions

For more information on document conventions, see the Cisco Technical Tips Conventions.

Request Procedures

Using Enterprise Manager

Follow the instructions provided below:

  1. Open Enterprise Manager (Start > Microsoft SQL Server > Enterprise Manager).

  2. Navigate to Databases > MPWEB > Tables > ProfileRequest.

  3. Right-click ProfileRequest and select Open Table > Return all rows.

  4. Using the information displayed, you can now create a Cisco MeetingPlace profile for each user request.

  5. Once you have created the profile, highlight the row or rows in the database and delete it.

Using osql.exe Commands

Follow the steps below:

  1. Open a DOS window, and use osql to perform a query and output to a text file that is wide enough so that the table is easy to read.

    Replace the password and output file with your own values.

    c:\osql -U sa -P password -D mpweb /Q "select * from ProfileRequest" /o outputfile -w 800
Example:
c:\osql -U sa -P latitude -D mpweb /Q "select * from ProfileRequest" /o profiles.txt -w 800

  2. Use the information in the output file to create profiles.

  3. Once you have created a profile, you can then delete that user's request from the database.

    Log in to OSQL, then select the database called MPWEB.

    1> use mpweb
2> go

    Repeat following commands for each user.

    1> delete ProfileRequest where firstname='xxx' and lastname='yyy'
2> go

Related Information

Updated: Jan 31, 2006 Document ID: 51043