Database Views: Product Information

Displays information about Control Manager, Managed Products, components, and licenses.

License Information

Managed Product License Status: Displays detailed information about the managed product and information about the Activation Code the managed product uses. Examples: managed product information, whether the Activation Code is active, the number of managed products the Activation Code activates

Data

Description

Managed Product Entity Display Name

The entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.      

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Product Service

The name of the managed product service. Example: Vulnerability Assessment, Outbreak Protection Service

License Status

Displays the status of the license for managed products. Example: Activated, Expired, In grace period

Activation Code

Displays the Activation Code for managed products.

Activation Code Count

Displays the number of Activation Codes a managed products uses.

License Expiration Date

Displays the date the license expires for the managed product

 

Managed Product License Information Summary: Displays detailed information about the Activation Code and information managed products which use the Activation Code. Examples: seat count the Activation Code allows, trial or full product version, user-defined description about the Activation Code

Data

Description

Activation Code

Displays the Activation Code for managed products.

User-defined Description

Displays the user-defined description for the Activation Code.

Managed Product/Service Count

Displays the number of managed products or services which use the Activation Code.

License Status

Displays the status of the license for managed products. Example: Activated, Expired, In grace period

Managed Product Type

Displays the type of managed product the Activation Code provides. Example: Trial version, Full version

License Expiration Date

Displays the date the license expires for the managed product

Seat Count

Displays the number of seats the Activation Code allows.

 

Detailed Managed Product License Information: Displays information about the Activation Code and information managed products which use the Activation Code. Examples: managed product information, trail or full product version, license expiration date

Data

Description

Managed Product Entity Display Name

The entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Service

The name of the managed service. Example: Vulnerability Assessment, Web Reputation Service

License Status

Displays the status of the license for managed products. Example: Activated, Expired, In grace period

Managed Product Type

Displays the type of managed product the Activation Code provides. Example: Trial version, Full version

Activation Code

Displays the Activation Code for managed products.

License Expiration Date

Displays the date the license expires for the managed product.

Seat Count

Displays the number of seats the Activation Code allows.

Description

Displays the description for the Activation Code.

 

 

Managed Product Information

Managed Product Distribution Summary: Displays summary information about managed products registered to Control Manager. Examples: managed product name, version number, and number of managed products

Data

Description

Registered to Control Manager

The Control Manager server to which the managed product is registered.     

Managed Product Category

The threat protection category for a managed product. Example: Server-based products, Desktop products

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Product Role

The role the managed product has in the network environment. Example: server, client

Managed Product Count

The total number of a specific managed product a network contains.

 

Managed Product Status Information: Displays detailed information about managed products registered to Control Manager. Examples: managed product version and build number, operating system

Data

Description

Managed Product Entity Display Name

The entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.         

Managed Product Host Name

The name of the server on which the managed product installs.

Managed Product IP Address

The IP address of the server on which the managed product installs.

Managed Product MAC Address

The MAC address of the server on which the managed product installs.

Managing Control Manager Entity Display Name

The entity display name of the Control Manager server to which the managed product is registered.

Managing Server Entity Display Name

The entity display name of the managed product server to which a client is registered.

Domain Name

The domain to which the managed product belongs.

Managed Product Connection Status

The managed product's connection status to Control Manager. Example: Normal, Abnormal, Offline

Pattern File Status

The status of the pattern files/rules the managed product uses. Example: up-to-date, out-of-date

Scan Engine Status

The status of the scan engines the managed product uses. Example: up-to-date, out-of-date

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Product Build Number

The build number of the managed product. This information appears on the About screen for products. Example: Version: 5.0 (Build 1219)

Managed Product Role

The role the managed product has in the network environment. Example: server, client

OS Name  

The operating system of the computer where the managed product installs.

OS Version

The version number of the operating system of the computer where the managed product installs.

OS Service Pack

The service pack number of the operating system of the computer where the managed product installs.

 

ServerProtect and OfficeScan Server/Domain Status Summary: Displays summary information about client/server managed products. Examples: pattern file out-of-date, scan engine out-of-date,

Data

Description

Managed Product Entity Display Name

The entity display name for a managed product.

Domain Name

The domain to which the managed product belongs.

Managed Server/Client Count

The number of managed product servers or managed product clients.

Pattern File Out-of-Date Server/Client

The number of managed product servers/clients with out-of-date pattern files.

Pattern File Up-to-Date Rate (%)

The percentage of managed product servers/clients with up-to-date pattern files.

Scan Engine Out-of-Date Server/Client

The number of managed product servers/clients with out-of-date scan engines.

Scan Engine Up-to-Date Rate (%)

The percentage of managed product servers/clients with up-to-date scan engines.

 

Managed Product Event Information: Displays information relating to managed product events. Examples: managed products registering to Control Manager, component updates, Activation Code deployments

Data

Description

Time Received from Entity

The time which Control Manager receives data about the managed product event.

Time Generated at Entity

The time which the managed product generates data about the event.

Managed Product Entity Display Name

The entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.   

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Event Severity

The severity of an event. Example: Information, Critical, Warning

Event Type

The type of event that occurred. Example: download virus found, file blocking, rollback

Command Status

The status of the command. Example: successful, unsuccessful, in progress

Description

The description a managed product provides for the event.

 

 

Component Information

Managed Product Scan Engine Status: Displays detailed information about scan engines managed products use. Examples: scan engine name,  time of the latest scan engine deployment, and which managed products use the scan engine

Data

Description

Managed Product Entity Display Name

Displays the entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.  

Managed Product Host Name

Displays the host name of the server on which the managed product installs.

Managed Product IP Address

Displays the IP address of the server on which the managed product installs.

Connection Status

Displays the connection status between the managed product and Control Manager server or managed products and their clients.

Managed Product Name

Displays the name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

Displays the managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Product Role

Displays the role the managed product has in the network environment. Example: server, client

Scan Engine Name

Displays the name of the scan engine. Example: Anti-spam Engine (Windows), Virus Scan Engine IA 64 bit Scan Engine

Scan Engine Version

Displays the version of the scan engine. Example: Anti-spam Engine (Windows): 3.000.1153, Virus Scan Engine IA 64 bit Scan Engine: 8.000.1008

Scan Engine Status

Displays the scan engine currency status. Example: up-to-date, out-of-date

Time of Latest Scan Engine Update

Displays the time of the latest status log reported by registered managed products.

 

Managed Product Pattern File/Rule Status: Displays detailed information about pattern files/rules managed products use. Examples: pattern file/rule name, time of the latest pattern file/rule deployment, and which managed products use the pattern file/rule

Data

Description

Managed Product Entity Display Name

Displays the entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.  

Managed Product Host Name

Displays the host name of the server on which the managed product installs.

Managed Product IP Address

Displays the IP address of the server on which the managed product installs.

Connection Status

Displays the connection status between the managed product and Control Manager server or managed products and their clients.

Managed Product Name

Displays the name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

Displays the managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Managed Product Role

Displays the role the managed product has in the network environment. Example: server, client

Pattern File/Rule Name

Displays the name of the pattern file or rule. Example: Virus Pattern File, Anti-spam Pattern

Pattern File/Rule Version

Displays the version of the pattern file or rule. Example: Virus Pattern File: 3.203.00, Anti-spam Pattern: 14256

Pattern File/Rule Status

Displays the pattern file/rule currency status. Example: up-to-date, out-of-date

Time of Latest Pattern File/Rule Update

Displays the time of the latest status log reported by registered managed products.

 

Managed Product Component Deployment: Displays detailed information about components managed products use. Examples: pattern file/rule name, pattern file/rule version number, and scan engine deployment status

Data

Description

Managed Product Entity Display Name

The entity display name for a managed product. Control Manager identifies managed products using the managed product's entity display name.  

Managed Product Name

The name of the managed product. Example: OfficeScan, ScanMail for Microsoft Exchange

Managed Product Version

The managed product's version number. Example: OfficeScan 8.0, Control Manager 3.5

Connection Status

Displays the connection status between the managed product and Control Manager server or managed products and their clients.

Pattern File/Rule Status

Displays the pattern file/rule currency status. Example: up-to-date, out-of-date

Pattern File/Rule Deployment Status

Displays the deployment status for the latest pattern file/rule update. Example: successful, unsuccessful, in progress

Time of Latest Pattern File/Rule Deployment

The time of the latest pattern file/rule deployment to managed products or clients.

Scan Engine Status

Displays the scan engine currency status. Example: up-to-date, out-of-date

Scan Engine Deployment Status

