Loading
search-img

JS155794 asked a question.

August 26, 2019 at 3:30 PM
details of evidence

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
  • 10 answers
  • 76 views

  • mfranz

    You mean like

    SELECTc.ComputerCN [Computer Name],st.FullName [Software We Say You Have],tv.ProductTitle [Evidence Trigger Name],tv.ProductVersionName [Evidence Trigger Version],te.RegID [Evidence Trigger Publisher],sfp.Path [Evidence Directory on Local Computer],sfn.Name [Evidence File on Local Computer]FROM FNMSInventory.dbo.SoftwareFile sfJOIN FNMSInventory.dbo.SoftwareFilePath sfpON sf.SoftwareFilePathID = sfp.SoftwareFilePathIDJOIN FNMSInventory.dbo.SoftwareFileName sfnON sf.SoftwareFileNameID = sfn.SoftwareFileNameIDJOIN FNMSInventory.dbo.SoftwareIsoTagFile tfON tf.SoftwareIsoTagFileID = sf.SoftwareIsoTagFileIDJOIN FNMSInventory.dbo.SoftwareIsoTagSoftwareVersion tvON tv.SoftwareIsoTagSoftwareVersionID = tf.SoftwareIsoTagSoftwareVersionIDJOIN FNMSInventory.dbo.SoftwareIsoTagEntity teON te.SoftwareIsoTagEntityID = tv.TagCreatorEntityIDJOIN FNMSInventory.dbo.Computer cON sf.ComputerID = c.ComputerIDLEFT JOIN ImportedInstallerEvidence iieON tv.ProductTitle = iie.DisplayNameAND tv.ProductVersionName = iie.VersionAND te.RegID = iie.PublisherAND iie.Evidence = 'SWIDTag'LEFT JOIN ImportedInstallerEvidenceMapping iiiemON iie.ExternalInstallerID = iiiem.ExternalInstallerIDAND iie.ComplianceConnectionID = iiiem.ComplianceConnectionIDLEFT JOIN SoftwareTitleInstallerEvidence stieON iiiem.InstallerEvidenceID = stie.InstallerEvidenceIDLEFT JOIN SoftwareTitle stON stie.SoftwareTitleID = st.SoftwareTitleID

    ?

    Expand Post
    Selected as Best

    • mfranz

      Hi Jeff,

      I would go with the raw data from the inventory database (FNMSInventory).

       

      SELECTc.ComputerCN,so.InstallationDate,sitf.OriginalArpPublisher,sitf.OriginalArpDisplayName,sitf.OriginalArpDisplayVersionFROM SoftwareOccurrenceSoftwareIsoTagFile sositfJOIN SoftwareOccurrence soON sositf.SoftwareOccurrenceID = so.SoftwareOccurrenceIDJOIN SoftwareIsoTagFile sitfON sositf.SoftwareIsoTagFileID = sitf.SoftwareIsoTagFileIDJOIN Computer cON so.ComputerID = c.ComputerID

       

      This won't give the the actual link to the application, but you should be able to gat a quick overview. From there the data is consumed in multiple import steps (ManageSoft Reader):

      • GetDistinctISOTagInstallerEvidence
      • GetISOTagInstallerEvidence
      • GetISOTagInstalledInstallerEvidence

      As can be seen in the Reader SQL code, from there the data is treated as InstallerEvidence with EvidenceType "SWIDTag".

      Best regards,

      Markward

      Expand Post

      • JS155794

        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
        Expand Post

        • JS155794

          To ask it a different way: this would be my dream results from a database query.

          Computer NameSoftware We Say You HaveEvidence Trigger NameEvidence Trigger PublisherEvidence Directory on Local computerEvidence File on Local computerJeffsComputerAdobe Acrobat 11 StdAcrobat XI Standardregid.1986-12.com.adobe%C:\ProgramData\regid.1986-12.com.adoberegid.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.

          ss1.png

          Expand Post

          • mfranz

            You mean like

            SELECTc.ComputerCN [Computer Name],st.FullName [Software We Say You Have],tv.ProductTitle [Evidence Trigger Name],tv.ProductVersionName [Evidence Trigger Version],te.RegID [Evidence Trigger Publisher],sfp.Path [Evidence Directory on Local Computer],sfn.Name [Evidence File on Local Computer]FROM FNMSInventory.dbo.SoftwareFile sfJOIN FNMSInventory.dbo.SoftwareFilePath sfpON sf.SoftwareFilePathID = sfp.SoftwareFilePathIDJOIN FNMSInventory.dbo.SoftwareFileName sfnON sf.SoftwareFileNameID = sfn.SoftwareFileNameIDJOIN FNMSInventory.dbo.SoftwareIsoTagFile tfON tf.SoftwareIsoTagFileID = sf.SoftwareIsoTagFileIDJOIN FNMSInventory.dbo.SoftwareIsoTagSoftwareVersion tvON tv.SoftwareIsoTagSoftwareVersionID = tf.SoftwareIsoTagSoftwareVersionIDJOIN FNMSInventory.dbo.SoftwareIsoTagEntity teON te.SoftwareIsoTagEntityID = tv.TagCreatorEntityIDJOIN FNMSInventory.dbo.Computer cON sf.ComputerID = c.ComputerIDLEFT JOIN ImportedInstallerEvidence iieON tv.ProductTitle = iie.DisplayNameAND tv.ProductVersionName = iie.VersionAND te.RegID = iie.PublisherAND iie.Evidence = 'SWIDTag'LEFT JOIN ImportedInstallerEvidenceMapping iiiemON iie.ExternalInstallerID = iiiem.ExternalInstallerIDAND iie.ComplianceConnectionID = iiiem.ComplianceConnectionIDLEFT JOIN SoftwareTitleInstallerEvidence stieON iiiem.InstallerEvidenceID = stie.InstallerEvidenceIDLEFT JOIN SoftwareTitle stON stie.SoftwareTitleID = st.SoftwareTitleID

            ?

            Expand Post
            Selected as Best

            • JS155794

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

               

              ~Jeff

                • JS155794

                  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 NameSoftware NameEvidence Trigger NameEvidence Trigger VersionEvidence Trigger PublisherEvidence Directory on Local ComputerEvidence File on Local ComputerHWDateswdatejeffscomputerAcrobat XIAdobe Acrobat11regid.1986-12.com.adobeC:\ProgramData\regid.1986-12.com.adobe\regid.1986-12.com.adobe_V6{}AcrobatPro-AS2-Win-GM-MUL.swidtag8/27/19 1:56 PM8/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/s/FlexNet-Manager-Forum/run-system-task-manually113367M2303

                  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
                  Expand Post

                  • JohnSorensenDK (Flexera Software)

                    @jrsikors  

                    The "Evidence" tab is not yet released for the on-premise version, it's expected to be included in the 2019 R2 release later this year.

                    Thanks,

                    Expand Post

                  • mfranz

                    Hi Jeff,

                    Different evidence types (file, installer, WMI) have different data schemas in the database, so reports for other evidence types will have to target different tables and views.

                    Best regards,

                    Markward

                    Expand Post

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
details of evidence