→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
spgs
Engaged Sweeper II
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
1 REPLY 1
spgs
Engaged Sweeper II
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...