→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
User456
Engaged Sweeper II
Hi,
First I don't understand why this is not a default report.
But I would like to have a report that shows the Windows 10 Version, Build and UBR number.
Just like if you type RUN: winver
All information can be found in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion
Keys:
ProductName
ReleaseId
CurrentBuildNumber
UBR

UBR is shown in hexadecimal and needs to be converted into decimal.

Result should be like:
Windows 10 Pro
1703
15063
674

If this is possible and if anyone could help it would be greatly appreciated.
Best regards
5 REPLIES 5
User456
Engaged Sweeper II
Hi Charles,
It works 🙂 I now have the OS, Version number, Build number and Update Revision next to each other in the same report.

Thanks.
Best regards
Esben_D
Lansweeper Employee
Lansweeper Employee
If you want the registry key to contain value X or Y. If that is the case, you should be able to do the following:

Where tblRegistry.Regkey Like '%SOFTWARE\Microsoft\Windows NT\CurrentVersion'
And (tblRegistry.Valuename = 'CurrentBuildNumber' Or tblRegistry.Valuename = 'ReleaseId') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID


For getting multiple values in one report, you will need a second subquery like:

 Left Join (Select Top 1000000 tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where
tblRegistry.Regkey Like
'%SOFTWARE\Microsoft\Windows NT\CurrentVersion' And
tblRegistry.Valuename = 'ReleaseId') SubQuery2 On SubQuery2.AssetID =
tblAssets.AssetID


FYI I moved this topic to report request as this is report related.
User456
Engaged Sweeper II
Hi again,
How do I add an extra Valuename to a query?
Having this:
Where tblRegistry.Regkey Like '%SOFTWARE\Microsoft\Windows NT\CurrentVersion'
And tblRegistry.Valuename = 'CurrentBuildNumber') SubQuery1
On SubQuery1.AssetID = tblAssets.AssetID

I also would like to add this value to the above query:
tblRegistry.Valuename = 'ReleaseId'

TIA
User456
Engaged Sweeper II
Thanks, I will have a look.
Would be nice though if this was a official Lansweeper report.
Win 10 is everywhere now. And the new 1709 just came out.
Esben_D
Lansweeper Employee
Lansweeper Employee
Just to get the ball rolling, some of the information you are looking for is already present in Lansweeper. I would suggest taking a look at the database dictionary to look up where this information is stored. This topic explains where to find the database dictionary: https://www.lansweeper.com/Forum/yaf_postst9870_Lansweeper-database-dictionary.aspx#post38296

Additionally you can use the built-in report 'OS build report' as inspiration to help you along. Some of the information you want is already in there.

Lastly, if you do need information from a specific registry key. This report might be useful too to take parts from: https://www.lansweeper.com/Forum/yaf_postst10451_Value-of-a-value-name-submitted-for-custom-registry-scanning.aspx#post39295