Skip to content

OctoSAM query documentation

CcpSkuLicenseMetric

Initializing search

OctoSAM query documentation

Introduction
Concepts
Concepts
- Query concepts
Entities
Entities
Queries
Queries
- Cloud
  Cloud
- Context
  Context
  - Group
    Group
    
    Group members
  - Machine
    Machine
    
    Installed software signatures
    
    Installed software
    
    Software usage detail
  - SoftwarePackage
    SoftwarePackage
    
    Installed on
    
    Repackaging details
    
    Software package usage
  - SoftwarePublisher
    SoftwarePublisher
    
    Software packages
  - SoftwareSignature
    SoftwareSignature
    
    Installed on
  - User
    User
    
    Software on all logged on machines
    
    Software usage detail
- Groups
  Groups
  - Group overview
  - Published software groups
- Internal
  Internal
  - Diagnose
    Diagnose
    
    CCP
    CCP
    
    Recognition
    Recognition
    
    File definition
    
    Software definition
    
    Sku
    Sku
    
    Sku
    
    Operating Systems
    Operating Systems
    
    Machines with multiple OS packages
    
    Machines with no installed OS package
    
    Windows OS detection differences
    
    All machines with last scanner build info
    
    Bogus signatures
    
    Duplicate host names
    
    Dynamic signature only installation detection
    
    Top unassigned signatures
    
    Unassigned Java signatures
    
    Unknown hardware manufacturers
    
    WMI and file system scan performance
  - Incubating
    Incubating
    
    CCP Pilot
    CCP Pilot
    
    Export anonymized hardware
    
    Export Installer signatures
    
    M365 dashboard beta
    M365 dashboard beta
    
    M365 active licensing plans
    
    M365 apps
    
    M365 user app usage
    
    M365 user details
    
    M365 user to licensing plan relation
    
    Microsoft SQL Server
    Microsoft SQL Server
    
    Microsoft SQL Server core licensing
    
    Adobe cloud licensed app on Windows usage
    
    All software items V2
    
    Micosoft Visio licensing plan and usage on Windows
    
    Microsoft Project licensing plan and usage on Windows
    
    NVMe disk drive health
    
    Oracle Database Overview
    
    Windows Server VM mobility on VMware ESX
  - Tables
    Tables
    
    Audit
    
    Machine
    
    SoftwareCategory
    
    SoftwarePackage
    
    SoftwarePublisher
    
    SoftwareSignature
    
    User
  - All organization tokens
  - Application log
  - Central configuration
  - Connected systems overview
  - Import service performance
  - Import service progress
  - OctoSAM query statistics
  - OctoSAM tables and columns
  - OctoSAM user statistics
  - Repository
  - Scanner messages
  - Scanner version overview
  - Scans per day and organization
  - Scans per day
  - Service messages
  - ServiceNow pending exports
  - Software catalog update conflicts
- License
  License
  - Windows Server
    Windows Server
    
    Windows Server bare metal licensing
    
    Windows Server Datacenter on ESX licensing
  - All software items
  - Deleted owners
  - Enterprise metering overview
  - Item owner details
  - Software packages with linked items
- Machines
  Machines
  - Hardware and configuration
    Hardware and configuration
    
    Displays
    
    Machine search by MAC-address
    
    Machines with hardware details
    
    Printers
    
    Processor details
    
    Windows AutoStart
    
    Windows service status
  - Hardware and software
    Hardware and software
    
    Machines with software and usage
    
    Machines with unassigned software signatures
  - Optimization
    Optimization
    
    Devices not scanned from Entra ID
    
    Duplicate host names
    
    Duplicate serial numbers
    
    Duplicate SMBIOS UUID
    
    Infrequently used machines
    
    Machines not scanned from Active Directory
    
    Scanned and not scanned machines combined
  - Security
    Security
    
    IPAddress history
  - Virtual machines
    Virtual machines
    
    Virtual machines overview
    
    VMWare Horizon clients
  - All machines with virtualization details
  - All machines
  - Clusters
- Monitor
  Monitor
  - Feature usage detail
  - Servers and features
