RE: [mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Jason Sandys
No, your conclusion is incorrect. That's the point of the express updates - only the binary bits that are needed will be downloaded by the client. J From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Robert Spinelli Sent: Thursday, September 1, 2016 3:49

RE: [mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Robert Spinelli
Michael I should of worded it better. Current model July patches come out and there are 10 individual updates August patches come out and there are 10 individual updates September patches come out and there are 10 individual updates Machine comes online and needs: 1 patch for July updates that

RE: [mssms] RE: SQL Query Help with total and count

2016-09-01 Thread Garth Jones
ay.. but having looked at this again.. You can do it easy enough.. it is listed on my old blog site. http://sccmug.ca/2014/03/19/count-of-pcs-by-ou-v2/ Garth Jones Chief Architect www.Enhansoft.com [Description: Description:

RE: [mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Michael Niehaus
They are called "express installation files." WU, WU for Business, and WSUS support them (because they just tell the WU agent "here's the content, download what you want"), but not ConfigMgr yet (as it downloads the content and then tells the WU agent "the update is in this local folder,

Re: [mssms] RE: SQL Query Help with total and count

2016-09-01 Thread Todd Hemsell
missing the counts per ou. :) On Thu, Sep 1, 2016 at 10:31 AM, Garth Jones wrote: > Try this., > > > > select > >DS.Name0 as'Computer Name', > >DS.Creation_Date0 as 'Date', > >DS.Operating_System_Name_and0 as 'Operating System', > >

RE: [mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Jason Sandys
Although ConfigMgr doesn't have support for it yet, WSUS and the WUA fully support only downloading the delta of the binary update package that is needed. I can't remember what this is called though. So, it's not like they don't have this one covered - or will soon as I know it's on the "list"

[mssms] RE: SQL Query Help with total and count

2016-09-01 Thread Garth Jones
Try this., select DS.Name0 as'Computer Name', DS.Creation_Date0 as 'Date', DS.Operating_System_Name_and0 as 'Operating System', OS.Caption0, max(OU.System_OU_Name0) as 'OU Name' FROM dbo.v_R_System DS Inner Join dbo.v_RA_System_SystemOUName OU on

RE: [mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Robert Spinelli
Yeah, not really much we can do about sucking it up. I guess my real concern now is how much the client will need to download now, even if they just need 1 patch. I feel like we're back to SMS 2003 with ITMU, which made you download all patches even if you just needed one. From:

Re: [mssms] SQL Query Help with total and count

2016-09-01 Thread Todd Hemsell
select VRS.Name0 [Computer Name], VRS.Creation_Date0 [Date], VRS.Operating_System_Name_and0 [Operating System], O.OU [OU Name], C.Instances AS [MachinesInOU] FROM V_R_System VRS -- want to remove duplicates LEFT JOIN (Select ResourceID, MAX(System_OU_Name0) AS [OU] From v_RA_System_SystemOUName

Re: [mssms] RE: Query Assistance

2016-09-01 Thread Sherry Kissinger
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

[mssms] New Servicing Model Win7, etc. - Next Month

2016-09-01 Thread Robert Spinelli
I read the article below which gave some good detail in regards to new servicing model that MS is introducing next month. * http://myitforum.com/myitforumwp/2016/08/31/lookout-configmgr-admins-windows-monthly-updates-are-gonna-get-huge/ MS TechNet article *

RE: [mssms] RE: Reporting on mobile devices in SCCM

2016-09-01 Thread Erik Wold
OK, thank's again. Mvh Erik From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Marcum, John Sent: 31. august 2016 13:52 To: mssms@lists.myitforum.com Subject: RE: [mssms] RE: Reporting on mobile devices in SCCM Take out the asterisks and add only the