About winvarma

winvarma · ‎Feb 26, 2021

hi Mark, You may possibly ignore the devices which are going to be decommissioned so that they are not considered for compliance until the servers are retired. Please go through the relevant thread https://community.flexera.com/t5/The-Hub/How-do-I-exclude-retired-devices-from-being-included-in-software/td-p/133483 for reference. Regards,

winvarma · ‎Feb 24, 2021

Hi Beckner, Your understanding is correct and the discovery will be done based on the specified ports via network scan and no additional account permissions are needed. Regards

winvarma · ‎Feb 22, 2021

Hi Would like to understand the kind of issues we may come across because of this

winvarma · ‎Feb 22, 2021

Thaks for the update

winvarma · ‎Feb 22, 2021

Hi Forum, there are few devices which are active in SCCM but they are not reflecting in FNMS cloud setup. What possible reasons we may take into consideration for this issue. Regards

winvarma · ‎Feb 16, 2021

hi @kclausen , thanks for the suggestion and i'm connecting to temadb in the connection only. this integration is running without any issues for 3 quarters and facing this issue from yesterday night. No changes were made at FNMS end and checking with the ILMT team what is the exact version if there is any upgrade/changes done at their end to find the cause. Regards,

winvarma · ‎Feb 16, 2021

Hi Chris, thanks for the insights will check as suggested, we are having ILMT 9.2.21 and FNMS 2020R1 on prem. Regards,

winvarma · ‎Feb 15, 2021

Hi Forum, Import from ILMT sql connection is getting failed with summary Inventory gathering failed. Error: Invalid object name 'sam.software_facts' in inventory data import task and importer log is throwing the below error. Failed to execute Reader 'SendInstallerEvidence' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ilmt sql\InstallerEvidence.xml, at step line 3 Error: Invalid object name 'sam.software_facts'. 2021-02-15 22:05:34,502 [INFO ] All retries have been attempted for Reader 'SendInstallerEvidence' 2021-02-15 22:05:34,502 [INFO ] Completed with error in 0 seconds. 2021-02-15 22:05:34,505 [ERROR] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sam.software_facts'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at ManageSoft.Compliance.Importer.Logic.DatabaseSourceConnection.CreateDataReader(Reader readerStep, IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.XML.SourceToTarget.GetReader(IExecutionContext context, ISourceConnection sourceConn) at ManageSoft.Compliance.Importer.Logic.XML.SourceToTarget.ProcessStep(IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.XML.Reader.Execute(IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.ActionExecuter.ReaderExecuter.ExecuteSingleReader(Reader reader, Int32 procedureOrder, Version sourceDatabaseVersion) at ManageSoft.Compliance.Importer.Logic.ActionExecuter.ReaderExecuter.Execute() at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ProcessExecution(ComplianceReader p_ComplianceReader, Tenant p_Tenant, IExecutionContext p_Context) ClientConnectionId:49ca3e86-458e-446c-91e2-3f496b9ca5b2 Error Number:208,State:1,Class:16 Is this issue with the installerevidence.xml file? Appreciate your thoughts on this.

winvarma · ‎Feb 11, 2021

Hi Team, is there any solution identified for this issue?

winvarma · ‎Jan 20, 2021

Hi Kclausen, Appreciate your detailed inputs on the query and will try the suggestions for the licenses 1 & 2. We indeed have office 365 integration enabled with FNMS and still the last 3 licenses related to O365 shows zero consumption and does that mean that none of the users were using those services and unless until a user in the office 365 tenant is assigned to use the particular service by the admin we will be having zero consumption as per my understanding. How to determine where the data is inconsistent. Regards,

winvarma · ‎Jan 20, 2021

Hi Forum, Need inputs on how the below license consumption can be calculated if fnms supports and other ways to calculate if its not supported by fnms. WinRmtDsktpSrvcsCAL ALNG SubsVL MVL PerUsr Windows Server External Connector - As per the reference guideNot supported by FNMS what other ways to check the consumption? Win10UsrOLSActv Alng MonthlySub Addon E3 APPS_O365_LICENSE_Dmstc_Calling_Plan APPS_O365_LICENSE_SKYPEFORBUS_PSTNCONFERENCING Regards,

winvarma · ‎Jan 13, 2021

Hi , It will be a benefit if there a possibility to have that feature in FNMS. May be you have to suggest this as an idea in Idea portal. Regards,

winvarma · ‎Jan 11, 2021

Hi Chris, thanks and will raise a new thread as above issue is not relevant to the initial issue as suggested. Regards,

