Hello,
In our customer estate, we observed there are lots of "unspecified" editions for "Toad for Oracle" versions from 9 to 13.1 and Toad Data Point 4.3.
Can you please suggest how to get the correct edition for all these products
Regards
Rajesh Ponnala
Jun 17, 2019 02:14 AM
Hi @ImIronMan ,
The information you are looking for can be found in the Information field for each application in question - just open up the application record to find it.
Best,
Natalie
Jun 17, 2019 12:39 PM
Hi @Natalie No, I just checked the information field, it does not show the edition name, instead it says "This application is for an unspecified edition of this software. Most inventory systems do not return sufficient information to be able to accurately determine details of what edition of the product has been installed" Is there any work around ?
Jun 19, 2019 06:51 AM - edited Jun 19, 2019 07:09 AM
Hi,
I would like to clarify, if the original evidence would allow for edition recognition or not.
Famous example would be MS SQL Server, where the installer alone would include version details, but not editions. For such applications additional data needs to be collected. Adobe DC is similar in that regard.
To see the original evidence, you either need a FNMS Reporting enhancement or look into the database or NDI file. Here is a sample query:
SELECT ic.ComputerName ,iie.DisplayName ,iie.Version ,iie.Publisher FROM ImportedComputer ic JOIN ImportedInstalledInstallerEvidence iiie ON ic.ExternalID = iiie.ExternalComputerID AND ic.ComplianceConnectionID = iiie.ComplianceConnectionID JOIN ImportedInstallerEvidence iie ON iiie.ExternalInstallerEvidenceID = iie.ExternalInstallerID AND iiie.ComplianceConnectionID = iie.ComplianceConnectionID WHERE iie.DisplayName LIKE '%toad for oracle%'
If you can make out editions in the evidence, there could just be a recognition issue and some changed/addition patterns maybe fix it.
If you cannot make out editions from the data, you have a data quality issue and will need to look into alternatives. Some examples:
Depending on your findings, you could then look into a technical solution.
Best regards,
Markward
Jun 19, 2019 08:23 AM
Hi @ImIronMan ,
What are you using as an inventory source? Using FlexNet Inventory for this may yield better results - would be worth testing.
The message in the application suggests there is a known limitation with many inventory sources in terms of gathering the required information. That said, I don't know if FlexNet Inventory is the solution and would welcome others who have worked with Toad for Oracle recognition.
Jun 19, 2019 05:26 PM
Quest Toad is one of those applications which require additional application-specific data to be gathered and interpreted in order to identify what edition is installed.
I have worked with one organization who has sought to automate this with the following dance moves:
The following logic was used in fabricating installer evidence:
Of course, sending a list of license keys found to be used across the organization to the vendor can raise some questions, especially as it is common for Toad software to be used with pirated license keys. See the following posting for some thoughts on engaging with vendors: Oracle LMS Services.
Note that this solution was put in place some years ago (~2011), so there is every possibility that it may not be relevant for newer Toad releases. I hope this helps, but please do your own research and post here if you discover more current information.
Jun 20, 2019 01:08 AM