Masuk
 
AwalPerpustakaanWikiPelajariUnduhDukunganKomunitasForum
Resources for IT Professionals >
> 
> 
SCCM Query for Exchange 2010 Servers

Respuesta propuesta SCCM Query for Exchange 2010 Servers

  • 14 Juni 2012 9:40
     
     
    Masuk untuk Memilih
    0

    Hi there,

    This may be a simple question, but can anyone provide me with a query that would result in a collection for all Exchange 2010 Servers?

    Thanks

     

Semua Balasan

  • 14 Juni 2012 10:33
     
     Saran Jawaban
    Masuk untuk Memilih
    0

    A basic ARP query should suffice. I don't have Exchange 2012 here to reference.

    I assume all you need is to look for an Add Remove Programs (ARP) entry for the Exchange 2010 installer.

    Something like:

    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 = "<WHATEVER EXCHANGE REPORTS AS IN ARP>"

    • Disarankan sebagai Jawaban oleh absern 26 Maret 2013 8:36
    •  
     
  • 14 Juni 2012 12:52
     
     
    Masuk untuk Memilih
    1

    You can query AddRemovePrograms as suggested (but as Exchange 2010 is 64-bit only then I think you would need to use Add/Remove Programs(64)) and query for systems where the DisplayName equals 'Microsoft Exchange Server 2010'. The one caveat would be that this will also report systems that have the Exchange Management Console installed but are not running any Exchange services (e.g. a Citrix server that used to publish the Exchange Management Console). If this is the case then you could add an additional filter for services that match a particular pattern e.g.

    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_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Microsoft Exchange Server 2010" and SMS_G_System_SERVICE.DisplayName like "Microsoft Exchange%"

     
  • 09 April 2013 22:46
     
     
    Masuk untuk Memilih
    0
    Looking for a query statement to discover exchange server 2013?