Windows 10 Version and Build number

[User456]

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

[User456]

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]

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]

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]

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]

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