Monday, October 4, 2010

Query to list machines with their MS Office versions

select distinct (a.Netbios_name0), a.Creation_date0,a.User_name0,a.client0, a.ad_site_name0,a.obsolete0,b.sms_installed_sites0 as 'sitecode',
os.Caption0 + ' '+ os.CSDversion0 as 'Operating System',addr.DisplayName0,addr.Version0,addr.Publisher0,addr.InstallDate0
from v_r_system a
left outer join v_RA_System_SMSInstalledSites b on a.resourceid=b.resourceid
left outer join v_GS_WORKSTATION_STATUS c on a.resourceid=c.resourceid
left outer join v_GS_Operating_system OS on os.resourceid=a.resourceid
inner join v_GS_ADD_REMOVE_PROGRAMS addr on addr.resourceid=a.resourceid
where addr.DisplayName0 like 'Microsoft Office 2%'


Blogger Octavian said...

I try to copy this into a new query in SCCM, but I get a syntax error. Creating a new query and trying to add the database joins by hand does not seem to yield a proper result for me. Sorry, I am new at this.

March 9, 2011 at 3:45 PM  
Blogger Jaison Jose said...

these are not WQL and hence cannot create it as a query in the console. you have to either create it as a web report or directly run from your SQL query analyzer.

March 10, 2011 at 1:50 AM  
Anonymous Anonymous said...


I am looking query for office 2010 language pack.

March 13, 2013 at 11:10 PM  
Anonymous sk said...


Query to list machines with their MS Office versions in which at the end of the query u had mentioned 2% can u let me know whether does it 2% means it will give the output of entire clients 2% or how it is been calculated . As I need the query for entire clients where sccm client is been installed & thei r output.

February 4, 2015 at 11:24 PM  
Blogger Cindy Dy said...

You are an awesome blogger. This is one of the best blog I had visited so far. Hope to read more post from you in the future. Keep it up. God bless.


September 20, 2015 at 11:45 PM  
Blogger Mike said...

This is absolutely fantastic and solved a huge need for me. Thank you!

January 28, 2016 at 9:53 AM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home