In order to know what you "mean" by new clients... what does a new client mean to you? - Has been a windows 10 image for days/weeks/years, but just lately had the CM client installed? in that case, you can look at v_agentdiscoveries where agentname='mp_clientregistration' ... and use AgentTime there. - your windows 10 boxes only become CM clients because you use OSD, so the hinv result of v_gs_operating_system .Installdate0 is a good indicator of "new client" -- because for some strange reason your environment seems to constantly uninstall/reinstall the CM client, so a box might have been a CM client for years and years; but people uninstall/reinstall the client all the time and mp_clientregistration happens over and over again for multiple boxes, so it's not as useful? so the installdate0 of the OS is a better indication of "new client" vs mp_clientregistration. - some other indication of "new client" that is special to your environment, that I haven't thought of.
On Wed, Aug 31, 2016 at 3:43 PM, Smith, Robert F (ES & CSO) < robert.f.sm...@ngc.com> wrote: > 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:* listsad...@lists.myitforum.com [mailto:listsadmin@lists. > myitforum.com] *On Behalf Of *Boseman, Marcia H - Raleigh, NC > *Sent:* Wednesday, August 31, 2016 4:15 PM > *To:* mssms@lists.myitforum.com > *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? > > > > -- Thank you, Sherry Kissinger My Parameters: Standardize. Simplify. Automate Blogs: http://www.mofmaster.com, http://mnscug.org/blogs/sherry-kissinger, http://www.smguru.org