Rocket Man

Hi Garth I have this query fully tested in my environment. At The moment in one of my sites I have just started to roll out office 2013. In my head I had a rough estimate as to what I had already done which was around 10-13 machines out of a total of 3555 If I leave the != Microsoft Office Professional Plus 2013 then the query returns 3542 systems to the collection(which would be correct) I change the syntax to just = Microsoft Office Professional Plus 2013 then the query returns 13 systems to the collection(which is also correct) So that to me means that the query language is working, should it not be?? Thanks

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS as Software on Software.ResourceId = SMS_R_System.ResourceId where Software.DisplayName != "Software" Just paste the above in the query language and change the Software section to suit your queried software i:e Microsoft Office professional Plus 2013

Did you try and exclude it by it's Bulletin ID? -"MS12-077" for both x86 & x64 machines

To use a software TS just create a custom TS and then edit it and attach your package/application. Deploy it to systems as available, and as far as I remember with 2007 it should display in the Run advertised Programs list so the end user can initiate the install. You can forget about my first comment as I thought you were using SCCM 2012 which has the app catalog for end user installs!!

You can bypass it if you like as server 2012 installs .net 4.5 features by default, but if you intend using the APP catalog you will also need to activate 3.5 which can be done from the server features, it is there just dig into the options and you will find them!!

You need to capture a prebuilt image first and then deploy the captured wim back out, this will then install on the C: drive!!

More a suggestion than a fix, Until you get another workaround like an msi installation of office you could just deploy office solely as a task sequence then you have the TS progress bar! Rocket Man

Have a production site built now and serveral test sites prior all on 2012 products, SCCM 2012SP1, Server 2012 and SQL 2012 ENT all on a VM sitting on Hyper-V2012, so far so good, will know more when this expands out to 29 more remote locations, with the intention of the DPs also been a server 2012 build on a VM on Hyper-V 2012!! Rocket Man

You need to set new classes in the hardware inventory in the client. They by default are not enabled. The classes that need to be enabled in order for your asset intelligence to pick up inventoried software are: Installed executable Installed Software Both of which are Asset Intelligence classes. This will also then populate your Resource explorer on your systems with 2 new nodes namely Installed Executable and Installed Software. After some time approx 1 day your asset intelligence node will populate with the software on all your systems!! As Garth mentioned you do not need to setup your asset intelligence sync point in order for asset intelligence to report, I have not and all my sites asset intelligence node are populated with inventoried software after doing the above. Rocket Man

Thanks Peter, it does make sense when you think of it......... will try these custom ADR collections. Not worth the risk of pointing 2 ADRs to the same source folder, it possibly may work but at the moment I have no test sites to test this at, and to be honest your suggestion sounds more practical and logical!! Thanks

You could create a customized version of an office installation by creating an MSP file this is just one source on how to achieve this: http://technet.microsoft.com/en-us/library/cc178993.aspx Once you have your MSP file created you can place it in the root of the main office media files(some prefer to place it in the updates folder and use the setup.exe /S switch) and then you could create an application from it, even though you will still be using the legacy setup.exe.(so you will possibly need all the installation files, not sure as i have never just installed a single component) You will have to manually configure the application as it is not an msi, the install parameters would be this setup.exe /adminfile yourcustomfile.msp, you will also have to create a detection method(up to you how you configure this reg key, file name etc..) Once you have your app created you could make it available to end users and they can browse the APP catalog for it. They can start the install and it will show in the software center when it has finished. Not sure how you can have a progress bar with the exe installation, but if it is a case your afraid your users will switch off the machine before the installation has finalised show them that the software center will prompt them when the installation has finished!

Is it that you think you need to create a dependency in order to create an application?? Applications do not need you to create a dependency, the option is optional so to speak. Also I see you are trying deploy WMF3.0 as part of your OSD?? Is this not the update that breaks SCCM management point and windows7 client communication!! It was released approx a couple of months ago and wreaked havoc on many SCCM infrastructures! http://myitforum.com/myitforumwp/2012/12/15/wmf3-0-hits-microsft-update-catalog-possible-issues-with-configmgr-2012/ Pay particular attention to the last paragraph! Rocket Man

Hi Garth I think you have misunderstood me. I do have seperate instances at some of my sites, but they are both the same SQL_Latin1_General_CP1_CI_AS!! The point I am trying to get across for the purpose of this thread, would it not have been possible for gvlaarho to create a new instance on his already exsisting SQL 2K8R2 server and specify it to have a SQL_Latin1_General_CP1_CI_AS collation. I feel the answer is yes due to me been able to specify a different collation for the WSUS instance(which I specified to be SQL_Latin1_General_CP1_CI_AS) the same as my configMgr instance collation!!

Hi Garth Yes I do know that both roles can reside on the same instance, but in production it is recommended to use 2 seperate instances to host the configMgr DBs and the WSUS DBs. Apparently it is easier to rectify problems if they arise if they are on seperate instances!! But just for the circumstances above(I see this an old post now and is probably of no use as it is more than likely sorted by now), would this have not been option? I am not a SQL person but I do remember been able to choose a different collation on the separate WSUS instance, so that to me means that the the same 2K8R2 Sql server could have been used if a new instance was created?? Rocket Man

