Hi Janice,
- For #1: Especially for SUN and Oracle Java, it is common that the 'ProductVersion' and 'FileVersion' properties for file evidence linked to an application is not consistent with the application version itself.
The SQL statement below retrieves all applications where the version numbers don't match. With ARL #2590, this statement returns 440 rows. You can see the results in the Excel file attachment 'JavaFileEvidence VersionNoNotMatching.xlsx'.
- For #2 & #3: If you change the WHERE condition in the SQL script to check for non-empty [FilePath] data, you'll see a lot of strange file path data including the one that you reported. This does not result in problems with application recognition as the file path is not used for this purpose.
I have no idea who 'brian.t.gallagher' might be 😁 and why local Java file evidence information from his computer has been picked for the FNMS ARL :-). Basically, providing [FilePath] information with the ARL especially for Windows seems to be a waste of disk space and network bandwidth though.
SELECT
st.[FullName]
,stt.[DefaultValue] As SoftwareTitleType
,stp.[ProductName]
,stv.VersionName AS Version
,ste.EditionName As Edition
,oms.DescriptionDefaultValue As OperatorManageState
,stc.DefaultValue AS [SoftwareTitleClassification]
,ge.Path AS [Category]
,st.[ReleaseDate]
,st.[HasInstalls]
,fe.FileName
,fe.FileVersion
,fe.ProductName
,fe.ProductVersion
,fe.Company
,fe.FilePath
,eer.RuleDefaultString AS EvidenceExistenceRule
FROM [SoftwareTitle] st
JOIN [SoftwareTitleType] stt
ON st.[SoftwareTitleTypeID] = stt.[SoftwareTitleTypeID]
JOIN [SoftwareTitleProduct] stp
ON st.[SoftwareTitleProductID] = stp.[SoftwareTitleProductID]
LEFT OUTER JOIN [SoftwareTitleVersion] stv
ON st.[SoftwareTitleVersionID] = stv.[SoftwareTitleVersionID]
LEFT OUTER JOIN [SoftwareTitleEdition] ste
ON st.SoftwareTitleEditionID = ste.SoftwareTitleEditionID
JOIN [OperatorManageState] oms
ON st.[OperatorManageStateID] = oms.OperatorManageStateID
JOIN [SoftwareTitleClassification] stc
ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID
JOIN GroupEX ge
ON ge.GroupExID = st.CategoryID
JOIN SoftwareTitleFileEvidence stfe -- provides the [FileEvidenceID]
ON stfe.SoftwareTitleID = st.SoftwareTitleID
JOIN [FileEvidence] fe
ON fe.FileEvidenceID = stfe.FileEvidenceID
JOIN [EvidenceExistenceRule] eer
on eer.EvidenceExistenceRuleID = stfe.EvidenceExistenceRuleID
WHERE
1 = 1
AND (fe.Company LIKE 'Oracle%' OR fe.Company LIKE 'SUN%')
AND stp.ProductName LIKE '%JAVA%'
AND LEFT(stv.VersionName,1) <> LEFT(fe.FileVersion,1)
ORDER BY fe.Company, st.[FullName]
