App-V usage and optimization
Detected package usage for APP-V packages compared to group membership.
Fields
| Name |
Type |
Visible |
Description |
| Organization ID |
numeric |
false |
Internal ID that references the Organization entity (Foreign Key) |
| Organization |
string |
true |
Name of the organization this entity is mapped to |
| User ID |
numeric |
false |
OctoSAM Inventory internal ID of the user entity |
| User Guid |
guid |
false |
OctoSAM Inventory internal Guid of the user entity |
| User |
string |
true |
Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users |
| Login Name |
string |
false |
User's login name |
| Domain Name |
string |
false |
Windows NETBIOS Domain Name |
| Machine ID |
numeric |
false |
Internal ID for the Machine entity (Primary Key) |
| Machine Guid |
guid |
false |
A unique ID that can be used to link to this machine object by external applications |
| Machine |
string |
true |
Distinct machine name. Use Column Chooser to show partial values such as Name or Domain of machines |
| Usage Date |
date |
true |
Date of the usage record |
| Time |
numeric |
true |
Usage Time for this usage record |
| Signature |
string |
true |
Software signature as reported by the OctoSAM scanners |
| Software Package ID |
numeric |
false |
Internal ID that references the SoftwarePackage entity (Foreign Key) |
| Software Package Guid |
guid |
false |
GUID used for catalog updates. Stays the same for all OctoSAM defined software packages through the lifecycle of the package definition. Allows rename and delete of packages during catalog update.. Do not set if definig your own custom packages directly in the database. |
| Software Package |
string |
true |
Software package name from the OctoSAM software catalog |
| Software Publisher ID |
numeric |
false |
Internal ID that references the SoftwarePublisher entity (Foreign Key) |
| Software Publisher Guid |
guid |
false |
OctoSAM internal Guid of this software publisher entity |
| Software Publisher |
string |
false |
Normalized software publisher from the OctoSAM catalog |
| Package ID |
string |
false |
App-V Package ID |
| Package Version ID |
string |
false |
App-V Version ID |
| Current Date Time |
date |
false |
Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query
| Property |
Value |
Description |
| Query Guid |
b08d2114-fa11-4f4c-af95-11135e352fee |
The internal id of the query. Must be unique |
| SupportsDesktop |
true |
If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb |
true |
If true, the query can be started from the OctoSAM Web UI |