[help] Report if custome scanned registry is less than specified value

[spgs]

Of course I can run "instant" report for the Custome registry scan, but I want a report that shows all assets where the value IS less then specified value

Kind of like here:

https://www.lansweeper.com/forum/yaf_postst7354_Report-Based-on-Registry-Keys.aspx#post31052

but not for exact value

Thanks

Seb

[spgs]

Did I already ask it?

https://www.lansweeper.com/forum/yaf_postst14932_Registry-key-scan-OK--but-report-This-report-has-no-results.aspx#post50810

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
 TsysLastscan.Lasttime As LastRegistryScan,
  Case
    When TsysLastscan.Lasttime < GetDate() -
    1 Then
    'Last registry scan more than 24 hours ago! Scanned registry information may not be up-to-date. Try rescanning this machine.' End As Comment,
  Case
    When SubQuery1.Valuename Is Not Null And SubQuery1.Valuename <>
    '' Then 'Yes' Else 'No' End As ValuenameFound,
  Case 
When replace(SubQuery1.Value,'.','') = '16092262156' Then 'Latest' 
When replace(SubQuery1.Value,'.','') <> '16092262156' Then 'Needs upgrade'
Else '' End As IsLatest,
  SubQuery1.Value,
  SubQuery1.Regkey,
  SubQuery1.Valuename,
  SubQuery1.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblRegistry.AssetID,
    tblRegistry.Value,
    tblRegistry.Regkey,
    tblRegistry.Valuename,
    tblRegistry.Lastchanged
  From tblRegistry
  Where
    tblRegistry.Regkey Like
    '%SOFTWARE\Microsoft\Office\ClickToRun\Configuration' And
    tblRegistry.Valuename = 'VersionToReport') SubQuery1 On SubQuery1.AssetID =
    tblAssets.AssetID
Where tblAssetCustom.State = 1 And TsysWaittime.CFGname = 'registry'
Order By tblAssets.Domain,
  tblAssets.AssetName

Change the numbers as you need it for the version that you are using...