EMR softare: eClinicalWorks Plugin version report

[duster1]

I've written an updated report for the eClinicalworks Plugin.
As of December 2025, the version is now 6.8.1572

As the versions increase, update the When p.Major, p.minor and p.build to match the newest version.
Contact eClinicalWorks for the current version.

Select Top 1000000 p.AssetID,
  p.AssetName,
  p.Domain,
  p.AssetType,
  p.Username,
  p.Userdomain,
  p.icon,
  p.IPAddress,
  p.Software,
  p.Version,
  p.Publisher,
  Case
    When p.Major > 6 Then 'Up to date'
    When p.Major < 6 Then 'Out of date'
    When p.Minor > 8 Then 'Up to date'
    When p.Minor < 8 Then 'Out of date'
    When p.Build >= 1572 Then 'Up to date'
    Else 'Out of date'
  End As [Patch Status],
  p.IPLocation,
  p.Manufacturer,
  p.Model,
  p.OS,
  p.SP,
  p.Lastseen,
  p.Lasttried,
  p.Lastchanged,
  Case
    When p.Major > 6 Then '#d4f4be'
    When p.Major < 6 Then '#ffadad'
    When p.Minor > 8 Then '#d4f4be'
    When p.Minor < 8 Then '#ffadad'
    When p.Build >= 1572 Then '#d4f4be'
    Else '#ffadad'
  End As backgroundcolor
From (Select b.AssetID,
      b.AssetName,
      b.Domain,
      b.AssetType,
      b.Username,
      b.Userdomain,
      b.icon,
      b.IPAddress,
      b.Software,
      b.Version,
      b.Publisher,
      b.IPLocation,
      b.Manufacturer,
      b.Model,
      b.OS,
      b.SP,
      b.Lastseen,
      b.Lasttried,
      b.Lastchanged,
      IsNull(Try_Convert(INT,ParseName(b.CleanVer, 3)), 0) As Major,
      IsNull(Try_Convert(INT,ParseName(b.CleanVer, 2)), 0) As Minor,
      IsNull(Try_Convert(INT,ParseName(b.CleanVer, 1)), 0) As Build
    From (Select tblAssets.AssetID,
          tblAssets.AssetName,
          tblAssets.Domain,
          tsysAssetTypes.AssetTypename As AssetType,
          tblAssets.Username,
          tblAssets.Userdomain,
          tsysAssetTypes.AssetTypeIcon10 As icon,
          tblAssets.IPAddress,
          tblSoftwareUni.softwareName As Software,
          tblSoftware.softwareVersion As Version,
          tblSoftwareUni.SoftwarePublisher As Publisher,
          tsysIPLocations.IPLocation,
          tblAssetCustom.Manufacturer,
          tblAssetCustom.Model,
          tsysOS.OSname As OS,
          tblAssets.SP,
          tblAssets.Lastseen,
          tblAssets.Lasttried,
          tblSoftware.Lastchanged,
          NullIf(Left(tblSoftware.softwareVersion, PatIndex('%[^0-9.]%',
          tblSoftware.softwareVersion + 'X') - 1), '') As CleanVer
        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 '%eClinicalWorks Plug-in%' And
          tblState.Statename = 'Active') b) p
Order By p.Domain,
  p.AssetName,
  p.Software

[duster1]

Been busy and found my W didn't work for the title.
It should actually be EMR Software: eClinicalWorks Plugin version report