- Software
  Software
  - Java
    Java
    
    Java lifecycle details
    
    Java lifecycle summary
    
    Java overview
    
    Java signature details
    
    Most installed licensing relevant Java signatures
    
    Oracle Java SE approved licensing relevant installations
    
    Oracle Java SE Auto Updater on Windows
    
    Oracle Java SE consolidation progress 2
    
    Oracle Java SE consolidation progress
    
    Oracle Java SE installation approval details
    
    Oracle Java SE MSI installer
    
    Oracle Java SE not approved installations
    
    Oracle Java SE versions summary
  - Publishers
    Publishers
    
    All software publishers
    
    Software publisher overview
  - Repackaging
    Repackaging
    
    Repackaged packages
    
    Repackaging info per machine
  - Signatures
    Signatures
    
    Signatures enterprise overview
    
    Signatures on selected machines
  - Software lifecycle
    Software lifecycle
    
    Microsoft SQL Server lifecycle
    
    Operating System lifecycle
  - Usage and optimization
    Usage and optimization
    
    Anaconda usage
    
    App-V usage and optimization
    
    Concurrent daily usage
    
    Infrequently used applications
    
    Microsoft Office Professional Plus 2013 Edition analysis
    
    Published software packages on servers (Citrix) usage
    
    Published software packages usage
    
    Usage details
    
    Usage frequency
  - User Access Logging
    User Access Logging
    
    Device access overview
    
    Microsoft SQL Server access overview
    
    User Access Logging overview
    
    User Access overview
  - Chromium browser extensions details
  - Chromium browser extensions overview
  - Enterprise installation details
  - Enterprise installation overview
  - Enterprise metering overview
  - Microsoft Office 2016 Usage
  - Microsoft Office 2024 Usage
  - Microsoft Office Add-ins
  - Microsoft SQL Server overview
  - Organization installation overview
  - Selected packages
- System
  System
  - Context
    Context
    
    Admin
    Admin
    
    AdminMailQueue
    
    Group
    Group
    
    GroupMachines
    
    GroupMembers
    
    GroupUsers
    
    LicenseManagerServer
    LicenseManagerServer
    
    LicenseManagerFeatureStatus
    
    LicenseManagerServerUserStatus
    
    LicenseManagerStatisticsFeatures
    
    LicenseManagerStatisticsUsers
    
    SoftwareItemByLicenseManagerServer
    
    Machine
    Machine
    
    HostedVirtualMachines
    
    InstalledSoftware
    
    InstalledSoftwareSignatures
    
    MachineAutoStart
    
    MachineGroups
    
    MachineOfficeAddIns
    
    MachineScanHistoryHistory
    
    MachineScanHistoryMessages
    
    MachineSoftwareUsage
    
    MachineUserAffinity
    
    MachineUserAutoStart
    
    MachineUserBrowserExtensions
    
    MachineUserOfficeAddIns
    
    MachineUsers
    
    UalAccessedServers
    
    UalDeviceAccess
    
    UalUserAccess
    
    VirtualMachineScanHistory
    
    SoftwareItem
    SoftwareItem
    
    InstallationSummary
    
    MachinesBySoftwareItem
    
    SignaturesBySoftwareItem
    
    SoftwareItemHistory
    
    SoftwarePackage
    SoftwarePackage
    
    InstalledOn
    
    PublishedSoftwareGroups
    
    SignaturesBySoftwarePackage
    
    SoftwareItemByPackage
    
    SoftwarePublisher
    SoftwarePublisher
    
    SoftwareItemsByPublisher
    
    SoftwarePackagesByPublisher
    
    SoftwareSignature
    SoftwareSignature
    
    InstalledOn
    
    User
    User
    
    CloudServicesAssignedUsersDetails
    
    Microsoft365AppUsage
    
    OwnedSoftwareItems
    
    RelevantSoftwareItems
    
    UalAccessedServers
    
    UserAutoStart
    
    UserBrowserExtensions
    
    UserGroups
    
    UserMachineAffinity
    
    UserMachines
    
    UserOfficeAddIns
    
    UserScanHistory
    
    UserSoftwareUsage
  - LicenseManagerServers
    LicenseManagerServers
    
    LicenseManagerServersIndex
  - My
    My
    
    MyOrganizations
  - Software
    Software
    
    SoftwarePackages
    SoftwarePackages
    
    SoftwarePackagesIndex
    
    SoftwarePublishers
    SoftwarePublishers
    
    SoftwarePublishersIndex
    
    SoftwareSignatures
    SoftwareSignatures
    
    SoftwareSignaturesIndex
- Users
  Users
  - Optimization
    Optimization
    
    Scanned and not scanned users combined
    
    Users not scanned from Active Directory
    
    Users not scanned from Entra ID
  - All users
  - Software usage per user
  - User scan history

Table of contents

Fields

CcpSkuLicenseMetric¶

Fields¶

Field	Type	Description
Created	datetime
ExtraData	string
ID	numeric
Name	string

CcpSkuLicenseProgram

Made with Material for MkDocs