Example Scenario: SCCM Data Pull

Scenario: You need to import computer inventory data from SCCM into ReadyWorks daily.

Configuration Steps:

1. Create the ETL Job:
   • Job Name: “Daily SCCM Computer Import”
   • Active: Yes
   • Allow Empty Tables: Yes
   • Destination Table: cm_computer_inventory
   • Data Identity: cm_computer_inventory
   • Job Schedule: Daily
   • Order: 1
   • Fields to Index: ComputerName
   • Data Selection Query:
     • SELECT ComputerID, ComputerName, OperatingSystem, LastUser
       FROM SCCM_Computers
       WHERE IsActive = 1
2. Set Up Data Mapping:
   • Create a data mapping to transfer data from the staging table to the Computers asset type.
   • Schedule the mapping to run after the ETL job completes.
3. Monitor and Test:
   • Run the ETL job manually to test.
   • Verify that data appears correctly in ReadyWorks.
   • Check logs for any errors.