This should work may need some tweaking SELECT
v_R_System.Name0 AS[Server Name], v_GS_OPERATING_SYSTEM.Caption0 AS[Operating System], v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS[Last Machine Boot Up Time], v_GS_WORKSTATION_STATUS.LastHWScan AS[Last HW Scan Date], V_GS_LASTSOFTWARESCAN.LASTSCANDATE AS[LAST SOFTWARE SCAN DATE], v_GS_OPERATING_SYSTEM.Installdate0 AS[Create Date] FROM v_R_System INNER JOIN v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID=v_R_System.ResourceID INNER JOIN v_GS_LastSoftwareScan ON v_R_System.ResourceID=v_GS_LastSoftwareScan.ResourceID INNER JOIN v_GS_WORKSTATION_STATUS ON v_R_System.ResourceID=v_GS_WORKSTATION_STATUS.ResourceID where v_GS_OPERATING_SYSTEM.Caption0 like '%Windows 10%' Robert F. Smith Enterprise Operations Systems Management Infrastructure Phone 703-949-2368 Cell 203-524-2172 From: [email protected] [mailto:[email protected]] On Behalf Of Boseman, Marcia H - Raleigh, NC Sent: Wednesday, August 31, 2016 4:15 PM To: [email protected] Subject: EXT :[mssms] Query Assistance Does anyone have a SQL query or SCCM 2012 report that would show all windows 10 machines that became new clients on a daily basis?
