Dec 05, 2018 12:49 AM
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
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 |