Displays the deployment status for the latest scan update. Example: successful, unsuccessful, in progress

Time of Latest Scan Engine Deployment

The time of the latest scan engine deployment to managed products or clients.

 

Scan Engine Status Summary: Displays summary information about scan engines managed products use. Examples: scan engine name, scan engine rate, and the number of scan engines out-of-date

Data

Description

Scan Engine Name

Displays the name of the scan engine. Example: Anti-spam Engine (Windows), Virus Scan Engine IA 64 bit Scan Engine

Scan Engine Version

The version of the scan engine. Example: Anti-spam Engine (Windows): 3.000.1153, Virus Scan Engine IA 64 bit Scan Engine: 8.000.1008

Scan Engines Up-to-Date

Displays the number of managed products with up-to-date scan engines.

Scan Engines Out-of-Date

Displays the number of managed products with out-of-date scan engines.

Scan Engine Up-to-Date Rate (%)

Displays the percentage of managed products with up-to-date scan engines. This includes scan engines that return N/A as a value.

 

Pattern File/Rule Status Summary: Displays summary information about pattern files/rules managed products use. Examples: pattern file/rule name, pattern file/rule up-to-date rate, and the number of pattern files/rules out-of-date

Data

Description

Pattern File/Rule Name

Displays the name of the pattern file or rule. Example: Virus Pattern File, Anti-spam Pattern

Pattern File/Rule Version

The version of the pattern file or rule. Example: Virus Pattern File: 3.203.00, Anti-spam Pattern: 14256

Pattern Files/Rules Up-to-Date

Displays the number of managed products with up-to-date pattern files or rules.

Pattern Files/Rules Out-of-Date

Displays the number of managed products with out-of-date pattern files or rules.

Pattern Files/Rules Up-to-Date Rate (%)

Displays the percentage of managed products with up-to-date pattern files/rules. This includes pattern files/rules that return n/a as a value.

 

 

Control Manager Information

User Access Information: Displays Control Manager user access and the activities users perform while logged on to Control Manager.

Data

Description

Time of Activity

Time the activity starts.

Log On User Name

The name of the user who initiates the activity.

Account Type

The account type a Control Manager administrator assigns to a user. For example: Root, Power User, or Operator.

Account Type Description

The description of the Account Type. This description comes from Control Manager for default account types and from user-defined descriptions for custom account types.

Activity

The activity the user performs on Control Manager. Example: log on, edit user account, add deployment plan

Activity Result

The result of the activity.

Description

Provides a description of the activity, if a description exists.

 

Control Manager Event Information: Displays information relating to Control Manager Server events. Examples: managed products registering to Control Manager, component updates, Activation Code deployments

Data

Description

Time of Event

Time the event occurred.

Event Type

The type of event that occurred. Example: notify TMI agent, server notify user, report service notify user

Event Result

The result of the event. Example: successful, unsuccessful

Description

Provides a description of the activity, if a description exists.

 

Command Tracking Information: Displays information relating to commands Control Manager delivers to managed products. Examples: managed products registering to Control Manager, component updates, Activation Code deployments

Data

Description

Time of Command

The time the issuer of the command issues the command.

Command Type

The type of command issued. Example: scheduled update, Activation Code deployment

Command Parameter

Displays the specific information relating to the command. Example: specific pattern file name, specific Activation Code

Issuer of Command

The user who issued the command.

Time of Latest Status Update

The time of the latest status check of all commands for the selected Control Manager.

Successful

The number of successful commands.

Unsuccessful

The number of unsuccessful commands.

In Progress

The number of commands that are still in progress.

All

The total number of commands (Successful + Unsuccessful + In progress).

 

Detailed Command Tracking Information:Displays detailed information relating to commands. Examples: managed products registering to Control Manager, component updates, Activation Code deployments

Data

Description

Time of Command

The time the command was issued.

Command Type

The type of command issued. Example: scheduled update, Activation Code deployment

Command Parameter

Displays the specific information relating to the command. Example: specific pattern file name, specific Activation Code

Managed Product Entity Display Name

The managed product to which the command was issued.

Issuer of Command

The user who issued the command.

Command Status

The status of the command: successful, unsuccessful, in progress

Time of Latest Status Update

The time of the latest status check of all commands for the selected Control Manager.

Result Detail Description

The description Control Manager provides for events.