About jrsikors

jrsikors · ‎Sep 25, 2019

Support got back to me, and referred me to: https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Remove-unwanted-computers-and-network-devices-from-ManageSoft/ta-p/2205 Particularly the section: Computer deletion using direct SQL statements Thanks all for the help !

jrsikors · ‎Sep 17, 2019

I opened a case on this as well but wondering if anyone else ran into this. Long story short, when we initially set up FlexNet Manager , we imported devices from SCCM/JAMF instead of going with the Flexera agent for discovery. I'm now noticing that there's about 800 "duplicate" devices in the FNMSInventory computer table. It's the same device, but you can tell by the SWDate/HWDate fields that one device is referencing the import from SCCM/JAMF, and the other is referencing the new Flexera agent generated device. They both have different ComputerIDs. The issue is - in the Web UI - these devices don't seem to be showing up as different devices. Scenario: Someone was looking for Software A. They found it in the Web UI on Device B and contacted owner of Device B. Owner says they don't have it installed on Device B. Looking at the database... Software A is definitely on Device B, but it's on the old imported SCCM/JAMF ComputerID that hasn't been seen since March. Software A doesn't exist on the new Flexera agent scan. So I'm trying to find a clean way to go through and delete all these old computers. They aren't showing up on the "Out-of-date inventory" , because as I mentioned, FlexNet Web UI doesn't seem to be listing them as separate devices, even though they have unique ComputerIDs in the computer table. Thanks! Jeff

jrsikors · ‎Aug 28, 2019

Thanks Chris - I do have some follow-up questions now. In the article it says if you are Cloud you see the "Evidence" tab. Is this also released to on-premise? We are currently on Product version: FlexNet Manager Suite 2018 R2 Release number: 13.1.1.712 Next question, kind of back to my original question... I deleted the file that Flexera was "using as evidence against me" the other day. It's still showing up that I have it installed, and using the query i'm still seeing: Computer Name Software Name Evidence Trigger Name Evidence Trigger Version Evidence Trigger Publisher Evidence Directory on Local Computer Evidence File on Local Computer HWDate swdate jeffscomputer Acrobat XI Adobe Acrobat 11 regid.1986-12.com.adobe C:\ProgramData\regid.1986-12.com.adobe\ regid.1986-12.com.adobe_V6{}AcrobatPro-AS2-Win-GM-MUL.swidtag 8/27/19 1:56 PM 8/27/19 1:56 PM When should I expect that the evidence will be unlinked from my device? I did/am having an issue where reconciliation failed last night, and there is another system task that can't run, posted about it here: https://community.flexera.com/t5/FlexNet-Manager-Forum/run-system-task-manually/m-p/113367#M2303 So maybe that's related. Another question -- but I'll probably try to figure it out on my own unless anyone has the answers handy... the query I was given seems to only be for 1 of the many evidence scenarios? In other words, that query only seems to be giving back results for software/evidence that has to do with the "regid-xxxxxxxxxxx" scenarios? Thanks! ~Jeff

jrsikors · ‎Aug 28, 2019

Hello - Our nightly reconciliation task failed last night, so I manually ran it again and it's fine. However, another system task also failed, and I'd like to fire it off manually, but can't figure out how/where. Any suggestions? 2019-08-28 02:25:09,027 [ERROR] System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: The app domain with specified version id (850) was unloaded due to memory pressure and could not be found. The statement has been terminated. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ManageSoft.Database.DatabaseCommand.ExecuteNonQuery() at ManageSoft.Database.Impl.DatabaseLayerBaseSql.Execute(CommandType p_CommandType, String p_CommandText, DatabaseParameter[] p_Parameters) at ManageSoft.Database.SQLRetryLogic.Execute(Action p_Action, IDatabaseLayer p_DatabaseLayer) at ManageSoft.Compliance.Importer.Procedures.ManageSoft.InstallHelperBase.SaveUpdatedCountsToDatabase(ICollection`1 licenseIDsToIgnore) at ManageSoft.Compliance.Importer.Procedures.ManageSoft.InstallHelperBase.ProcessInstalls(IEnumerable`1 simulationTypeIDs) at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.RunInstallBasedReconcile() at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.PerformLicenseReconcile(Int32 p_LicenseMeasurementID, Boolean p_isPartial) at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.ReconcileLicenses(Nullable`1 p_OverrideLicenseMeasurementID, String PublisherFilter) at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.ReconcileLicenses(String PublisherFilter) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at ManageSoft.Compliance.Importer.Logic.XML.ProcedureItem.ExecuteAssembly() at ManageSoft.Compliance.Importer.Logic.XML.Writer.Execute(IExecutionContext context) at ManageSoft.Compliance.Importer.Logic.ComplianceImporter.ExecuteWriters(ComplianceReader p_ComplianceReader, IExecutionContext context, String singleConnectionIdentifier) Thanks again! ~Jeff

