Search Knowledge Base by Keyword
-
Introduction
-
Fundamentals
-
Favorites
-
Analytics
-
-
-
-
- Available Reports
- All Asset Types
- Application Certification Status
- Application Discovery
- Application Group Analysis
- App Group to SCCM Collection Analysis
- Application Install Count
- Application License Management
- Application Usage
- Asset Column Mappings
- Asset Count by Property
- Asset Links Count by Asset Type
- Build Sheet
- Computer User Assignment
- Delegate Relationships
- ETL Synch Data
- ETL5 Staging Data
- Migration Readiness (Basic)
- Migration Readiness (Complex)
- O365 License Management
- O365 Migration Readiness
- Patch Summary
- SCCM OSD Status
- Scheduled Computers by Wave
- Scheduled Users by Manager
- User Migration Readiness
- VIP Users
- Wave & Task Details
- Wave Group
- Windows 10 Applications
- Show all articles ( 15 ) Collapse Articles
-
-
-
-
-
Orchestration
-
Data
-
-
- View Asset
- Asset Properties
- Images
- Notes
- Waves
- Tasks
- Attachments
- History
- Rationalization
- QR Code
- Linked Assets
- SCCM Add/Remove Programs
- Altiris Add/Remove Programs
- Related Assets
- Relationship Chart
- Permissions
- Show all articles ( 1 ) Collapse Articles
-
Integration
-
-
-
- View Connection
- Connection Properties
- Make Into Connector
- Delete Connection
- Inbound Jobs
- Outbound Jobs
- New Inbound Job
- New Outbound Job
- Enable Job
- Disable Job
- Edit Inbound Job
- Edit Outbound Job
- Upload File
- Run Inbound Job
- Run Outbound Job
- Set Runtime to Now
- Reset Job
- Delete Job
- Job Log
- Show all articles ( 4 ) Collapse Articles
-
-
- View Connector
- Connector Properties
- Authentication Methods
- New Authentication Method
- Edit Authentication Method
- Delete Authentication Method
- Fields
- Edit Field
- Inbound Job Fields
- Edit Inbound Job Field
- Inbound Job Templates
- New Inbound Job Template
- Edit Inbound Job Template
- Delete Inbound Job Template
- Outbound Job Fields
- Edit Outbound Job Field
- Outbound Job Templates
- New Outbound Job Template
- Edit Outbound Job Template
- Delete Outbound Job Template
- Show all articles ( 5 ) Collapse Articles
-
-
- ETL5 Connectors
- Absolute
- Azure Active Directory
- Comma-Separated Values (CSV) File
- Generic Rest JSON API
- Generic Rest XML API
- Ivanti (Landesk)
- JAMF
- JSON Data (JSON) File
- MariaDB
- Microsoft Endpoint Manager: Configuration Manager
- Microsoft SQL
- Microsoft Intune
- Oracle MySQL
- PostgreSQL
- Pure Storage
- ServiceNow
- Tanium
- XML Data (XML) File
- Show all articles ( 4 ) Collapse Articles
-
Admin
-
-
-
- Modules
- Analytics
- Asset Images
- Asset Rationalization
- Asset Rules
- Attachments
- Bulk Edit
- Data Generator
- Data Mapping
- ETL
- Form Builder
- Multi-Factor Authentication
- Relationship Chart
- Reports
- Self Service
- Single Sign-On
- T-Comm
- Show all articles ( 3 ) Collapse Articles
-
-
API & Stored Procedures
-
Administration
-
FAQs
Mapping Variables
< Back
The Mapping Variables tab provides the ability to manage data mapping variables. Mapping variables are utilized to abstract database and table names from a mapping query so they can be managed in a central place.
Available operations:
- Create new mapping variables by clicking on the New Variable button
- View a list of variables
- Columns available
- Id (hidden by default) – System Id of the mapping variable
- Name – Name of the mapping variable
- Value – Value of the mapping variable
- Description – Description of the mapping variable
- Date Created – Date the mapping variable was created
- Columns available
- Copy mapping variables by selecting a variable (row) and clicking the Copy Variable button on the toolbar
- Edit mapping variables by selecting a variable (row) and clicking the Edit Variable button on the toolbar
- Edit mapping variables in bulk by clicking the Bulk Edit button on the toolbar
- Delete mapping variables by selecting a variable (row) and clicking the Delete Variable button on the toolbar
- You can also change the number of visible rows in the table, export to CSV or Excel, refresh the table, and search for text