Chrome 100 got released and the new audit is available here.
There seem to be some issues with this report as it doesn't show up version updated to v100 in green and as in up to date.
I'm having the same issue. The report is assuming a two digit version number. When it jumped to three digits it broke. It's going to be tricky to have a report that can handle both two and three digit version numbers.
I haven't worked it all out, but I believe if you use the SQL command CHARINDEX to find the first '.' in the version number you will be able to go from there.
I think I managed to get a report working that does show it correctly, its not a fancy as the original ones but for now it will do for me.
------------- Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain, tsysAssetTypes.AssetTypename As AssetType, tblAssets.Username, tblAssets.Userdomain, tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.IPAddress, Case When tblSoftware.softwareVersion Like '100.0.4896.60' And tblSoftwareUni.softwareName Like 'Google Chrome' Then 'Up to date' Else 'Out of date' End As [Patch Status], tblSoftwareUni.softwareName As Software, tblSoftware.softwareVersion As Version, tblSoftwareUni.SoftwarePublisher As Publisher, tsysIPLocations.IPLocation, tsysOS.OSname As OS, tblAssets.SP, tblSoftware.Lastchanged, tblAssets.Lastseen, tblAssets.Lasttried, Case When tblSoftware.softwareVersion Like '100.0.4896.60' And tblSoftwareUni.softwareName Like 'Google Chrome' Then '#d4f4be' Else '#ffadad' End As backgroundcolor From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tsysIPLocations On tsysIPLocations.LocationID = tblAssets.LocationID Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Left Join tsysOS On tsysOS.OScode = tblAssets.OScode Where tblSoftwareUni.softwareName Like 'Google Chrome' And tblState.Statename = 'Active' Order By tblAssets.Domain, tblAssets.AssetName, Software -----------
The reports works now. But it sorts weird. I can't get the newest version number to show up on top. I've been updating the report for each new release of Chrome, but the latest version won't show up on top.
Yeah the version field is a text field, so that's why the sorting is weird. You would almost have to sort it only on the major version, but that will require some adjustments to the report.
