{"id":33,"date":"2021-08-19T09:03:00","date_gmt":"2021-08-19T09:03:00","guid":{"rendered":"https:\/\/itguru.ldoerr.eu\/?p=33"},"modified":"2021-08-23T12:22:21","modified_gmt":"2021-08-23T12:22:21","slug":"sccm-device-collection-query-for-active-clients","status":"publish","type":"post","link":"https:\/\/blog.it-guru.at\/?p=33","title":{"rendered":"SCCM: Device-Collection Query for active Clients"},"content":{"rendered":"\n<p>Um in Microsoft SCCM eine dynamische Device Collection mit aktiven Clients einer vordefinierten Zeitspanne anzulegen, kann der folgende WQL Code verwendet werden.<\/p>\n\n\n\n<p>In diesem Fall wird die Collection f\u00fcr die letzten 2 Tage (48 Stunden) erstellt und dynamisch angepasst.<\/p>\n\n\n\n<p><pre style=\"overflow-x:scroll\">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 DATEDIFF(dd,SMS_R_System.LastLogonTimestamp,GetDate()) &lt; 2<\/pre><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"514\" height=\"538\" src=\"https:\/\/itguru.ldoerr.eu\/wp-content\/uploads\/2021\/08\/Eingefu\u0308gtes_Bild_20_08_21__10_17-1.jpg\" alt=\"\" class=\"wp-image-244\" srcset=\"https:\/\/blog.it-guru.at\/wp-content\/uploads\/2021\/08\/Eingefu\u0308gtes_Bild_20_08_21__10_17-1.jpg 514w, https:\/\/blog.it-guru.at\/wp-content\/uploads\/2021\/08\/Eingefu\u0308gtes_Bild_20_08_21__10_17-1-287x300.jpg 287w\" sizes=\"(max-width: 514px) 100vw, 514px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Um in Microsoft SCCM eine dynamische Device Collection mit aktiven Clients einer vordefinierten Zeitspanne anzulegen, kann der folgende WQL Code verwendet werden.<\/p>\n","protected":false},"author":2,"featured_media":37,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/posts\/33"}],"collection":[{"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=33"}],"version-history":[{"count":14,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/posts\/33\/revisions\/290"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=\/wp\/v2\/media\/37"}],"wp:attachment":[{"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=33"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=33"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.it-guru.at\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=33"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}