Is it possible to determine which service update a Windows 10 box is running using SLM? For example, can we get a report from SLM detailing machines running Windows 10 1507?
I would not know that this is possible in SLM8. But if you're running Snow Inventory, you can create a query.
From memory, you are hosted so this answer is probably no good for you, but just in case other customers are looking for the same information. I have put together a SQL query that will pull the information you have requested.
In the Inventory 3 (snowdb) database, there is information on the build number of the operating system installed, I used a microsoft article to translate this build number into the product version (https://technet.microsoft.com/en-us/windows/release-info.aspx)
The I put together a query to return the hostname, operating system, build number and then convert the build bumber into a version.
This query should be run against the SnowDB database (Assuming you are running inventory 3).
Hope it helps someone.
select vci.[Name] as 'Computer Name', vos.[Name] as 'Operating System', [BuildNumber] as 'OS Build',
when [BuildNumber] = 10240 then 1507
when [BuildNumber] = 10586 then 1511
when [BuildNumber] = 14393 then 1607
when [BuildNumber] = 15063 then 1703
END AS 'OS Version'
from vclient vci
inner join voperatingsystem vos on vci.ClientId = vos.ClientId
where vos.[name] like '%windows 10%'
order by BuildNumber
Thanks Mark - very useful. We're hosted but potentially I can get our
hoster to run this.
Given the new release frequency for Windows 10 updates getting visibility
of this in the product would seem to be essential - particularly important
for reporting on OS security patch coverage
Hi,First many thanks to Mark for this very helpful information and buildnumber codes.We still have a lot of Inventory Clients 3 and with that information I can get the OS version.
But we already started a pilot with Agent 5, and Agent 5 now directly collects this Windows 10 version.You can see it in Snow Inventory, but there are also possibilities to find that in Snow License Manager.
Carloa, Could you use add the Registry key to the Scan location of the client and use a custom field to populate this into a computer report?
Hi Duncan, I hope I understood your question correctly, otherwise please let me know.
Yes, we already added a registry scan to the configfile.We collect HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion;ReleaseId
And we have a custom procedure in Data Update Job, that imports this collected Regkey to our custom field, that we named "Windows ReleaseID".So this is available for us also in a computer report.
But I also noticed, that the Windows version is available by default in the application details for Windows 10 editions.So also when you don't have a custom procedure, but have already Agent 5 then you can see that version in SLM.
Yes you did understand me correctly, its good to know that works. Im using inventory v5 so im seeing the different versions already.
Ah, great question! We had to do this manually earlier this year by identifying the different SP numbers. It was fun(!)
It would be great if this was an extra column in Snow that showed the 'level' of OS that's installed without having to do any additional scripting. Massive help from a security standpoint too in the event of WannaCry Part II!
Can someone from Snow confirm that you have a feature request on adding reporting capabilities on this? It seems both simple to make and an obvious improvement to be able to get a list of computers running a specific version of Windows 10 or get a list of all computers listing their version number.
Or must feature requests be submitted through support?
Or maybe Snow should start treating these updates as new versions. So have a numbering scheme like macOS: 10.11, 10.12 etc.
After all, these have end of life dates that we need to pay attention to and with the new feature of tracking end of life software, it makes sense to have the feature updates as separate operating system versions.
Here is how to find out the version / Build of Windows Operating system
Hold Windows logo key and press R key on your keyboard.
Once the run command box windows opens up, type winver in it and hit enter.
Now, the windows just popped up will tell you which version of windows OS and build you are running on your PC.
Retrieving data ...