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




5 comments:

  1. Hi Thomas,

    Cool report. I've ran the query and I don't have any problem on my side.

    ReplyDelete
  2. Yes, I have the exact problem. Did you managed to find fix for it?

    ReplyDelete
    Replies
    1. No ,not yet.
      My 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.

      Delete
  3. This comment has been removed by the author.

    ReplyDelete
  4. That 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