jrsikors · ‎Aug 27, 2019

Nice!!! You are awesome, thanks so much. That is beautiful ! ~Jeff

jrsikors · ‎Aug 27, 2019

To ask it a different way: this would be my dream results from a database query. Computer Name Software We Say You Have Evidence Trigger Name Evidence Trigger Publisher Evidence Directory on Local computer Evidence File on Local computer JeffsComputer Adobe Acrobat 11 Std Acrobat XI Standard regid.1986-12.com.adobe% C:\ProgramData\regid.1986-12.com.adobe regid.1986-12.com.adobe_V7{}AcrobatCont-12-Win-GM.swidtag Flexera was saying my machine had Adobe Systems Acrobat XI Standard. I didn't have it installed, so I wanted to know why Flexera *thinks* I have it. Clicking through the screens -- you get to this screen, however there are a couple issues, mainly that there are 34 different types of evidence, and no easy way to know which of these 34 my computer fell into. Then when you get lucky and figure out that it's because of regid.1986-12.com.adobe% , it still doesn't tell me where on my computer this exists.

jrsikors · ‎Aug 27, 2019

Thanks for the reply! So i only have 24 records in my SoftwareOccurrenceSoftwareIsoTagFile table, all are different computers but 1 software title 979 in my SoftwareIsoTagFile table 3.8 million in SoftwareOccurrence . So something must not be configured right? Thanks! ~Jeff

jrsikors · ‎Aug 26, 2019

update... I found: C:\programdata\regid.1986-12.com.adobe on my machine. Is there a place in Flexera, or the database, that stores the location C:\programdata\regid.1986-12.com.adobe as "the reason why" the evidence is linked to my machine? Thanks, Jeff

jrsikors · ‎Aug 26, 2019

Hello - We are pretty new to Flexera. Very simple scenario: Flexera says I am consuming an Acrobat 11 Std license because it's installed on my laptop (I don’t have it installed) How can I figure out WHY Flexera thinks I have Acrobat Systems Acrobat XI? Is there a screen I can click to that says basically: Flexera says you have Acrobat 11 Std installed because you have Acrobat.exe in your C:\Jeff folder and the file version says 11 I’ve clicked through a bunch of Evidence screens, but I haven’t found a place where I can find a SIMPLE answer to that scenario. I can’t even find a difficult answer ! I think i have tracked it down to Installer Evidence properties... and the Name: Adobe Acrobat Version: 11.0 Publisher: regid.1986-12.com.adobe% Type: Any Source: Flexera So my question is -- how can i figure out which particular file or registry key on my laptop is "triggering" the above evidence? IE: Is there a file on my computer and if i right click -> properties, i will see the publisher as regid.1986-12.com.adobe Thanks! Jeff

Online Status	Offline
Date Last Visited	‎Mar 02, 2020 04:55 PM

Re: duplicate devices

duplicate devices

Re: details of evidence

run system task manually

Re: details of evidence

Re: details of evidence

Re: details of evidence

Re: details of evidence

details of evidence

Re: duplicate devices

duplicate devices

Re: details of evidence

run system task manually

Re: details of evidence

Re: details of evidence

Re: details of evidence

Re: details of evidence

details of evidence