EN
Español
English
Português
    AMDM_DEVICESOFTWARE

    Stores catalog information of installed apps associated with a device

    Data model

    Fields

    Field Type Description
    appinfo_id INT Application ID in Table AMDM_APPSINFORMATION
    appname NVARCHAR (512) Name of the installed application
    device_id* INT Identifier of the device on which the app is installed, reference to the AMDM_DEVICE.dev_id table
    dynamicsize BIGINT Dynamic size of the installed application
    id* INT Unique identifier for an app installed on a device
    issystem BIT Determines if the installed app is marked as a system app on the device
    isupdated* BIT Determines if the app installed on the device is up to date
    origin NVARCHAR (32) Origin of the installed application, indicating whether it is from the store or from third parties
    packagename NVARCHAR (512) Package name of the installed application
    storagesize BIGINT Storage size of the installed application
    targetsdk NVARCHAR (128) API version with which the installed application was compiled
    version NVARCHAR (128) Installed app version

    Primary Key

    PK_AMDMDEVICESOFTWARE
    id

    References

    Column Referenced Table Referenced column Name
    device_id* dbo.AMDM_DEVICE id FK01_AMDMDEVICESOFTWARE