none
How to create Collection for Spcefic Windows Service not avilble systems

Respuestas

  • select *  from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = "ServiceName")

    Torsten Meringer | http://www.mssccmfaq.de

    lunes, 18 de junio de 2012 10:05
  • Hi,

    that should work. You just have to change the service name.

    select distinct SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System where SMS_R_System.Obsolete = 0 and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = "You Service Display Name")

    cheers

    lunes, 18 de junio de 2012 10:08

Todas las respuestas

  • select *  from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = "ServiceName")

    Torsten Meringer | http://www.mssccmfaq.de

    lunes, 18 de junio de 2012 10:05
  • Hi,

    that should work. You just have to change the service name.

    select distinct SMS_R_System.Name, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.OperatingSystemNameandVersion from  SMS_R_System where SMS_R_System.Obsolete = 0 and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName = "You Service Display Name")

    cheers

    lunes, 18 de junio de 2012 10:08