I may be wrong on this: Is it not possible to create a new instance on the already existing SQL server for the SCCM DB and have the proper SQL collation on this? It is recommended to have a dedicated SQL server for SCCM but if your enviornment is only light then this could be an option if it works! Maybe I am wrong but whenever I set up 2 instances, one for the configMgr DB and one for WSUS, I could choose the collation on both and have different collations if I so wished! Does an instance not have it's own DB engine seperate from other instances that reside on the same SQL setup??

I have the extracted drivers in a folder, I create an empty folder inside this and name it appropriately e:g modelxxdriverpack, during the import of the actual extracted drivers folder i also create the driver package at this time and point it to the empty folder, this then populates with the driver packages that SCCM uses when targeting model specific systems. Not sure if this is the correct way bu you will notice if you have a folder with your extracted drivers in it and during the initial import you try and also create the driver package it will not allow you to create it unless you point it to an empty folder!! This is the way I have sorted my drivers out and have never had problems with systems pulling down the drivers!!

Not sure if this is theory or factual, anybody any true evidence of this?? Never have I ever seen the CPU running at this level, 85%, normally runs at zero% at any of my sites even at peak times which is from 8am-6pm daily(SCCM2012 not 2007) And finally, not saying this is Bible, but again not to be brushed aside http://blog.coretech.dk/kea/system-center-2012-configuration-manager-sql-recommendations/ As I did say some people have their prefered infrastructure methods, this happens to be mine, touch wood my sites stay the same as they have been since the release of sccm2012, and do not suffer because the roles are all on the same virtual machine! Rocket Man

OK, Just back at this SP1 site and now everything is OK(have done nothing), it is booting as it should from a f12 press..... Still very strange though

It is entirely up to you what way to set it up........some prefer to have dedicated VMs to host the SQL and SCCM services, personally I prefer to host all on the same server, lots of disk space, plenty of RAM (16GB-24GB) and lots of CPUs, Teamed network cards for throughput....... Have never seen a DR restore from SCCM setup that has the services split onto different servers, may not be clean trying to introduce a failed SQL sccm DB server back to the main SCCM console server, could have underlying issues, but in saying that have never seen a DR restore from a single VM hosting all services, but to me I think this may be the cleaner DR restore having all services running on a single VM. But as I said everyone has their own opinion, maybe you could have your PS DP on a seperate server which may alleviate some of the traffic on the main server! Rocket Man

You set it in the setup windows and configMgr Task of your task sequence; OR you can do it on the client push properties, but this would leave all clients with a ccmcache folder of this size!! By doing it in the TS you have flexibility if you have more than 1 Task sequence. Just add a property of SMSCACHESIZE=35840 This will give the ccmcache folder an extra 30+ GB for the larger packages!! The default is set to 5120 which is 5GB!! Sure give it a go!! It may be what is wrong with the package not been able to deploy, also if this AutoCAD installation takes more than 2 hours change the default runtime from 120mins to whatever!! You dont want it bombing it out after 120mins if it has not installed!!

Have you added a CCMCACHESIZE property of more than 29GB to the configMGR setup properties on this TS if downloading locally before running TS?

No, do it the simple way!! ConfigMgr has all this built in. Create a new collection name it appropriately, limit it to all systems. Edit membership and use query rule and give it a name. Click on Edit Query Statement and click criteria tab, click yellow startburst. On Criterion properties click select On attribute class scroll to system resource On attribute scroll to System OU Name Click OK On Opertator scroll to lowercase is like At this stage you can click the value button and this should populate all your OUs from AD, just simply select the appropriate OU and click OK through the rest until collection is created!! If your OU is nested and not showing just simply type the rest of the path manually into the value field. Enjoy!! Rocket Man

Yep works like a charm..... Thanks Peter

Thanks Peter if this works this is exactly what im looking for!! It will save me copying the deployment type numerous times and editing the computer name to suit..... a list of computer names is more efficient! This wont matter as a tutor will always have the same PC in the lab so it will be only teachers that will be using this PC with the software on it!! Will try this and report back! Thanks!

Hi Peter I am making this software available in the APP catalog, so that staff can browse to it and install it.( I have made it available to the staff AD group) These staff roam so they may use any PC in the school, so I do not want them to install it on a standard PC(not that training and a bit of common knowledge from the staff would sort this out but I want to make it dummy proof), If they do browse to to the APP catalog from a standard machine and my filter was not in the deployment type then they could install it on the standard PC. This version of software is only to be installed on the specified PCs and not any other as students are not allowed to use it and if it was installed on a standard PC then they could well use it!! Do you know the proper synatx for adding multiple PC names to the filter/requirement so that i could only have one deployment type with all the computers in the requirement?? I have it working but only by adding multiple deployment types and a single Computer name in the requirement! Thanks