SCCM data imported into Assets
The data collected from SCCM is assembled and imported into Assets and looks like this in Assets:
Object Schema Tree:
Resource Type
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT |
User
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Resource Type | Object - Resource Type | Reference to the resource type. | "Id" = ${Resource Type} | ||
AD Creation Date | DATE_TIME | The date and time when the user object was created at the ActiveDirectory. | |||
Full User Name | TEXT | ||||
Principal Name | TEXT | ||||
Unique Name | TEXT | ||||
Systems | Object - System | Reference to the system that where used by the user. | "Id" IN (${Systems${0}}) |
User Groups
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Resource Type | Object - Resource Type | Reference to the resource type. | "Id" = ${Resource Type} | ||
Domain Name | TEXT |
System
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Status | STATUS | ||||
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Resource Type | Object - Resource Type | Reference to the resource type. | "Id" = ${Resource Type} | ||
Netbios Name | TEXT | ||||
Domain | TEXT | ||||
Workgroup | TEXT | ||||
Active | BOOLEAN | ||||
Ram | INTEGER | ||||
Client installed | BOOLEAN | shows if the SCCM Client is installed. | |||
Client version | TEXT | ||||
Decommissioned | BOOLEAN | ||||
Install Date | DATE_TIME | Date of the installation. | |||
Last Boot up time | DATE_TIME | Date of the installation. | |||
Manufacturer | TEXT | ||||
Model | TEXT | ||||
Serial Number | TEXT | ||||
Asset Tag | TEXT | ||||
Chassis Type | TEXT | ||||
Roles | TEXTAREA | Server Roles. | |||
Top console user | Object - User | Reference to the top console user. | "Resource Id" = ${Top console user} | ||
Primary user | Object - User | Reference to the primary user. | "Resource Id" = ${Primary user} | ||
Last user | Object - User | Reference to the last logged on user. | "Name" = ${Last user} | ||
Operating System | Object - Operating System | Reference to the operating system. | "Resource Id" = ${Operating System} | ||
Network Interfaces | Object - Network Interface | Reference to the connected NetworkInterfaces. | "Resource Id" IN (${Network Interfaces${0}}) | ||
CPUs | Object - CPU | Reference to the connected cpus. | "Resource Id" IN (${CPUs${0}}) | ||
File System | Object - File System | Reference to the connected file systems. | "Resource Id" IN (${File System${0}}) | ||
SCCM Roles | Object - Site Role | "Name" IN (${SCCM Roles${0}}) | |||
Site | Object - Site | The assigned site for the system. | "Id" = ${Site} |
Unknown System
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Resource Type | Object - Resource Type | Reference to the resource type. | "Id" = ${Resource Type} | ||
CPU Type | TEXT | ||||
Site | Object - Site | The assigned site for the system. | "Id" = ${Site} | ||
Decommissioned | BOOLEAN |
Mobile Device
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Resource Type | Object - Resource Type | Reference to the resource type. | "Id" = ${Resource Type} | ||
Cellular Technology | TEXT | ||||
Manufacturer | TEXT | ||||
Model | TEXT | ||||
DM Version | TEXT | ||||
Firmware Version | TEXT | ||||
Hardware Version | TEXT | ||||
IMEI | TEXT | ||||
IMSI | TEXT | ||||
Activation Lock | BOOLEAN | ||||
Jailbroken | BOOLEAN | ||||
MEID | TEXT | ||||
OEM | TEXT | ||||
Phone Number | TEXT | ||||
Platform Type | TEXT | ||||
Processor Architecture | TEXT | ||||
Processor Level | TEXT | ||||
Processor Revision | TEXT | ||||
Product | TEXT | ||||
Product Version | TEXT | ||||
Serial Number | TEXT | ||||
Software Version | TEXT | ||||
Subscriber Carrier Network | TEXT |
Network Interface
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Device Id | TEXT | The identifier set by the operating system. | |||
Description | TEXT | Description of the interface. | |||
Manufacturer | TEXT | ||||
Adapter Type | TEXT | ||||
MAC Address | TEXT | A unique identifier assigned to network interfaces for communications at the data link layer of a network segment. | |||
Gateway | TEXT | Gateway address assigned to the interface. | |||
DHCP Enabled | BOOLEAN | shows if DHCP is enabled | |||
DHCP Server | TEXT | DHCP Server assigned to the interface. | |||
DHCP Lease obtained | DATE_TIME | ||||
DHCP Lease expired | DATE_TIME | ||||
IP Enabled | BOOLEAN | ||||
IP Addresses | TEXTAREA | ||||
IP Subnet | TEXT | IP Addresses assigned to the interface. | |||
IP Filter Security enabled | BOOLEAN | ||||
IP Port Security enabled | BOOLEAN |
Operating System
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Manufacturer | TEXT | Manufacturer of the Operating System or Distribution. | |||
OS Architecture | TEXT | Information about the underling processor architecture. | |||
Version | TEXT | Main version of the operating system. | |||
Build Number | TEXT | Build number of the operating system. | |||
ServicePack Major Version | TEXT | Version of the installed Major Service Pack. | |||
ServicePack Minor Version | TEXT | Version of the installed Minor Service Pack. | |||
Serial Number | TEXT | OS Serialnumber. | |||
System Directory | TEXT | ||||
Windows Directory | TEXT | ||||
Last Boot up time | DATE_TIME |
CPU
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Device Id | TEXT | Manufacturer of the CPU. | |||
Manufacturer | TEXT | Manufacturer of the CPU. | |||
Cores Per Processor | INTEGER | Amount of cores that the CPU has. | |||
Max CPU Speed | INTEGER | Maximum clock frequency of the CPU. | |||
is 64bit | BOOLEAN | shows if the device is a 64bit CPU. |
File System
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Encryption | STATUS | ||||
Mount | TEXT | Used mount path or letter for the filesystem. | |||
Size | INTEGER | Total available size of the filesystem. | |||
Used | INTEGER | Used space of the filesystem. | |||
Free | INTEGER | Available free space of the filesystem. | |||
Compressed | BOOLEAN | shows if the file system is compressed. | |||
File System Type | TEXT | Type of the file system. | |||
Serial Number | TEXT | Serialnumber of the volume. |
Application
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
System | Object - System | Reference to the system. | "Resource Id" = ${System} | ||
Install Date | DATE_TIME | Date when the application was installed on the system. | |||
Install Location | TEXT | Location where the application is installed on the system. | |||
Vendor | TEXT | Vendor of the application. | |||
Version | TEXT | Version of the application. |
Application Service
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Description | TEXT | Description of the application service. | |||
Service Type | TEXT | Type of the service. | |||
Start Mode | TEXT | Start mode of the service. | |||
Started | BOOLEAN | Indicate if the service is running. | |||
Start Account | TEXT | Account that is executing the service. | |||
Path | TEXT | Start path of the service. | |||
System | Object - System | Reference to the system. | "Resource Id" = ${System} |
File
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Resource Id | TEXT |
| The identifier of the SCCM Resource Object. | ||
Description | TEXT | ||||
Version | TEXT | ||||
Size | INTEGER | Size of the file in bytes. | |||
File Path | TEXT | ||||
Modified Date | DATE_TIME | ||||
System | Object - System | Reference to the system. | "Resource Id" = ${System} | ||
Software Product | Object - Software Product | The software product of this file. | "Product Ids" LIKE ${Software Product} |
Software Product
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Company | TEXT | ||||
Product Version | TEXT | ||||
Product Ids | TEXT |
Application Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN |
Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN | ||||
Programs | Object - Program | The programs that belongs to this package. | "Package Id" IN (${Id${0}}) |
Program
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Dependent program | Object - Program | The program that runs before. | "Id" = ${Dependent program} | ||
Site | Object - Site | The assigned Site for the program. | "Id" = ${Source Site} | ||
Command | TEXT | ||||
Working dir | TEXT | ||||
User Description | TEXTAREA | ||||
Requirements | TEXTAREA | ||||
Disk space | TEXT | ||||
Drive letter | TEXT | ||||
Removal key | TEXT | ||||
Package Id | TEXT |
Software Updates Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN |
Driver Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN | ||||
Drivers | Object - Driver | The drivers that are associated to the driver package. | "Id" IN (${Drivers${0}}) |
Driver
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Type | TEXT | ||||
File | TEXT | ||||
Driver Date | DATE_TIME | ||||
Version | TEXT | ||||
Class | TEXT | ||||
Provider | TEXT | ||||
Signed | BOOLEAN | ||||
Signer | TEXT | ||||
Boot Critical | BOOLEAN |
Boot Image Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN | ||||
Image OS Version | TEXT | ||||
Production Client Version | TEXT |
OS Install Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN | ||||
Image OS Version | TEXT |
Device Setting Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN |
Image Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN | ||||
Image OS Version | TEXT |
Legacy Image Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN |
VHD Package
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Version | TEXT | ||||
Language | TEXT | ||||
Manufacturer | TEXT | ||||
Size | INTEGER | ||||
Pre download rule | TEXT | ||||
Site | Object - Site | The assigned Site for the Deployment Package. | "Id" = ${Source Site} | ||
Source | TEXT | ||||
Source Path | TEXT | ||||
Stored Path | TEXT | ||||
Refresh Schedule | TEXT | ||||
Share Name | TEXT | ||||
Preferred Address | TEXT | ||||
Last Refresh | DATE_TIME | ||||
Use forced disconnect | BOOLEAN | ||||
Forced retry delay | INTEGER | ||||
Disconnect delay | INTEGER | ||||
Ignore schedule | BOOLEAN |
Site
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Type | TEXT | ||||
Server Name | TEXT | ||||
Version | TEXT | ||||
Build Number | TEXT | ||||
Reporting Site Code | TEXT | ||||
Install Location | TEXT | ||||
Site Roles | Object - Site Role | "Name" IN (${Site Roles${0}}) |
Site Role
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Name | TEXT |
|
|
Boundary Group
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
GUID | TEXT | ||||
Description | TEXTAREA | ||||
Modified Date | DATE_TIME | ||||
Site | Object - Site | The assigned Site for the Boundary Group. | "Id" = ${Site} | ||
Created by | Object - User | The user that have created the Boundary Group. | "Unique Name" = ${Created by} | ||
Modified by | Object - User | The user that have modified the Boundary Group. | "Unique Name" = ${Modified by} | ||
Boundaries | Object - Boundary | "Id" IN (${Boundaries${0}}) |
Boundary
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Boundary Type | TEXT | ||||
Modified Date | DATE_TIME | ||||
Created by | Object - User | The user that have created the Boundary. | "Unique Name" = ${Created by} | ||
Modified by | Object - User | The user that have modified the Boundary. | "Unique Name" = ${Modified by} |
Distribution Point
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Share Name | TEXT | ||||
Drive | TEXT | ||||
Location | TEXT | ||||
Site | Object - Site | The assigned Site for the Distribution Point. | "Id" = ${Site} | ||
Description | TEXT | ||||
Version | TEXT | ||||
Resource Type | TEXT | ||||
Operating System | TEXT | ||||
Distribution Point Groups | Object - Distribution Point Group | Distribution Point Groups that belongs to this Distribution Point. | "Id" IN (${Distribution Point Groups${0}}) | ||
Peer DP | BOOLEAN | ||||
Pull DP | BOOLEAN | ||||
Bits Enabled | BOOLEAN | ||||
Multicast | BOOLEAN | ||||
Protected | BOOLEAN | ||||
Pre-Staging Allowed | BOOLEAN | ||||
Communication | BOOLEAN | ||||
Has Relationship | BOOLEAN | ||||
Internet Facing | BOOLEAN | ||||
Health Check Enabled | BOOLEAN |
Distribution Point Group
Attribute | Default Type | Default Identifier | Unique | Description | AQL |
|---|---|---|---|---|---|
Id | TEXT |
| The identifier of the SCCM Object. | ||
Name | TEXT | ||||
Description | TEXTAREA | ||||
Creation Date | DATE_TIME | The date and time when the object was created in the SCCM Database. | |||
Modified Date | DATE_TIME | The date and time when the object was modified in the SCCM Database. | |||
Site | Object - Site | The assigned Site for the Distribution Point Group. | "Id" = ${Site} | ||
Has Member | BOOLEAN | ||||
Has Relationship | BOOLEAN |