{"id":815,"date":"2012-10-11T10:09:58","date_gmt":"2012-10-11T07:09:58","guid":{"rendered":"http:\/\/www.hakancakiroglu.com\/wordpress\/?p=815"},"modified":"2012-10-11T15:19:18","modified_gmt":"2012-10-11T12:19:18","slug":"sccm-wmi-query-ile-herhangi-bir-programin-yuklu-olup-olmadiginin-kontrolu","status":"publish","type":"post","link":"https:\/\/www.hakancakiroglu.com\/wordpress\/?p=815","title":{"rendered":"SCCM &#8211; WMI Query ile Herhangi Bir Program\u0131n Y\u00fckl\u00fc Olup Olmad\u0131\u011f\u0131n\u0131n Kontrol\u00fc"},"content":{"rendered":"<p>SCCM \u00fczerinde WMI dilini kullanarak olu\u015fturdu\u011funuz sorgular ile domain ortam\u0131n\u0131zdaki SCCM agent y\u00fckl\u00fc olan makinalar \u00fczerinde hangi program\u0131n hangi makinalar \u00fczerinde kurulu olup hangilerinde kurulu olmad\u0131g\u0131n\u0131 kolayca tespit edebilirsiniz.\u00a0 Arad\u0131\u011f\u0131n\u0131z program\u0131 y\u00fckl\u00fc olan makinalar\u0131 tespit ettikten\u00a0 sonra y\u00fckl\u00fc olmad\u0131klar\u0131 maknailar\u0131 bulmak \u00e7ok da zor olmayacakt\u0131r.<!--more--><\/p>\n<p>\u00d6rne\u011fin Microsoft Lync 2010 y\u00fcklenmi\u015f makinalar\u0131 tespit edebilmek i\u00e7in a\u015fa\u011f\u0131daki sorguyu \u00e7al\u0131\u015ft\u0131rmak yeterli olacakt\u0131r.<\/p>\n<p>\u00d6ncelikle <strong>Computer Management -&gt; Queries alan\u0131na sa\u011f t\u0131klan\u0131r ve New -&gt; Query<\/strong> se\u00e7ene\u011fi se\u00e7ilir.<\/p>\n<p><a href=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm1.png\"><img loading=\"lazy\" class=\"size-medium wp-image-824 alignleft\" title=\"sccm1\" src=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm1-170x300.png\" alt=\"\" width=\"170\" height=\"300\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: left;\">Daha sonra bu sorguya bir isim verilerek <strong>Edit Query Statement<\/strong> se\u00e7ene\u011fi se\u00e7ilir<\/p>\n<p><a href=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm2.png\"><img loading=\"lazy\" class=\"size-medium wp-image-826 alignleft\" title=\"sccm2\" src=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm2-300x227.png\" alt=\"\" width=\"300\" height=\"227\" srcset=\"https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm2-300x227.png 300w, https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm2.png 704w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Ard\u0131ndan <strong>Show Query Language<\/strong> se\u00e7ene\u011fi se\u00e7ilir<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm31.png\"><img loading=\"lazy\" class=\"size-medium wp-image-837 alignleft\" title=\"sccm3\" src=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm31-266x300.png\" alt=\"\" width=\"266\" height=\"300\" srcset=\"https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm31-266x300.png 266w, https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm31.png 409w\" sizes=\"(max-width: 266px) 100vw, 266px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm2.png\"><br \/>\n<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Ve son olaraka\u00e7\u0131lan pencereye sorgu c\u00fcmleci\u011fimiz yaz\u0131l\u0131r.<\/p>\n<p><a href=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm4.png\"><img loading=\"lazy\" class=\"size-medium wp-image-829 alignleft\" title=\"sccm4\" src=\"http:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm4-271x300.png\" alt=\"\" width=\"271\" height=\"300\" srcset=\"https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm4-271x300.png 271w, https:\/\/www.hakancakiroglu.com\/wordpress\/wp-content\/uploads\/2012\/10\/sccm4.png 408w\" sizes=\"(max-width: 271px) 100vw, 271px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3>\u00a0 Microsoft Lync 2010 Program\u0131n\u0131n Y\u00fckl\u00fc Oldugu Makinalar\u0131 G\u00f6steren Sorgu<\/h3>\n<p>A\u015fa\u011f\u0131daki sorgu yard\u0131m\u0131yla hem 32bit hem de 64 bit Windows i\u015fletim sistemi yuklu olan t\u00fcm makinalarda (Yani Wnidows Xp-Vista-7 Windows Server 2003-2008 vs.) &#8220;Microsoft Lync 2010&#8221; y\u00fcklenmi\u015f makinalar\u0131n listesini g\u00f6rebilirsiniz.\u00a0 E\u011fer ba\u015fka bir program\u0131n y\u00fckl\u00fc olup olmad\u0131g\u0131n\u0131 kontrol etmek isterseniz sorgu i\u00e7erisinde t\u0131rnaklar i\u00e7erisinde yaz\u0131l\u0131 olan <strong>Microsoft Lync 2010<\/strong> de\u011ferini, kontrol etmek istedi\u011finiz program\u0131n Program Ekle kald\u0131r alan\u0131nda g\u00f6r\u00fcnen ad\u0131 ile de\u011fi\u015ftirmeniz yeterli olacakt\u0131r.<\/p>\n<h3>\u00a0<strong>Sorgu<\/strong><\/h3>\n<pre>select SMS_R_System.NetbiosName from\u00a0 SMS_R_System where SMS_R_System.ResourceId \r\nin (select SMS_R_System.ResourceID\u00a0 from\u00a0 SMS_R_System inner join\r\nSMS_G_System_ADD_REMOVE_PROGRAMS on \r\nSMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId \r\nwhere SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = \"Microsoft Lync 2010\") \r\nor SMS_R_System.ResourceId in \r\n(select SMS_R_System.ResourceID from\u00a0 SMS_R_System \r\ninner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on \r\nSMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId \r\nwhere\u00a0 SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = \"Microsoft Lync 2010\") \r\norder by SMS_R_System.NetbiosName<\/pre>\n<h3>Microsoft Lync 2010 Program\u0131n\u0131n Y\u00fckl\u00fc Olmad\u0131\u011f\u0131 Makinalar\u0131 G\u00f6steren Sorgu<\/h3>\n<p>Ayn\u0131 \u015fekilde yukar\u0131da yazd\u0131g\u0131m\u0131z sorguda olmayan makinalar\u0131 listeleterek y\u00fckl\u00fc olmayan makinalar\u0131 da g\u00f6sterebiliriz. Bunun i\u00e7in yukar\u0131daki sorgudan yararlanarak a\u015fa\u011f\u0131daki sorguyu olu\u015fturuyoruz. Microsoft Lync 2010 y\u00fckl\u00fc olmayan makinalar\u0131 tespit edebilmek i\u00e7in yukar\u0131da anlat\u0131ld\u0131\u011f\u0131 gibi yeni bir sorgu olu\u015ftrarak sorgu alan\u0131na a\u015fag\u0131daki sorguyu yazman\u0131z yeterli olacakt\u0131r.<\/p>\n<pre>select distinct SMS_R_System.NetbiosName from SMS_R_System where \r\nSMS_R_System.ResourceId not in \r\n(select distinct SMS_R_System.ResourceID from\u00a0 SMS_R_System \r\ninner join SMS_G_System_ADD_REMOVE_PROGRAMS \r\non SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId \r\nwhere SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = \"Microsoft Lync 2010\" ) \r\nand SMS_R_System.ResourceId not in \r\n(select distinct SMS_R_System.ResourceID from\u00a0 SMS_R_System \r\ninner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 \r\non SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId \r\nwhere SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = \"Microsoft Lync 2010\" )<\/pre>\n<p>Evet bu sorgular\u0131 kaydederek Queries ekran\u0131nda olu\u015fturdugunuz sorgunun \u00fczerine gelerek sonu\u00e7lar\u0131 g\u00f6rebilirsiniz.<\/p>\n<p>Umar\u0131m faydal\u0131 bir payla\u015f\u0131m olmu\u015ftur, yeni bir yaz\u0131da g\u00f6r\u00fc\u015fmek dile\u011fiyle&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Kaynaklar :<\/p>\n<p>http:\/\/blog.coretech.dk\/kea\/query-to-find-computers-without-net-framework-35-sp1-installed\/<\/p>\n<p>http:\/\/social.technet.microsoft.com\/Forums\/en-US\/configmgradminconsole\/thread\/1d2e6fa8-d98b-4dd8-8529-c2748b5722a5\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SCCM \u00fczerinde WMI dilini kullanarak olu\u015fturdu\u011funuz sorgular ile domain ortam\u0131n\u0131zdaki SCCM agent y\u00fckl\u00fc olan makinalar \u00fczerinde hangi program\u0131n hangi makinalar \u00fczerinde kurulu olup hangilerinde kurulu olmad\u0131g\u0131n\u0131 kolayca tespit edebilirsiniz.\u00a0 Arad\u0131\u011f\u0131n\u0131z program\u0131 y\u00fckl\u00fc olan makinalar\u0131 tespit ettikten\u00a0 sonra y\u00fckl\u00fc olmad\u0131klar\u0131 maknailar\u0131 bulmak \u00e7ok da zor olmayacakt\u0131r.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[],"_links":{"self":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/815"}],"collection":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=815"}],"version-history":[{"count":28,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/815\/revisions"}],"predecessor-version":[{"id":856,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/815\/revisions\/856"}],"wp:attachment":[{"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hakancakiroglu.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}