May also, check the system's last hardware scan date by adding this to the select and join statements:
ws.LastHWScan [Last Hardware Scan] left join v_GS_workstation_status ws on sys.resourceid = ws.resourceid On Wed, Jul 30, 2014 at 3:12 PM, Adamson, Joseph < [email protected]> wrote: > 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 > > [email protected] > > > > [email protected] > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Daniel Ratliff > *Sent:* Wednesday, July 30, 2014 11:55 AM > *To:* [email protected] > *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:* [email protected] [ > mailto:[email protected] <[email protected]>] *On > Behalf Of *Adamson, Joseph > *Sent:* Wednesday, July 30, 2014 12:42 PM > *To:* [email protected] > *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 > > > > [email protected] > > > > [email protected] > > > > [image: Description: Description: Description: Description: > cid:[email protected]] > > > > [image: cid:[email protected]] > [image: Description: Description: Description: Description: > cid:[email protected]] > > > > > ------------------------------ > > 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. > > > >
