flexeranoob
Frequent contributor

Deleting machines from FNMS Compliance and Inventory completely

Hello

I have read here that this is not the recommended thing, but still, how do we go about deleting machines completely from FNMS completely from Compliance and Inventory databases.  I have seen some scripts here, but unable to find those posts. 

Could someone help me.

 

0 Kudos
7 Replies
mfranz
Shining star

Re: Deleting machines from FNMS Compliance and Inventory completely

Hi,

Could you please specify, what you're planning to do? Do you want to delete all machines or only specific ones?

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos
flexeranoob
Frequent contributor

Re: Deleting machines from FNMS Compliance and Inventory completely

Hi @mfranz  We would like to delete specific machines, those which are not in circulation anymore. 

0 Kudos
jjensen
Flexera Alumni

Re: Deleting machines from FNMS Compliance and Inventory completely

Hi @flexeranoob,

If a computer is removed from the Inventory database (specifically, the Computer_MT table) AND it exists in no other 3rd-party source, then the next full reconciliation will remove the associated machine from the Compliance database.

The following KB is quite old, but the section "Computer deletion using direct SQL statements" still holds true: Remove unwanted computers and network devices from ManageSoft 

As always, a backup is advised beforehand in case you need to restore the data.

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!
ChrisG
Community Manager Community Manager
Community Manager

Re: Deleting machines from FNMS Compliance and Inventory completely

For reference, the following thead may also provide some helpful tips for doing bulk deletions of records: Deleting old inventory records

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
flexeranoob
Frequent contributor

Re: Deleting machines from FNMS Compliance and Inventory completely

Thank you @ChrisG @jjensen 

As I see, it uses the following to delete computer from the inventory database

DECLARE @ComputerID INT
SET @ComputerID = ID of the computer to be deleted
EXEC DeleteComputer @ComputerID

For deleting a computer from the Compliance database, I suppose it is ok to delete it from All Inventory, and that will be all?  Or would some other steps be needed?  We are all assuming that the computer is not from a third party source.

0 Kudos
jjensen
Flexera Alumni

Re: Deleting machines from FNMS Compliance and Inventory completely

Hello @flexeranoob,

The overnight reconciliation will remove the device from the ImportedComputer table in the Compliance database, and subsequently the ComplianceComputer table (which will then make it disappear from the UI).

However, if you want to speed up the process of getting the device out of your UI, then yes, removal from All Inventory should be sufficient.

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!
flexeranoob
Frequent contributor

Re: Deleting machines from FNMS Compliance and Inventory completely

Thanks!

0 Kudos