SQL Query for MS Office with Hostname details

SCCM Report for all versions of MS Office with Service pack and Hostname details

SELECT  dbo.v_R_System.Name0,

dbo.v_R_System.user_name0,

dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],

arp.DisplayName0,

CASE WHEN arp.version0 LIKE '11.0.6361.0' THEN 'SP1'

     WHEN arp.version0 LIKE '11.0.7969.0' THEN 'SP2'

     WHEN arp.version0 LIKE '11.0.8173.0' THEN 'SP3'

     WHEN arp.version0 LIKE '12.0.6215.1000' THEN 'SP1'

     WHEN arp.version0 LIKE '12.0.6425.1000' THEN 'SP2'

     WHEN arp.version0 LIKE '14.0.6029.1000' THEN 'SP1'

ELSE 'NULL' END as 'Service Pack', arp.Version0

FROM dbo.v_Add_Remove_Programs AS arp

INNER JOIN dbo.v_R_System ON arp.ResourceID = dbo.v_R_System.ResourceID

INNER JOIN dbo.v_RA_System_SMSInstalledSites AS ASSG ON dbo.v_R_System.ResourceID = ASSG.ResourceID

INNER JOIN dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID

  --JOIN v_FullCollectionMembership on v_R_System.ResourceID = v_FullCollectionMembership.ResourceID

WHERE 
--v_FullCollectionMembership.CollectionID = ‘@CollectionID’ AND

(arp.DisplayName0 LIKE '%Microsoft Office%edition%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Standard 2007%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Enterprise 2007%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Professional%2007%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Standard 2010%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Enterprise 2010%' OR

 arp.DisplayName0 LIKE '%Microsoft Office Professional%2010%' OR

 arp.DisplayName0 LIKE 'Microsoft Office 2000%' OR

 arp.DisplayName0 LIKE 'Microsoft Office XP%') AND

(arp.DisplayName0 NOT LIKE '%update%') AND

(arp.DisplayName0 NOT LIKE '%Microsoft Office XP Web Components') AND

(dbo.v_R_System.Operating_System_Name_and0 NOT LIKE '%server%') AND

  (arp.InstallDate0 NOT LIKE 'NULL')

ORDER BY arp.Version0, dbo.v_R_System.Name0 

Please note that the above query excludes Windows Server operating system records. You may comment Line-30 to include server OS records on the report.

If you wish to run the query to prompt for a collection, you can remove the comment on Line-16 and Line-18 to achieve it.

Microsoft Information Worker Management Pack

Applies To: Microsoft Office, Operations Manager 2007, Operations Manager 2007 R2.

   The Microsoft Information Worker Management Pack monitors the health, reliability, and performance of Microsoft Office applications and certain Microsoft Windows applications such as Microsoft Windows Explorer, Microsoft Internet Explorer, Windows Media Player, Microsoft Mail and Outlook Express.

Objects Discovered by the Information Worker Management Pack

   The Information Worker Management Pack discovers the object types described in the following list in this section. All the objects are automatically discovered by default. You can use overrides to disable objects you do not plan to monitor.

Information Worker Applications	Application Versions
Internet Explorer	5 through 7
Media Player	6 through 11
MSN and Windows Messenger	3 through 7
Outlook Express	Internet Explorer 5 through 7
Windows Explorer	Windows 2000 and Windows XP
Access	Office XP, Office 2003, and Office 2007
Communicator	2005 and 2007
Excel	Office XP, Office 2003, and Office 2007
FrontPage	Office XP and Office 2003
Groove	Office 2007
InfoPath	Office 2003 and Office 2007
LiveMeeting	Internet Explorer 7 and Office 2007
OneNote	Office 2003 and Office 2007
Outlook	Office XP, Office 2003, and Office 2007
PowerPoint	Office XP, Office 2003, and Office 2007
Project	Office XP, Office 2003, and Office 2007
Publisher	Office XP, Office 2003, and Office 2007
Visio	Office 2003 and Office 2007
Word	Office XP, Office 2003, and Office 2007

The Information Worker Library Management Pack provides generic monitoring capabilities that work for all the applications, and specific monitoring capabilities for individual applications.

• Generic monitoring:
• Crash detection
• Hand detection
• CPU utilization
• Memory utilization
• Individual application monitoring:
• Outlook mail access
• Web access
• Data source access

Ref: http://technet.microsoft.com/es-es/library/dd351475.aspx

http://technet.microsoft.com/en-us/library/dd351478.aspx

'Insert' key not working (on MS-Office products)

Office Button - Snapshot

   Click the ‘Office’ Button – click on ‘Word Options’ – then click on ‘Advanced tab’. Under the Section for ‘Editing options’, there is a check box to select “Use the Insert key to control overtype mode”. Just check that box one alone.

Refer picture: 

   Now you can use the “Insert” key in your Keyboard when you want to overtype words.

-ScorpITs