RE: [mssms] WSUS Synch Issue

2014-10-15 Thread Andrew Craig
The EULA Required Updates will appear in All Updates even if not accepted. So I think you have a similar problem to David? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Paul Winstanley Sent: 14 October 2014 16:00 To: mssms@lists.myitforum.com Subject:

[mssms] RE: OT - Office 2013

2014-10-15 Thread Andrew Craig
I recently had to do something similar. Office baked in and needed a different config for a site. So I created a new msp and patched office during the ts, worked fine. This was adding a couple of components and redefining the default profile but you can quite easily create a msp to remove

Re: [mssms] WSUS Synch Issue

2014-10-15 Thread Paul Winstanley
Andrew. Fyi they did not appear in All Updates as they had not synched successfully due to EULA. Once synched they obviously were available. On 15 Oct 2014, at 07:22, Andrew Craig andrew.cr...@syliance.com wrote: The EULA Required Updates will appear in All Updates even if not accepted.

RE: [mssms] WSUS Synch Issue

2014-10-15 Thread Andrew Craig
Hi Paul, Yeah, I am going in circles, I missed that you are having sync issues. I should have said, the Updates will appear even if EULA is not yet accepted, as long as they are properly synchronized. But if the EULA data is missing or corrupt then sure they won’t show up. Then a full resync

Re: [mssms] WSUS Synch Issue

2014-10-15 Thread Paul Winstanley
Andrew, No worries. Issue was due to misconfig of the remote SUP's and I am testing this today but I'm certain all will be ok. The EULA hadn't downloaded due to issues writing to the WSUS content location therefore the synch had never completed hence nothing in All Updates. Anyway I feel I have

RE: [mssms] Install MS Visual Studio 2013 during SCCM OSD TS

2014-10-15 Thread Sander Groen
Hi Trevor, Thanks for your suggestion. You're probably right that a wrapper script will most likely work. I have decided to advertise the application after the TS has finished and run it under the user context. (User has administrative rights). Best regards, Sander Van:

Re: [mssms] WSUS Synch Issue

2014-10-15 Thread Paul Winstanley
Russ - followed the TechNet article and it still fails. EULA not downloaded. On Tue, Oct 14, 2014 at 4:12 PM, Russ Rimmerman russ.rimmer...@microsoft.com wrote: You’re sharing the same wsuscontent share on each SUP correct? You should follow pretty much the same process documented on the

[mssms] WID or Database for WSUS?

2014-10-15 Thread Brian McDonald
What's the difference between WID and DB when configuring WSUS for SCCM? Does it matter which one is used? Thanks, Brian

[mssms] RE: [MDT-SMS] OSD Task Sequences not processing CustomSettings.ini

2014-10-15 Thread Brian Marobella
Recreating the Task Sequences, CustomSettings package which is process during the Gather step, the WinPE images, MDT Files image appears to have fixed the issue. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Michael Niehaus Sent: Tuesday, October 14,

RE: [mssms] WID or Database for WSUS?

2014-10-15 Thread Justin Chalfant
WID is Windows Internal Database, DB would be using a SQL database. I generally install the WSUS database on the SQL server the site server is using rather than WID. Check this out: http://technet.microsoft.com/en-us/library/cc708452(v=ws.10).aspx Thanks, Justin Chalfant Premier Field

RE: [mssms] WID or Database for WSUS?

2014-10-15 Thread John Aubrey
I used the built in database. I was worried about SQL licenses. If I remember correctly I had it set up with SQL in a previous deployment and SCOM wasn't happy with it. Constantly throwing up alerts. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

RE: [mssms] WSUS Synch Issue

2014-10-15 Thread Russ Rimmerman
Have you gone through http://technet.microsoft.com/en-us/library/cc708545(v=ws.10).aspx to confirm all your permissions are correct, especially the WSUSContent items under the “Permissions/Disk” section? From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of

[mssms] RE: OT - Office 2013

