Good afternoon
I have a customer that is kind of complaining that the reconcile in FNMS takes around 7 hours to complete.
Is there any thing that we can check to improve reconcile time.
Memory of Servers and Beacons are suffcient.
regards
Manish
‎May 23, 2019 05:51 AM
Hi Manish,
You could start with the log file from the inventory import/license reconcile and check if there are specific import steps that take longer than the rest.
Also what release of FNMS are you running and do you import from SCCM? SCCM Access Evidences are known to build up over time. Joins on these tables are then continously taking longer and longer.
Best regards,
Markward
‎May 23, 2019 06:15 AM
Hi Mark
Thanks for this, we are running FNMS 2018 R2. I will check the log files and yes SCCM is integrated.
regards
Manish
‎May 23, 2019 06:20 AM
So in this case, please check the following tables and see how many rows you get:
Especially the last table tends to grow without limits (because the InventoryDate is generated each time the import runs).
‎May 23, 2019 06:30 AM
‎May 24, 2019 04:39 AM
The number of rows seem reasonable. You should check the log files to see which steps exactly take the most time.
Also, do you have a feeling for how your SQL Server performs?
Having the SQL Server actively monitored during a Reconcile, to find possible bottlenecks, might be a good idea.
‎May 24, 2019 05:04 AM
I use the following script in SQL Server Management Studio.
I only run selected portions. I use the Initial select to look at the data and get a feel for how many entries there are for a given file. You can do multiple or manually change the longname to meet your company's need.
SELECT [SoftwareFileUsageID]
,[ComputerID]
,[UserID]
,[Version]
,[SoftwareFileNameID]
,[LongName]
,[CompanyName]
,[Description]
,[ProductName]
,[ProductVersion]
,[TenantID]
FROM [IM].[dbo].[SoftwareFileUsage_MT]
/* where LongName = 'C:\Program Files\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe' */
Order by LongName, ProductVersion
Delete
FROM [IM].[dbo].[SoftwareFileUsage_MT]
where LongName = 'C:\Program Files (x86)\Adobe\Acrobat 2015\Acrobat\acrotray.exe'
‎May 24, 2019 07:51 AM
‎May 28, 2019 04:55 AM
If you are monitoring application usage to allow for reclaiming of unused installations, take a hard look at SoftwareFileUsage_MT
You will have a number of helper files listed that after removal will improve reconciliation time significantly.
‎May 23, 2019 09:22 AM
‎May 24, 2019 04:38 AM
@JeffVoss - Can you provide an example of the helper files
‎Nov 25, 2020 10:30 PM
Some questions I would ask here to possibly help qualify what is going on are:
‎May 26, 2019 09:08 PM
‎May 28, 2019 05:03 AM
Hello Manish
Generally a 'light weight' reconcile (without ticking -- Update inventory for reconciliation) should be completed fairly fast (within hour). If the overnight full import(reconcile with inventory update), it could reach a few hours. Particularly time spent could be either FileEivdence (read or write) as well as Access evidence Mark referred. I believe finding out the import.log where it should tell you which specific step by checking timestamp takes longer time before you raise a formal support request.
Cheers
Kevin
‎May 28, 2019 07:10 PM