Welcome to my Configmgr and Configmgr Reporting Blog, here I will share some of my custom reports for Configmgr 2012/Current Branch with description on how to adapt them to your environment. I'll also post some general Configmgr stuff and some tips and tricks for report building
Wednesday, June 29, 2016
v_GS_OPERATING_SYSTEM not updating correctly
I'm working on my Windows 10 Report ,but i've run into a strange problem and i'm wondering if anyone else sees the same thing.
The problem seems to be that v_GS_OPERATING_SYSTEM SQl view is not updating correctly. lots of machines that have been upgraded to Windows 10 still show their old Operating system.
v_r_System seems to be correct and i have verified that the machines are running windows 10
If anyone running Configmgr 1511 or 1602 could run this query and see if they have the same problem that would be great.
Reply here or on twitter.
SELECT A.name0,
A.user_name0,
A.client_version0,
D.caption0,
A.build01,
A.osbranch01,
B.NAME,
B.state,
C.value,
C.localeid,
D.installdate0,
A.operating_system_name_and0
FROM v_r_system A
LEFT OUTER JOIN vsms_windowsservicingstates B
ON B.build = A.build01
AND B.branch = A.osbranch01
LEFT OUTER JOIN vsms_windowsservicinglocalizednames C
ON B.NAME = C.NAME
LEFT OUTER JOIN v_gs_operating_system D
ON A.resourceid = D.resourceid
WHERE A.build01 LIKE '10.%'
Add And D.Caption0 not like '%10%' to the end of the query to only show entries with the wrong caption
Btw! here's a sneak peak of the Windows 10 Report I'm working on
Subscribe to:
Post Comments (Atom)
Hi Thomas,
ReplyDeleteCool report. I've ran the query and I don't have any problem on my side.
Yes, I have the exact problem. Did you managed to find fix for it?
ReplyDeleteNo ,not yet.
DeleteMy theory is that there is something wrong in Configmgr 1602 or 1511. Got two standalone primary sites and it's happened on both of them. The clients them self seems fine ,all of the scans run as normal.
This comment has been removed by the author.
ReplyDeleteThat is really good report, you did some good analysis here which is of great use for many people. Thank you for sharing it and keep posting more such posts
ReplyDelete