Track License Counts and Usage

Check and monitor license usage in Vista using one or more of the following methods.

On the VA License Usage by Day Report

Assess the licenses in use on the VA License Usage by Day report. For details, see Assess License Usage.

On the VA User Profile Form

Open the VA User Profile form and see the License Type for each user in your organization.

On the VA System Users Report

Use the VA System Users report to inspect user profiles and filter by license status and/or license type.

With a SQL Query

Identify which forms and reports require an Office license. Use the following SQL query to find active Vista Office licenses:

select VPUserName, LicenseType, DeactivatedDate, UserAccountTypeID, UserType, ExpiryDate

from DDUP

where LicenseType = 'Office'

and DeactivatedDate is null

and UserAccountTypeID = 0

and UserType = 0

and (ExpiryDate Is Null or ExpiryDate >= GETDATE())

Note: If you want to find active PM licenses, change the LicenseType to 'PM'.

With VA License Type Inquiries in Work Center

Add VA License Type inquiries to a Work Center to identify forms requiring an Office license or those available to PM licenses.
  • VAFormsOfficeLicenseReq

    Use this inquiry to identify forms that require an Office license or forms available to PM licenses.

  • VAReportsOfficeLicenseReq

    Use this inquiry to identify reports that require an Office license or reports available to PM licenses.

For more information about setting up inquiries and adding them to a Work Center, see Creating Inquiries.

On the Trimble Construction One Admin Center

If you have access, view or export license data from the Trimble Construction One Admin Center in a consolidated .CSV file report. For details and steps, see Export License Data.