Deleting Inventory Devices from All Inventory

sasikumar_r asked a question.

April 6, 2020 at 6:09 AM

Hi,

As per FNMS 2017R2 Release Notes, Page No:7 It has been mentioned that deleting the device from All Inventory will delete it from All discovered and Inventory DB as well. Below is the URL & Attached is the screenshot for reference. By any chance,did this changed on the later versions?

We are on 2019R2 muti tenant environment, but it is not working like it is mentioned. it is just deleting inventory from compliance DB. No other Inventory source, Inventory is from Agent & Default AD connection.

https://docs.flexera.com/fnms2017r2/onpremises/FlexNet%20Manager%20Suite%20Release%20Notes%202017%20R2%20(English).pdf

Note: I posted this question on and seems it is solved already hence creating a new thread.

Thank you

Sasi

FlexNet Manager Suite On-Premises

Top Rated Answers

AamerSharif (Flexera)
7 years ago
There is another important piece i should have mentioned earlier, Database server name/ipaddress (which ever is in use) database connection string in registry key and server name in the compliance connection both should match otherwise delete inventory device would not be able to make a decision if device is from local direct FNMS inventory database connection.

Imported source server name:

SELECT [Server],* from ComplianceConnection where ConnectionName='FlexNet Manager Suite'

Database connection registry path:

[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ManageSoft Corp\ManageSoft\Reporter\CurrentVersion

Can you please check this, if it is different make it same. you may need to restart IIS and batch scheduler and processor service if value need to be changed in the registry.

HTH

Aamer
Expand Post
Selected as Best

All Answers

0_Captain Kirk (Flexera Software)
7 years ago
You need to delete the device from the Active Inventory or All Inventory view - this will delete the device from the FNMS Compliance Database.
You must also delete the same device from the Discovered Devices view - this will delete the device from the FNMS Inventory Database.
Expand Post
- AamerSharif (Flexera)
  7 years ago
  Deleting inventory or discovery device on delete linked inventory device from FNMS inventory database (not from third party inventory sources). FNMS 2019 R1 and later when user delete a inventory device from All Inventory page that is imported from FNMS inventory it will be removed from FNMS inventory source database as well but wouldn’t delete discovery record for the same device, same applies if discovered device is linked to RAW inventory record in inventory database, deleting discovery device will delete the linked inventory record and subsequent overnight FNMS inventory import will clean up from FNMS.
  Expand Post
  - sasikumar_r
    7 years ago
    Hi @kclausen @AamerSharif
    Thank you for your reply! i have tested by deleting the device with both the below mentioned scenarios.
    1. Deleted from All Inventory page
    2. Deleted from All Inventory page & All Discovered page
    But the devices is not getting removed from Inventory DB. After the reconcile the device get recreated on the compliancecomputer & discovereddevice table and it again started appearing on All inventory & All discovered devices page.
    we would like to perform the device deletion from UI rather than using storedprocedure. As per the links i have shared it looks like the device will be removed from both the DB's and it will not appear again on the UI unless its agent is actively sending the inventory. But unfortunately this is not happening on my environment. Device not getting deleted from Inventory DB and getting created again(no other inventory source, Only default AD connection in place). Even the result is same for non AD devices.
    Thank you
    Sasi
    
    Expand Post
    AamerSharif (Flexera)
    7 years ago
    Can you check the inventory source on the imported inventoried device, It may be coming from inventory source other than FNMS Inventory database.
    You can check this by opening the inventory device properties OR on the linked discovered device > Evidence tan should show RAW inventory data if it is linked to inventoried computer in inventory database.
    Expand Post
    sasikumar_r
    7 years ago
    Hi @AamerSharif ,
    Inventory source is from FNMS only, as i said i tried deleting(both on All Inventory & Discovered devices) a device which is not in AD also. But still the device got recreated. I have attached the a screenshot on which you could see created date is 6th April and the last inventory source as FNMS.
    Device got recreated again on the compliance and discovereddevices tables.
    kindly help us how to get this fixed.
    Thank you
    Sasi
    Expand Post
    JohnSorensenDK (Flexera Software)
    7 years ago
    @sasikumar_r
    I would recommend you open a support case to track it, if you believe that you've found a 'bug'.
    Thanks,
    Expand Post
    sasikumar_r
    7 years ago
    Hi @JohnSorensenDK ,
    Thank you for your response! Yeah i just raised a case & working with technician for resolving the same.
    Sasi
    Expand Post
    AamerSharif (Flexera)
    7 years ago
    There is another important piece i should have mentioned earlier, Database server name/ipaddress (which ever is in use) database connection string in registry key and server name in the compliance connection both should match otherwise delete inventory device would not be able to make a decision if device is from local direct FNMS inventory database connection.
    
    Imported source server name:
    
    SELECT [Server],* from ComplianceConnection where ConnectionName='FlexNet Manager Suite'
    
    Database connection registry path:
    
    [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ManageSoft Corp\ManageSoft\Reporter\CurrentVersion
    
    Can you please check this, if it is different make it same. you may need to restart IIS and batch scheduler and processor service if value need to be changed in the registry.
    
    HTH
    
    Aamer
    Expand Post
    Selected as Best
    sasikumar_r
    7 years ago
    Hi @AamerSharif ,
    Thank you for the information!
    Server name on the complianceconnection table and the Registry value both are different. we have recently migrated our application and Database to new servers, i hope that could be the reason for the difference.
    Server name on the registry is pointing to the new Database server name, whereas on the complianceconnection table it is having our old database server name(which no more exist).
    Shall we goahead and replace the old DBserver name with new dbservername on the complianceconnection table?
    is there any other table that i need to update with newdbservername? so that the new tenants will get updated with the correct dbserver name automatically on the compliance connection table?
    Thanks Again for taking time to assist me on fixing this issue
    Sasi
    
    Expand Post
    sasikumar_r
    6 years ago
    Hi @AamerSharif ,
    Based on your input we have updated the complianceconnection table to match the server name with Registry server name. Now we are able to delete the device successfully Deleting a device from UI deletes the record from both compliance & Inventory DB Table. However we fall into an another issue because of this migration+Upgrade (2019R1.3 to 2019 R2). There are duplicate entries for each devices on the Inventory DB Computer_mt table. One record with the old inventory date(date we upgraded the application) & Agentid. second record with new inventory date without agentid. no changes happened on the Agent side, version remains same 13.5.
    By anychance do you know why a second entry got created post upgrading our application and how can we make these 2 entry into 1.
    Note: inventory from these 2 entries are getting merged and showing an application has installed,even if the application is uninstalled.
    Expand Post

10 of 11

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →