Software Metering View Reference
There is no official software metering view classification, but because several views contain information directly related to software metering in SMS, they have been grouped together and will be referred to as the software metering views.
Software Metering Views
The software metering views contain information such as the software metering rules that are created in the SMS hierarchy, which files to meter, the products in which the files belong, the users that have used the metered files, and so on. These views can be joined to other views most often by using the FileID, ResourceID, and SecurityKey columns. Software metering views are listed and described in the following table.
Software Metering View |
Description |
|---|---|
v_GS_SoftwareUsageData |
Lists all resources that have used metered files. The view contains the resource ID, start time, end time, user name, file ID, file name, file description, file version, file size, product name, product version, and so on. This is an inventory view type and combines data that would otherwise have to be retrieved from several different views. The view can be joined to other views by using the ResourceID, FileID, or UserName columns. |
v_MeterData |
Lists all software metering data, including the meter data ID, time span for the data, file ID, resource ID, user ID, and so on. The view can be joined to other views by using the FileID, ResourceID, or MeteredUserID columns. |
v_MeteredFiles |
Lists all files that are defined in the software metering rules and metered on clients. The view contains the software metering rule ID, security key, product name, site code, file name, file version, metered file ID, metered product ID, and so on. The view can be joined to other views by using the RuleID, SecurityKey, MeteredProductID, or MeteredFileID columns. |
v_MeteredProductRule |
Lists all software metering rules that have been defined in the SMS site hierarchy. The view contains the software metering rule ID, security key, product name, file name, file version, site code, and so on. The view can be joined to other views by using the RuleID or SecurityKey columns. |
v_MeteredUser |
Lists all users who have used metered files. The view contains the metered user ID, full user name (domain\user name), domain, and user name. The view can be joined to other views by using the MeteredUserID or FullName columns. |
v_MeterRuleInstallBase |
Lists all metered files for system resources that match files by FileID that are also in software inventory. The view contains the rule ID, product name, metered file ID, and resource ID. The view can be joined to other views by using the MeteredFileID or ResourceID columns. |