Notification

Icon
Error

Windows 10 OS Builds - A report that displays the full Window 10 OS build number

Posted: Thursday, May 16, 2019 8:02:34 PM(UTC)
pfenton

pfenton

Member Original PosterPosts: 26
0
Like
I have pieced together this report that reports the full OS Build of Windows 10. It works, but it relies on 2 custom registry scans. The 2 custom scans are both from \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion. One is ReleaseID, and the other is UBR. In my case they would represent 17763, and 503 respectively.
After looking around at other reports, it seems that both of these keys are being scanned with out the custom scanning. I would like the report to work without the custom scanning, but can't figure it out. I am not a coder. I literally pieced together my report from other reports and a lot of guess work. Any help would be appreciated.


Select Top 1000000 tblAssets.AssetName,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.OScode As [OS Build],
SubQuery.Value As [Sub Build],
tblAssets.IPAddress,
tblAssets.Lastseen,
tblRegistry.Value As [Build #]
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Valuename,
tblRegistry.Value,
tblRegistry.Lastchanged
From tblRegistry
Where tblRegistry.Valuename = 'UBR') SubQuery On SubQuery.AssetID =
tblAssets.AssetID
Inner Join tblRegistry On tblAssets.AssetID = tblRegistry.AssetID
Where tblRegistry.Valuename = 'ReleaseID' And tblAssetCustom.State = 1
Order By [OS Build],
[Sub Build]
endyk
#1endyk Member Posts: 24  
posted: 5/17/2019 1:19:57 AM(UTC)
Hello-

I'm not sure I fully understood your needs. But this query below should returns all OS build of windows. You can look at the result set and let me know what you want or don't want included in the result. We can continue from there.

Select Top 1000000
tblAssets.AssetName,
tsysOS.OSname,
tsysOS.Image As icon,
tblAssets.OScode As [OS Build],
tblRegistry.Value As [Sub Build],
tblAssets.IPAddress,
tblAssets.Lastseen,
tblRegistry.Value As [Build #],
tblRegistry.Valuename,
tblAssetCustom.State
From tblAssets
Inner Join tsysOS
On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom
On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblRegistry
On tblAssets.AssetID = tblRegistry.AssetID
Order By [OS Build],
[Sub Build]

Active Discussions

Lansweeper Clients missing specific Office feature
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:28:26 AM(UTC)
Report Center Windows 10 compliance (color-coded)
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:15:07 AM(UTC)
Lansweeper User association report query
by  endyk   Go to last post Go to first unread
Last post: Yesterday at 9:47:25 PM(UTC)
Lansweeper Report for SSAS and SSIS
by  The Boss  
Go to last post Go to first unread
Last post: 6/25/2019 6:53:21 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: 6/25/2019 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc  
Go to last post Go to first unread
Last post: 6/25/2019 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen   Go to last post Go to first unread
Last post: 6/25/2019 8:40:47 AM(UTC)
Lansweeper Dell SupportAssist CVE-2019-12280
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 9:15:20 AM(UTC)