2014-10-15 Thread Murray, Mike
This article seems to say this isn't possible. If you could share exactly how you're doing this, I'd appreciate it! http://office.microsoft.com/en-001/access-help/install-or-remove-individual-office-programs-and-components-HA010354261.aspx From: listsad...@lists.myitforum.com

[mssms] getting pending device id and not seeing why

2014-10-15 Thread Burke, John
system was unknown, so i prestaged it and still not working. I see this in the smspxe.log Doesn't this all appear good? i've already tried rebuilding the server and rebootin and all that. Folks in other areas can pxe. [010.212.017.015:4011] Recv From:[010.222.128.054:68] Len:303 ba11d8 smspxe

[mssms] Query for Systems Not in a Certain OU

2014-10-15 Thread Gushue, William
I am trying to write a query which returns all systems that are not in a certain OU, but those systems still get returned. This query works and returns the 32 items it should: select * from SMS_R_System where SMS_R_System.SystemOUName = OUName This query returns 1963 items, but includes the

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Murray, Mike
If you’re trying to build a collection, here’s a lazy way out – create a collection of computers in that OU, then exclude that collection in in the new collection. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Gushue, William Sent: Wednesday, October

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Bruce Hethcote
Use a subselect query that basically returns all systems that are “not in” the query that works. Bruce Hethcote | Technical Training Team From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Gushue, William Sent: Wednesday, October 15, 2014 2:57 PM To:

[mssms] Re: Query for Systems Not in a Certain OU

2014-10-15 Thread William Jackson
select * from SMS_R_System where SMS_R_System.ResourceID not in (select ResourceID from SMS_R_System where SMS_R_System.SystemOUName = OUName)​ William From: listsad...@lists.myitforum.com listsad...@lists.myitforum.com on behalf of Gushue, William bgus...@osler.com Sent: Wednesday, October

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Schwan, Phil
Sure it’s possible, you just need to use a nested query. Something like Select * from SMS_R_System where ResourceID not in (select ResourceID from SMS_R_System Where SystemOUName = ‘OUName’ ) -Phil _ Phil Schwan | Technical

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Daniel Ratliff
Garth just put out some nice blog posts about sub-select queries too. http://myitforum.com/myitforumwp/2014/09/25/subselect-wql-query-to-find-pcs-that-do-not-have-either-x86-or-x64-versions-of-software-installed/

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Garth Jones
You will need a subselect query. These blog post will help you. http://be.enhansoft.com/post/2014/09/17/The-Subselect-Query.aspx http://be.enhansoft.com/post/2014/09/24/Subselect-Query-for-SCCM-Queries-or-Collections-(WQL).aspx From: listsad...@lists.myitforum.com

[mssms] Automate and manage Windows operating system deployments

2014-10-15 Thread Rod Trent
Jeff Gilbert has now finished and posted up a fantastic doc on TechNet for Windows OS deployments. http://technet.microsoft.com/en-us/library/dn818437.aspx

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Gushue, William
I thought I had tried the subselect and it did not work, but I tried it just now and it does. I think I was looking at the numbers as the subselect returns 1957 when it should return 1931, but I just compared the collection to OU and none of those systems are in the subselect. Thanks to all

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Gushue, William
That is what I am trying to do and I’ll keep this for future reference. Good idea. Thanks, Mike. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Murray, Mike Sent: Wednesday, October 15, 2014 3:08 PM To: mssms@lists.myitforum.com Subject: [mssms] RE:

[mssms] User Device Affinity Security Logs

2014-10-15 Thread Murray, Mike
Hey folks, Just curious how many days you retain your logs and what size you set for the limit to ensure user device affinity works properly? Thanks, Mike Sent from Windows Mail

[mssms] RE: Query for Systems Not in a Certain OU

2014-10-15 Thread Carlson, Robert C
Select * from SMS_R_System Where SMS_R_System.SystemOUName = OUName And SMS_R_System.SystemOUName != OHHLLP.COM/IS/COMPUTERS Rob Carlson | Senior SMS - Patch Management Engineer Vanguard 2.2.1 Contract | SAIC Team | Strategic Business Systems Supporting IRM/OPS/ENM/PSD/SLM Desk phone: (703)