winvarma · ‎Jan 08, 2021

Hi, Sorry to say issue still persists after the daily reconcile but for a different Purl file now. There is no option to verify the digital signature of this file from the properties 2021-01-08 00:30:44,983 [.RecognitionImportTool] [WARN ] To import EOSL Data, FlexNet Manager for EOSL Data license is required. 2021-01-08 00:30:44,984 [.RecognitionImportTool] [INFO ] SKU tasks (Download, Extract) have begun... 2021-01-08 00:30:44,985 [onImport.ContentImport] [INFO ] Downloading (using PurlSkuDownloader) https://www.managesoft.com/support/Compliance/PURL.cab 2021-01-08 00:30:44,988 [port.PurlSkuDownloader] [INFO ] Executing command: E:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin\ShadowHost.exe "E:\Program Files (x86)\Flexera Software\FlexNet Manager Platform\DotNet\bin\ImportPURL.exe" -dl "\\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU" 2021-01-08 01:47:26,812 [onImport.ContentImport] [INFO ] Download completed in 1h 16m 41s 2021-01-08 01:47:26,815 [onImport.ContentImport] [INFO ] Extracting (using MultiCabExtractor) "\\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU" to "\\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU\.temp-extract" 2021-01-08 01:47:26,830 [.RecognitionImportTool] [ERROR] Unexpected error occured 2021-01-08 01:47:26,832 [.RecognitionImportTool] [ERROR] ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentExtractException: Could not extract \\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU ---> ManageSoft.Compliance.Logic.Core.API.ImportRecognitionCabVerifyException: Failed to verify the digital signature of the file '\\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU\007ec36198644a86b00000ac0bf5d1d0-PURL-IBM.cab'. at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.MultiCabExtractor.Extract(String archive, DirectoryInfo destination) at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentImport.Run(EARLImportMode mode, String groupName) --- End of inner exception stack trace --- at ManageSoft.Compliance.Logic.Core.Impl.Licensing.RecognitionImport.ContentImport.Run(EARLImportMode mode, String groupName) at ManageSoft.Compliance.Console.RecognitionImportTool.ImportSku() 2021-01-08 01:47:26,833 [.RecognitionImportTool] [ERROR] Could not extract \\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU 2021-01-08 01:47:26,833 [.RecognitionImportTool] [ERROR] Failed to verify the digital signature of the file '\\xyz\Flexera Software\FlexNet Manager Platform\DataImport\Content\SKU\007ec36198644a86b00000ac0bf5d1d0-PURL-IBM.cab'. 2021-01-08 01:47:26,833 [.RecognitionImportTool] [ERROR] ARL/SKU/EOSL tasks (Download, Extract) have failed. Please check the ARL/SKU log files for the detailed error message. Still wondering what is causing this issue when there is not change at the application/server end. Regards

winvarma · ‎Jan 08, 2021

Hi, Finally the issue got resolved after importing/installing the "DigiCert Assured ID Root CA" in 'Trusted Root certification Authorities' store related to RecognitionAfter82.cab file. Wondering if there is a change in the Digital certificate CA or something else which is causing this issue from 23rd Dec. Thanks for all the inputs and guidance on the thread. Regards,

Online Status	Offline
Date Last Visited	‎Feb 26, 2021 03:36 AM

Re: License Summary - Compliance Status at Risk

Re: Oracle Discovery

Re: How does FNMS maintain AD retrieved data in FNMS

Re: Bentley Publisher part numbers are not being recognised

Device in SCCM not showing in FNMS

Re: Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Re: Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Re: Unable to link some Virtual machines to an Asset from Inventory Without Assets view

Re: how to evaluate the Microsoft license consumption

how to evaluate the Microsoft license consumption

Re: An alternate way/method to double check targeted inventory agent upgrade.

Re: content libraries not getting updated due to Digital signature verification failure

Re: content libraries not getting updated due to Digital signature verification failure

Re: content libraries not getting updated due to Digital signature verification failure

Re: License Summary - Compliance Status at Risk

Re: Oracle Discovery

Re: How does FNMS maintain AD retrieved data in FNMS

Re: Bentley Publisher part numbers are not being recognised

Device in SCCM not showing in FNMS

Re: Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Re: Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Failed to execute Reader 'SendInstallerEvidence' Error: Invalid object name 'sam.software_facts'

Re: Unable to link some Virtual machines to an Asset from Inventory Without Assets view

Re: how to evaluate the Microsoft license consumption