Se connecter
 
AccueilLibrairieFormationTéléchargementsSupport techniqueCommunautésForums
Pour les professionnels de l’informatique >
> 
> 
Query Office 2010 installs without updates or service packs

Отвечено Query Office 2010 installs without updates or service packs

  • jeudi 19 avril 2012 20:24
     
     
    Connectez-vous pour voter
    0

    I'm trying to find systems that have Office 2010 installed.  Queries I'm creating are not working.  My queries are returning systems that have many, many Office 2010 updates, etc.  I'm just trying to find out:

    -Main version installed-Office 2010 Standard, Professional, Plus, MUI etc.  Do not show updates or service packs.

    -Not include standalone Office 2010 apps like Visual Studio 2010.

    -Find both 32 and 64-bit versions of Office 2010 installed.

    Anyone have a query for this? 

     

Toutes les réponses

  • vendredi 20 avril 2012 16:52
    Modérateur
     
     
    Connectez-vous pour voter
    0
    What does you existing query look like?

    http://www.enhansoft.com/

     
  • vendredi 20 avril 2012 17:13
     
     
    Connectez-vous pour voter
    0
    What does you existing query look like?

    http://www.enhansoft.com/

    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 where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID 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 like "Microsoft Office%2010%" and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "14.0.6023") and SMS_R_System.Obsolete = 0 and SMS_R_System.Client = 1

    This does return results I know have it, but incomplete.  I'm not seeing 64-bit Office installs or those that have Office 2010 MUI installs...

     
  • vendredi 20 avril 2012 22:41
    Modérateur
     
     
    Connectez-vous pour voter
    0
    You are not seeing x64 because you are not quering the x64 bit class, take a look at the next class in the list you will see it with "_64" then you can adjust your query to get both x86 x64 systems.

    http://www.enhansoft.com/

     
  • lundi 23 avril 2012 17:26
     
     
    Connectez-vous pour voter
    0

    I tried to modify my original query to get X64 installs and it would not work. So I created the below query and it does pick up just 64-bit version of Office:

    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 where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office%2010%" and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version < "14.0.6023") and SMS_R_System.Obsolete = 0 and SMS_R_System.Client = 1

    Though two questions:

    1.  Some systems are being reported that have the full Office 2007 suite, with Office 2010 components.  i.e. Office 2007 installed with Visual Studio 2010 stand alone application.  Is there a way remove the systems that do not have the full Office 2010 suite? 

    2.  Is there a way to combine the x32 and x64 queries?

     
  • mardi 24 avril 2012 02:23
    Modérateur
     
     Traitée A du code
    Connectez-vous pour voter
    0

    1. How do you know that you have the Full Office suite?  
    2. You can check both x86 and x64 do it like this: (Note I wrote this query by free hand so check for typos.)
    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 
where 
	(SMS_R_System.ResourceId in (select 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID
					from 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64 
					where 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office%2010%" 
						and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version < "14.0.6023") 
	or SMS_R_System.ResourceId in (select 
						SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
					from 
						SMS_G_System_ADD_REMOVE_PROGRAMS 
					where 
						SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office%2010%" 
						and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "14.0.6023"))

	and SMS_R_System.Obsolete = 0 
	and SMS_R_System.Client = 1

    http://www.enhansoft.com/

     
  • mercredi 25 avril 2012 21:22
     
      A du code
    Connectez-vous pour voter
    0

    1. How do you know that you have the Full Office suite?  
    2. You can check both x86 and x64 do it like this: (Note I wrote this query by free hand so check for typos.)
    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 
where 
	(SMS_R_System.ResourceId in (select 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID
					from 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64 
					where 
						SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Microsoft Office%2010%" 
						and SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version < "14.0.6023") 
	or SMS_R_System.ResourceId in (select 
						SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
					from 
						SMS_G_System_ADD_REMOVE_PROGRAMS 
					where 
						SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Office%2010%" 
						and SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "14.0.6023"))

	and SMS_R_System.Obsolete = 0 
	and SMS_R_System.Client = 1

    http://www.enhansoft.com/


    Hi Garth,

    1. I installed it for a few users manually during testing.  So I know if they have 32 or 64-bit office.  
    2.  Would you mind tweaking that query?  I pasted the above into a new query statement and it was missing the add/remove portion.  I'm not creating a SQL report, but trying to get a general SCCM query on the console.  I did a bit of spell checking and that seemed ok.  Sorry to be a pain, but I'd really appreciate it. 
    • Modifié net1994 mercredi 25 avril 2012 21:23
    •  
     
  • jeudi 26 avril 2012 02:20
    Modérateur
     
     
    Connectez-vous pour voter
    0

    So I'm confused.. I cut and pasted the query above into the CM07 console and it works without any issues.  What are you looking to tweak?

    http://www.enhansoft.com/

     
  • jeudi 26 avril 2012 09:41
     
     Traitée
    Connectez-vous pour voter
    0

    Also tested Garth's query, it work fine.

    @net1994, upon query is the WMI query but not the SQL query for reports. What really you want to tweak? This query do meet your needs.

    Thanks

     
  • mercredi 27 février 2013 17:18
     
     
    Connectez-vous pour voter
    0

    Hi Garth,

    I have a Windows 7 x64 with Office 2010 x86 and it doesn't show up when applying your query.

    I've also applied the bult-in query and it happens the same.

    I need to distinguish between Office 2010 x86 and x64 installations.

    Thank you.

     
  • mercredi 27 février 2013 23:46
    Modérateur
     
     
    Connectez-vous pour voter
    0

    That query will find a particularly version of Office 2010, what version of Office 2010 do you have listed within Resource Explorer?

    http://www.enhansoft.com/

     
  • jeudi 28 février 2013 07:13
     
     
    Connectez-vous pour voter
    0

    In this case is Professional Plus, but we need to distinguish between x64 and x86 regardless of Office version.

    We have two testing Windows 7 x64 machines with the exact Office Pro. Plus x86 installed from the same source, one of them shows up with your query and the other one it doesn't.

    I've been looking at the dbo.v_Add_remove_Programs view from SMS_MysiteCode and there's no Office 2010 record for the machine that doesn't show up with your query. May be I'm looking at the wrong view or even it doesn't work that way.

    Thank you.



    • Modifié fedayn1 jeudi 28 février 2013 07:23
    •  
     
  • jeudi 28 février 2013 09:29
     
     
    Connectez-vous pour voter
    0

    Hi Garth,

    I've had to delete de records for that machine via SCCM console and reinstall de agent.

    Now the ifnormation shows up correctly in the SCCM console.

    Thank you.