System Center Configuration Manager 2012 - Requete de recherche d'un programme 64 et 32 bits
Par Romain Tiennot le vendredi 5 octobre 2012, 09:00 - Serveur - Lien permanent
Cette requete permet de rechercher un programme dans l'ajout et suppression des programmes aussi bien 32 que 64 bit. J'ai pris l'exemple d'Adobe Flash :
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 "%Adobe Flash%") or 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 "%Adobe Flash%")
A bientôt,
Romain
Il y a 2 commentaires
Means of life is very principal when you decide fashionable or pleasing dresses for thyself. His debut album, No Way Done was a #1 album and won the 1998 Grammy Award for really rap album.
These some of the frequently asked any questions for android software development services when outsourced from In india companies. Need to the most desirable mobile phone patterns nowadays is the iPhone 3G. http://www.moviesafar.com/z4root.ht... z4root