cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.
Was this article helpful? Yes No
50% helpful (1/2)
Comments
clugo1
By
Level 4

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
By
Level 3

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
Version history
Last update:
‎Dec 05, 2018 12:49 AM
Updated by: