What fields does FNMP\FNMS use from SCCM for data mapping?

[#1]

Summary

In some situations you may need to know the field mappings from SCCM to FNMP.

Question

What fields does FNMP\FNMS use from SCCM for data mapping?

Answer

Please find the SCCM to FNMP\FNMS field mappings in the attached spreadsheet.

[clugo1]

Hi cingham,

The spreadsheet is marked as updated on Dec 04, 2018. Is that the last time it was updated or just the time it was uploaded?

Thanks,

clugo

[Sergey_V]

I can add some regarding access to tables\views for import from SCCM.
Service account need to have access to read:

dbo.CI_ConfigurationItemContents

dbo.CI_Models

dbo.MonthlyUsageSummary

dbo.v_Advertisement

dbo.v_CIRelation

dbo.vCI_ContentPackages

dbo.vSMS_ConfigurationItems

dbo.vSMS_Program

EAS_Property

AppVUsage

Computer_System_data

dbo.CI_ContentFiles

dbo.CI_ContentPackages

dbo.Disk_DATA

dbo.fn_ListApplicationCIs

dbo.MeteredUsers

dbo.Network_DATA

dbo.PC_BIOS_DATA

dbo.PC_Memory_DATA

dbo.Processor_DATA

dbo.SoftwareFile

dbo.SoftwareFilePath

dbo.SoftwareInventory

dbo.SoftwareProduct

dbo.System_Enclosure_DATA

dbo.v_ApplicationAssignment

dbo.v_CIContentPackage

dbo.v_CollectionExpandedUserMembers

dbo.v_FullCollectionMembership_Valid

dbo.v_GS_CCM_RECENTLY_USED_APPS

dbo.v_Package

dbo.Video_Controller

dbo.WorkstationStatus_DATA

Operating_System_data

Sites_DATA

SYSTEM_CONSOLE_USER_DATA

SYSTEM_CONSOLE_USER_HIST

System_DATA

System_DISC

user_disc

UserMachineRelation

v_AgentDiscoveries

v_GS_ADD_REMOVE_PROGRAMS

v_GS_ADD_REMOVE_PROGRAMS_64

v_GS_COMPUTER_SYSTEM

v_GS_INSTALLED_SOFTWARE

v_GS_System

v_GS_SYSTEM_CONSOLE_USER

v_GS_WINDOWS8_APPLICATION

v_R_System

v_R_User

v_Site

vSMS_R_System

v_CIContentPackage