Yes I've checked win32_operating System and the description is accurate Here is the report SQL
SELECT SYS.Netbios_Name0, SE.serialnumber0, SYS.User_Name0, OPSYS.description0 as 'Local computer description', sys.description0 as 'AD System Description', IPSUB.ip_subnets0, Sys.Creation_Date0 as 'SCCM Client Install Date', OPSYS.InstallDate0 as 'OS Install Date' FROM v_R_System SYS LEFT JOIN v_RA_System_IPSubnets IPSUB on SYS.ResourceID = IPSUB.ResourceID LEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID LEFT JOIN v_GS_SYSTEM_ENCLOSURE SE ON SYS.ResourceID = SE.ResourceID JOIN v_FullCollectionMembership fcm ON SYS.ResourceID=fcm.ResourceID WHERE fcm.collectionid = @variable ORDER BY SYS.Netbios_Name0 Joseph Adamson T: 901.415.7666 C: 901.237.7195 F: 901.415.7404 joseph.adam...@sedgwickcms.com<mailto:joseph.adam...@sedgwickcms.com> joseph.adam...@fisglobal.com<mailto:joseph.adam...@fisglobal.com> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Wednesday, July 30, 2014 11:55 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: sccm 2007 The local description does not seem to update. What does the inventory log on the machine show? Any issues querying win32_operatingsystem? Can you browse the view in Resource Explorer and see the changes there? Daniel Ratliff From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Adamson, Joseph Sent: Wednesday, July 30, 2014 12:42 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] sccm 2007 The local description does not seem to update. I have a report that among other things includes the local computer description. The class I am using is "v_gs_operating_system.description0" This should be coming from the hardware inventory which runs daily in my environment. The problem is it seems that when the description is changed on the local machine and a subsequent hardware inventory is run the above class does not seem to update (as the new description is not reflected in the reports) Am I using the wrong class or am I missing something else? Joseph Adamson Senior Systems Analyst Global Shared Services Desktop Memphis T: 901.415.7666 C: 901.237.7195 F: 901.415.7404 joseph.adam...@sedgwickcms.com<mailto:joseph.adam...@sedgwickcms.com> joseph.adam...@fisglobal.com<mailto:joseph.adam...@fisglobal.com> [Description: Description: Description: Description: cid:image001.png@01CD8AB3.84921E40] [cid:image002.png@01CF8FCF.30DB14A0] [Description: Description: Description: Description: cid:image003.png@01CD8AB3.84921E40] ________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
