{"id":1530,"date":"2014-04-28T20:18:18","date_gmt":"2014-04-28T18:18:18","guid":{"rendered":"http:\/\/sccmfaq.wordpress.com\/?p=1530"},"modified":"2014-04-28T20:18:18","modified_gmt":"2014-04-28T18:18:18","slug":"sccm-2012-query-to-determine-outlook-version","status":"publish","type":"post","link":"https:\/\/blog.hosebei.ch\/?p=1530","title":{"rendered":"SCCM 2012 &#8211; Query to determine Outlook Version"},"content":{"rendered":"<p>This is a short one:<br \/>\nIf you would like to know, if there exists machine, with a specific missing Service pack for Office, just use this query:<!--more--><\/p>\n<p><code>select SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion, SMS_G_System_SoftwareFile.FilePath from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = \"outlook.exe\" and SMS_G_System_SoftwareFile.FileVersion &gt; \"15\" and SMS_G_System_SoftwareFile.FileVersion &lt; &quot;15.0.4569.1503&quot; order by SMS_R_System.Name<\/code><br \/>\nThat this query will work, you will need to have the <strong>Software inventory enabled<\/strong>, but mostly you will have it already. This query is to get all Outlook 2013 Installation missing SP1. You can Change the Version numbers as needed, and also the executables Name, if you want to check for Word (WinWord.exe).<br \/>\n<a href=\"http:\/\/hosebei.wordpress.com\/wp-content\/uploads\/2014\/04\/query01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/hosebei.wordpress.com\/wp-content\/uploads\/2014\/04\/query01.png?w=268\" alt=\"query01\" width=\"268\" height=\"300\" class=\"aligncenter size-medium wp-image-1533\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2014\/04\/query01.png 416w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2014\/04\/query01-269x300.png 269w\" sizes=\"auto, (max-width: 268px) 100vw, 268px\" \/><\/a><\/p>\n<p>Hope this helps,<br \/>\nMartin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a short one: If you would like to know, if there exists machine, with a specific missing Service pack for Office, just use this query:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,31,34,35,37],"tags":[],"class_list":["post-1530","post","type-post","status-publish","format-standard","hentry","category-monitoring","category-query","category-sccm-2007","category-sccm-2012","category-software-deployment"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/1530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1530"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/1530\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}