Data imported into Insight

The data collected from SCCM are assembled and imported into Insight and looks like this in Insight:

Object Schema Tree:

Resource Type

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





User

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Status

STATUS





Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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





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}

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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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





Network Interface

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


The identifier of the SCCM Object.


Name

TEXT





Resource Id

TEXT

(tick)


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}

Site

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Id

TEXT

(tick)


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

IQL

Name

TEXT

(tick)

(tick)



Boundary Group

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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}

Application Package

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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





Boot Image Package

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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





Device Setting Package

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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





OS Install Package

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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





Software Updates Package

Attribute

Default Type

Default Identifier

Unique

Description

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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

IQL

Creation Date

DATE_TIME



The date and time when the object was created in the SCCM Database.


Id

TEXT

(tick)


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