Re: [mssms] User Device Affinity Security Logs

2014-10-15 Thread Murray, Mike
And I know this depends on what we're logging. I guess I'm more interested in # of days than anything. Sent from Windows Mail From: Phone Ownermailto:mmur...@csuchico.edu Sent: ?Wednesday?, ?October? ?15?, ?2014 ?1?:?28? ?PM To: mssms@lists.myitforum.commailto:mssms@lists.myitforum.com Hey

[mssms] RE: OT - Office 2013

2014-10-15 Thread Schauer, Jesse (jes...@uidaho.edu)
We have a similar situation, though it's pretty close to a 50/50 split between machines with Outlook (staff machines) and machines without (student lab machines). We have our image building task sequence generate two images (with the only difference being the Outlook config) and then merge them

Re: [mssms] WSUS Synch Issue

2014-10-15 Thread Paul Winstanley
Permissions on the disk are absolutely fine and I have compared these to the Technet article. No matter what I am attempting to do I cannot get the remote SUP to sync and download the EULA. So to recap the scenario is: Local SQL on site server. No SUP installed on site server and SUP installed

[mssms] Software Updates Computer Restart Behaviour

2014-10-15 Thread Chad Beard
Hi All, Is there a way to install Software Updates via ConfigMgr but not have a reboot forced on the user? Even after the deadline is reached. Basically we just want the updates to install and the computer will just restart whenever the user does it. I know this is not ideal but currently

[mssms] RE: Software Updates Computer Restart Behaviour

2014-10-15 Thread Magnus Tveten
Never tried to do it... but I presume these tick boxes are what you are after On the Property of the Deployment of the patch group [cid:image001.jpg@01CFE939.E80345D0] MAGNUS TVETEN SERVER SUPPORT ENGINEER CO CITRIX/SERVER Insurance Australia Group Limited Lvl 1,

[mssms] RE: Software Updates Computer Restart Behaviour

2014-10-15 Thread Chad Beard
I do have those boxes ticked but I believe once it hits a deadline then it will still pop up with the notification and restart the machine. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Magnus Tveten Sent: Thursday, 16 October 2014 11:39 AM To:

Re: [mssms] RE: Software Updates Computer Restart Behaviour

2014-10-15 Thread Harjit Dhaliwal
There's a Computer Restart component in the Client Settings policy located under the Administration tab. -Harjit On Oct 15, 2014, at 10:18 PM, Chad Beard cbe...@artc.com.au wrote: I do have those boxes ticked but I believe once it hits a deadline then it will still pop up with the

[mssms] Status of required deployments

2014-10-15 Thread David O'Brien
Hi all, Before I go and check in my lab and potentially reinvent the wheel, has anybody got a query at hand that can be executed on a ConfigMgr client and check if it has installed all required deployments? In this case I am specifically talking about Software Updates, but I guess that

RE: [mssms] RE: Software Updates Computer Restart Behaviour

2014-10-15 Thread Chad Beard
Hi, I know of that option but you can only set from 1 minute to 24 hours. There isn’t an option to disable it. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Harjit Dhaliwal Sent: Thursday, 16 October 2014 1:13 PM To: mssms@lists.myitforum.com

Re: [mssms] Status of required deployments

2014-10-15 Thread elsalvoz
I have it in one of my scripts. I'll get it for you tomorrow, when I'm in the office. Btw, the returns are tricky. There is table in TechNet that maps each return integer. I will try to find it. Cesar On Oct 15, 2014 8:07 PM, David O'Brien obrien.da...@outlook.com wrote: Hi all, Before I go

RE: [mssms] RE: Software Updates Computer Restart Behaviour

2014-10-15 Thread elsalvoz
Your deployment has a setting that say disable reboot on server/workstation. Select those boxes. Cesar On Oct 15, 2014 8:20 PM, Chad Beard cbe...@artc.com.au wrote: Hi, I know of that option but you can only set from 1 minute to 24 hours. There isn’t an option to disable it. *From:*