Integration

Table 2‑7. Attributes that ModuleAndEventText Messages Use (Continued)
Attribute Name Description
SVIAdminID Identifier of a QuickPrep domain.
SVIAdminName Name of a QuickPrep domain.
SVIDeploymentGroupID Identifier of a View Composer deployment group.
SVIOperation Name of a View Composer operation.
SVIParentVM Parent virtual machine in View Composer.
SVIPath Path of an object in View Composer.
SVISnapshot Snapshot in View Composer.
SVIVMID Identifier of a virtual machine in View Composer.
ThinAppDisplayName Display name of a ThinApp object.
ThinAppId Identifier of a ThinApp object.
ThinAppRepositoryName Name of a ThinApp repository
ThinAppRepositoryPath Path of a ThinApp repository.
Time Date and time value.
UserCount Maximum number of desktop users over a 24-hour period.
UserDiskName Name of a user data disk.
UserDisplayName User name in the form DOMAIN\username.
UserName Name of a user in Active Directory.
VCAddress URL of a vCenter Server.
Sample Database Queries and Views
You can query the event_historical database to display error events, warning events, and specific recent
events.
Note Replace the dbo.VE_ prefix in the following examples with the appropriate prefix for your event
database.
List Error Events
The following query displays all error events from the event_historical table.
CREATE VIEW error_events AS
(
SELECT ev.EventID, ev.Time, ev.Module, ev.EventType, ev.ModuleAndEventText
FROM dbo.VE_event_historical AS ev
WHERE ev.Severity = ‘ERROR’
);
View Integration
VMware, Inc. 26