Duplicate but only in one sccm table

[ppyrzynski]

Hi Everyone, 

I have a problem/question I hope to get some answers here. 

Found a duplicate in the All Inventory UI:

Deleting the later 2 devices does not help- they come back after reconciliation. 

So I went to Compliance db and looked for the device name there:

Then checked the external ID's in sccm:

Now, my questions are:

1) Do they come back because they still exist in that PC_Memory_DATA table?
2) Found about 200k MachineIDs exsiting in PC_Memory_DATA table and NOT present in other tables. Is it normal?
3) Shouldn't they be deleted from the table with the regular sccm cleanup task?

Any help will be greatly appreciated. 

Best, 
Paweł

[JohnSorensenDK]

@ppyrzynski 

Did you try to delete the orphaned content from PC_Memory_DATA for one of the devices and then check if it still shows up afterwards? (Maybe this test could be a simple test to check if these orphaned records are the root cause of your issues?)

Thanks,

[ppyrzynski]

Hi, Thanks for your reply. 

Asked the DB management team to test delete them for one of the devices but got answer "it's not advisable" :). Not sure if I should insist because I'm not sure if it's safe to just do "delete from where id like". Is it?

Best, 
Paweł 

[ChrisG · Accepted solution]

What you're seeing here looks like it may be related to the following: Known Issue: Devices deleted from SCCM may not be deleted in FlexNet Manager Suite when the connection to SCCM is configured on the application/batch server (IOJ-2193871)

I would suggest deleting the ImportedComputer records that have an ExternalID value that does not exist in the SCCM Computer_System_DATA table - that should stop these inventory devices from re-appearing.

[ppyrzynski]

Hi Chris,

This worked. Thanks a lot.

Best, 
Paweł 

[martin_schulz]

Hi Pawel,

please see the post from my colleague @mfranz :

https://community.flexera.com/t5/FlexNet-Manager-Forum/SCCM-Reader-GetDeletedComputerList/td-p/236198

Best,

Martin

[ppyrzynski]

Hi Martin, 

Thanks for suggestion. Found and applied that change already :). Still no luck. 

Best, 

Paweł