avi0408 asked a question.
Inventories not visible in compliance computer
Hi Team,
Inventories with NULL 'ComplianceComputerID' in "Imported Computer" table in compliace db are not present in "compliance computer" table and hence not visible in FNMS UI (All Inventory). How can we fix this issue. Let us know if there is any issue with writer/suggest any fix in DB.
PFA - log file (zip) for sample inventory with above case, .ndi file for one of the inventory with above case.
Looking forward for a solution on this import issue.
Thanks,
Awadh
The inventory seems to be fine. Have you checked your FNMS license?
Delete entry from imported computer & reupload NDI. Then again check in IM DB & Imported computer.
Also let me know if this is happening with Azure devices.
Hi @durgeshsingh Yes there are azure devices as well in ImportedComputer table with this issue.
@mfranz we checked the license and it looks fine.
Same happened to my environment as well for azure. We have deleted record from DB & reuploaded NDi file in beacon.
Hi @durgeshsingh Do we need to perform cleanup only in computer table (Inventory database) or from imported computer table (compliance db) as well ?
Thanks,
Awadh
You won't find entry in compliance. So you can do cleanup from imported & IM.
As a test, I have cleanup few inventories (with NULL ComplianceComputerID) from Imported and IM. I will comeup with the results after reuploading .ndi.
Hello @avi0408 ,
Can you please check within the compliance database the following: dbo.ImportedMissingComputer and join it with the ImportedComputer table via external ID and see if the IsTerminated column is equal to 1 for the following devices.
Thank you.Hello @kbryla
I got a result for below query -
SELECT ic.*
FROM dbo.ImportedMissingComputer_MT imc
JOIN ImportedComputer_MT ic ON ic.ExternalID = imc.ExternalID
WHERE imc.IsTerminated = 1
but from this result 128 inventories are present in FNMS.Hi @durgeshsingh , as discussed we got some azure inventories reporting in FNMS last week after cleanup, but now again they are not visible in FNMS.
Please help me if there is any other solution to fix this.
Thanks,
Awadh
We are also planning to raise support case with flexera. It seems to bug in product.