Perforce 2008.2 P4Report User's Guide
Table of Contents
Index
Perforce on the Web
Next Chapter >>
About This Manual

Table of Contents


Preface: About This Manual

Please Give Us Feedback

Chapter 1: Configuring and Using P4Report

Configuring an ODBC Data Source

Reporting Using Microsoft Excel
Creating Queries Using the Query Wizard
Entering SQL Queries in Microsoft Excel

Using the Perforce SQL Command-Line Client
Launching the command line client
Running queries
The LIKE clause
Limiting the number of rows returned
ODBC syntax vs. SQL-92 syntax: joins and escape sequences

Query Performance
Avoid uncorrelated subqueries
Memory and CPU usage

Chapter 2: Administrative Reporting

What users made the most changes?

What has a specified user done in the past 24 hours?

What clients haven't been used in a year or more?

What users haven't been used in a year or more?

What clients belong to a specified user?

How many files/which files does a specified user have open?

Which groups contain a specified user?

What users have superuser privileges?

Chapter 3: Defect Tracking

Overview

What jobs are unassigned?

What jobs were entered by a specified user?

What jobs of a specified type are open?

How many jobs were closed in a specified branch this quarter?

A simple Excel pie chart: display open jobs by job type

A simple Excel bar chart: bug totals for the last four quarters

Chapter 4: Codeline Management

Which binaries in the mainline exceed 10M in size?

Which changelists affect a release?

How many changes are in this release?

Which changes are in this release?

Which files changed after being branched?

Is a particular change in a specified branch?

Appendix A: Database Schema and SQL Keywords

P4Report System Catalogs
SYSTABS
SYSTYPES
SYSCOLS
SYSIDXS

P4Report Tables
BRANCHES
CHANGES
CLIENTS
COUNTERS
FILES
FIXES
FSTAT
GROUPS
INFO
INTEGS
JOBS
LABELS
OPENED
PROTECTIONS
RESOLVED
USERS

SQL Keywords

Appendix B: P4Report Functions

Connection Information Functions

String Functions

Numeric Functions

Date and Time Functions

Appendix C: Sample Crystal Report Queries

Index


This manual copyright 2002-2008 Perforce Software.

All rights reserved.

Perforce software and documentation is available from http://www.perforce.com. You may download and use Perforce programs, but you may not sell or redistribute them. You may download, print, copy, edit, and redistribute the documentation, but you may not sell it, or sell any documentation derived from it. You may not modify or attempt to reverse engineer the programs.

Perforce programs and documents are available from our Web site as is. No warranty or support is provided. Warranties and support, along with higher capacity servers, are sold by Perforce Software.

Perforce Software assumes no responsibility or liability for any errors or inaccuracies that may appear in this book.

By downloading and using our programs and documents you agree to these terms.

Perforce and Inter-File Branching are trademarks of Perforce Software. Perforce software includes software developed by the University of California, Berkeley and its contributors.

Microsoft ®Excel and Microsoft ®Query © Microsoft Corporation; Crystal Reports © Seagate Software. All other brands or product names are trademarks or registered trademarks of their respective companies or organizations.


Perforce 2008.2 P4Report User's Guide
Table of Contents
Index
Perforce on the Web
Next Chapter >>
About This Manual
Please send comments and questions about this manual to manual@perforce.com.
Copyright 2002-2008 Perforce Software. All rights reserved.
Last updated: 12/05/08