Jump to content


Recommended Posts

I work at a community college and we have sccm clients running Office versions from 2003-2013. I have scoured the web trying to find a query that could accomplish this task, but with my lack of SQL knowledge and specificity of the statement, I couldn't find a solution.

 

Any thoughts?

Share this post


Link to post
Share on other sites


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 2010" order by SMS_R_System.Name

 

change for the office type you want and x86 or x64 version

Share this post


Link to post
Share on other sites

So have you looked at the built-in reports? Why not start with them and edit them to add/remove what you need.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...