Sam's IT Knowledgebase

I was recently required to do an audit of Office software for Microsoft licensing and noticed the SCCM WQL queries did not pick up 64 bit installs of Microsoft Office. After a bit of investigation I read that the normal queries which work (as below) only detect 32 bit software installs. Credit to skissinger from my IT forum for this info: http://www.myitforum.com/forums/Queries-for-32bit-amp-64bit-in-addremove-programs-m232862.aspx 32 bit software query: 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 on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office professional plus 2013" 64 bit software query: It's probably the inner joins; because a x86 box won't have any 64 stuff; so nothing to join ...

SCCM - Required Application Not Installing to a collection based on an Active Directory Security Group I recently had an issue where I was trying to install Office 2013 as a required application to a collection based on an AD Security group. This would work fine if I was advertising the install as  'available', however when I set as 'required' it would not install and not even show up in Software Centre. After looking through the Monitoring section in SCCM and had a look at the deployment status I noticed it said success however the Message ID was 10040 and the description was "program will not rerun" I managed to fix this by going to the deployment settings for this collection and then going to scheduling and altering the "Rerun behaviour" to always rerun program.

Office 2013 Silent Install Setup To setup a silent install of Office 2013 follow the below steps. If you have an ISO mount the file and then copy all the files out to a folder.  Run the command \\locationoffolder\setup.exe /admin. This will bring up the Office 2013 customisation tool.  You can apply which settings you require. The main ones you probably need to apply are  Licensing and user interface - choose here if you want to use a KMS key or a MAK key. In the options for the licencing agreements it is best to Tick "I accept the terms of the license agreement" Display level - none Suppress modal - ticked Set feature installation states. Tick the appropriate install options and features which you want. Configure shortcuts. I came across an issue in here which appears to be a known bug. If you try to create desktop shortcuts for any of the applications it would try to force you to enter something in the "start in" field saying this is required. ...