@marcog, (Always take a backup before running any deletions!) 1) Use the following SQL to find out the ComplianceComputerRoleID associated with the bad role: SELECT * FROM ComplianceComputerRole 2) Use the following SQL to ensure that there are no inventory devices that are currently using this bad role: SELECT * FROM ComplianceComputer WHERE ComplianceComputerRoleID = <ID from previous step> 3) Assuming 0 results from step 2, simply use: DELETE FROM ComplianceComputerRole WHERE ComplianceComputerRoleID = <ID from step 1> If you got > 0 results in step 2, then please assign a correct role to those machines before removing the bad role. ... View more

Hello @marcog, The 'All Inventory' page is populated by a view named Grid_ComputersListModel, which resides in the Compliance database. The schema reference guide describes all tables (not views) in the Compliance and Inventory databases: https://docs.flexera.com/fnms/EN/Schema/index.html In this particular scenario, you are most likely interested in the ComplianceComputer table, as that is where most of the 'final' data is stored for an inventory device record. HTH, Joseph   ... View more

Hello Erick, The difference between Last Used Date and Last Inventory Date may be easily explained. The two fields (inventory and usage) are populated by completely different files generated by the FNMS agent - assuming that you are using the agent for usage tracking: Usage: .MMI Inventory: .NDI So, it is possible that there is a problem with the inventory side of the device (e.g. ndtrack is hung or erroring out), yet the usage component may be continuing just fine. That's one example of a scenario where those dates might become out of sync. Regarding your question " If SCCM is providing the history, then why doesn't the latest inventory source show SCCM?" - h ere is a useful link detailing the definition of 'Last inventory date': https://docs.flexera.com/fnms/EN/WebHelp/index.html#topics/Dev-All_Inventory.html "The date when the last inventory information was collected by the  Last inventory source  for this inventory device. The inventory process generates the value of this field." Checking the definition for 'Last inventory source': "If you have multiple overlapping inventory sources that report on the same device, it is possible for some inventory details to come from one source and other details from another source. This column identifies the most recent source of inventory that reported the majority of the hardware properties for this device." So, if the agent is configured to be your 'primary' data source, then the last inventory source (and by extension, last inventory date) will remain as the agent, as this will likely be providing the majority of your hardware properties. HTH, Joseph ... View more

Hello @dbeckner, .NDI files will be sent to: C:\ProgramData\Flexera Software\Incoming\Inventories .VDI files will be sent to: C:\ProgramData\Flexera Software\Incoming\VdiAccess HTH, Joseph ... View more