Symptoms:
After performing a full applications export from FNMS to ServiceNow, there are missing installations in ServiceNow which exists in FNMS. The applications do not exist in the staging table for ServiceNow, indicating that it was not brought in by the export from FNMS.
Diagnosis:
By default, the configuration for data transfers from FNMS to ServiceNow limits the number of records of each data type to be included in the transfer. For applications export, this number is 10,000,000.
The following Online Help article lists the default configured limit for data transfers between FNMS and ServiceNow
To check whether you are running into this limit, the following query can be run against the FNMSCompliance database to get an estimate number of records to be exported:
SELECT count(*) FROM( SELECT SoftwareTitleID, ComplianceComputerID, ComplianceHistoryTypeID, HistoryDate, ROW_NUMBER() OVER (PARTITION BY ComplianceComputerID, SoftwareTitleID ORDER BY HistoryDate DESC) AS RowRank FROM ComplianceHistory WHERE ComplianceComputerID IS NOT NULL AND SoftwareTitleID IS NOT NULL AND ComplianceHistoryTypeID IN (4, 5) ) AS hist WHERE hist.RowRank = 1
Solution:
If it has been determined that you are running into the record limit, the value can be adjusted to allow additional rows to be exported. The following steps will set the row limit for applications export to unlimited:
1.Navigate to the ServiceNow Export folder on the FNMS Application Server, which is by default at:
C:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin\ServiceNowExport
2.Open the Export configuration file with notepad: fnmp_servicenow_export.exe.config
3.Change the maxRows limit to -1 for unlimited applications within the <application /> node.
The following Online Help article discusses all the configuration options and defaults for fnmp_servicenow_export.exe.config file
Related Articles
Filtering Active and Normalized Software Installations in ServiceNow with Flexera One Integration 12Number of Views Details on Coalesce Changes in Flexera Integration App for ServiceNow 5.1.3 21Number of Views ServiceNow Integration Fails - Insufficient Rights for Creating New Records 8Number of Views ServiceNow integration: Service Flexera Integration application administrator 25Number of Views Connector Troubleshooting for the Snow ServiceNow Connector 332Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago