{"id":1521,"date":"2015-11-27T09:49:50","date_gmt":"2015-11-27T08:49:50","guid":{"rendered":"http:\/\/lestfrexgn.cluster020.hosting.ovh.net\/?p=1521"},"modified":"2015-11-27T09:49:50","modified_gmt":"2015-11-27T08:49:50","slug":"sccm-2012-requete-wql-avec-prompt","status":"publish","type":"post","link":"https:\/\/les2t.fr\/fr_fr\/sccm-2012-requete-wql-avec-prompt\/","title":{"rendered":"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt"},"content":{"rendered":"

\"sccm2012\"<\/a>
\nJe reprends ici, un billet de Jones GARTH qui a fait un tuto sur les requ\u00eates dans SCCM 2012 avec Prompt. M\u00eame si la cr\u00e9ation est similaire \u00e0 la cr\u00e9ation d\u2019une requ\u00eate standard, certaines particularit\u00e9s permettront son fonctionnement.<\/p>\n


\nLe tuto suivant est fait pour SCCM 2012 mais il est r\u00e9alisable sur des versions 2007 ou V-Next.
\n\"Create-a-Prompted-Query-Step-1_thumb\"<\/a>
\nOuvrez la console ConfigMgr et allez dans Monitoring\\Queries et cliquez sur Create Query.
\n\"Create-a-Prompted-Query-Step-2_thumb\"<\/a>
\nDonnez un nom \u00e0 votre requ\u00eate et cliquez sur Edit Query Statement
\n\"Create-a-Prompted-Query-Step-3_thumb\"<\/a>
\nS\u00e9lectionnez les colonnes \u00e0 afficher puis allez dans l\u2019onglet Criteria
\n\"Create-a-Prompted-Query-Step-4_thumb\"<\/a>
\nCliquez sur le bouton en forme d\u2019\u00e9toile jaune.
\n\"Create-a-Prompted-Query-Step-5_thumb\"<\/a>
\n\"Create-a-Prompted-Query-Prompted-Value_thumb\"<\/a>
\nModifiez le type de crit\u00e8re en Prompted value (choix dans la liste d\u00e9roulante)
\nTerminez ensuite la cr\u00e9ation de votre requ\u00eate comme \u00e0 votre habitude.
\nLorsque vous avez termin\u00e9 v\u00e9rifiez que le crit\u00e8re avec prompt ressemble \u00e0 celui-ci :
\n\"Create-a-Prompted-Query-Step-6_thumb\"<\/a>
\nVoici un exemple de requ\u00eate termin\u00e9e.
\nselect
\nSMS_R_System.NetbiosName,
\nSMS_R_System.LastLogonUserName,
\nSMS_R_System.OperatingSystemNameandVersion
\nfrom
\nSMS_R_System
\nwhere
\nSMS_R_System.OperatingSystemNameandVersion like #PRM:SMS_R_System.OperatingSystemNameandVersion##<\/p>\n

\"Create-a-Prompted-Query-Step-7_thumb\"<\/a>
\nLorsque vous ex\u00e9cutez la requ\u00eate, vous serez invit\u00e9 \u00e0 saisir une valeur.
\nVous pouvez utilis\u00e9 les signe % pour \u00e9tendre votre recherche.
\n\"Create-a-Prompted-Query-Step-8_thumb\"<\/a>
\nVous devrez avoir un r\u00e9sultat ressemblant \u00e0 \u00e7a.<\/p>\n

Original : ICI<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Je reprends ici, un billet de Jones GARTH qui a fait un tuto sur les requ\u00eates dans SCCM 2012 avec Prompt. M\u00eame si la cr\u00e9ation est similaire \u00e0 la cr\u00e9ation d\u2019une requ\u00eate standard, certaines particularit\u00e9s permettront son fonctionnement.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8,7,88],"tags":[15,14,36,190,188,165,164,172,22,189],"class_list":["post-1521","post","type-post","status-publish","format-standard","hentry","category-sccm-2007","category-sccm-2012","category-sccm-vnext","tag-configmgr-2007","tag-configmgr-2012","tag-microsoft","tag-prompt","tag-requete","tag-sccm-2007","tag-sccm-2012","tag-system-center","tag-system-center-configuration-manager","tag-wql"],"yoast_head":"\nSCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/les2t.fr\/fr_fr\/sccm-2012-requete-wql-avec-prompt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T\" \/>\n<meta property=\"og:description\" content=\"Je reprends ici, un billet de Jones GARTH qui a fait un tuto sur les requ\u00eates dans SCCM 2012 avec Prompt. M\u00eame si la cr\u00e9ation est similaire \u00e0 la cr\u00e9ation d\u2019une requ\u00eate standard, certaines particularit\u00e9s permettront son fonctionnement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/les2t.fr\/fr_fr\/sccm-2012-requete-wql-avec-prompt\/\" \/>\n<meta property=\"og:site_name\" content=\"Les2T\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-27T08:49:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg\" \/>\n<meta name=\"author\" content=\"TRARBACH Jean-Yves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"TRARBACH Jean-Yves\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/\",\"url\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/\",\"name\":\"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T\",\"isPartOf\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg\",\"datePublished\":\"2015-11-27T08:49:50+00:00\",\"author\":{\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\"},\"breadcrumb\":{\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/les2t.fr\/fr_fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#website\",\"url\":\"https:\/\/les2t.fr\/fr_fr\/\",\"name\":\"Les2T\",\"description\":\"| BLOG IT |\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e\",\"name\":\"TRARBACH Jean-Yves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"contentUrl\":\"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg\",\"caption\":\"TRARBACH Jean-Yves\"},\"description\":\"Head Of Modern Workplace Metsys MVP Windows & devices For IT\",\"sameAs\":[\"https:\/\/les2t.fr\/jean-yves-trarbach\/\"],\"url\":\"https:\/\/les2t.fr\/fr_fr\/author\/kounac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/les2t.fr\/fr_fr\/sccm-2012-requete-wql-avec-prompt\/","og_locale":"fr_FR","og_type":"article","og_title":"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T","og_description":"Je reprends ici, un billet de Jones GARTH qui a fait un tuto sur les requ\u00eates dans SCCM 2012 avec Prompt. M\u00eame si la cr\u00e9ation est similaire \u00e0 la cr\u00e9ation d\u2019une requ\u00eate standard, certaines particularit\u00e9s permettront son fonctionnement.","og_url":"https:\/\/les2t.fr\/fr_fr\/sccm-2012-requete-wql-avec-prompt\/","og_site_name":"Les2T","article_published_time":"2015-11-27T08:49:50+00:00","og_image":[{"url":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg","type":"","width":"","height":""}],"author":"TRARBACH Jean-Yves","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"TRARBACH Jean-Yves","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/","url":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/","name":"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt - Les2T","isPartOf":{"@id":"https:\/\/les2t.fr\/fr_fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage"},"image":{"@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage"},"thumbnailUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg","datePublished":"2015-11-27T08:49:50+00:00","author":{"@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e"},"breadcrumb":{"@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#primaryimage","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2014\/09\/sccm2012-300x159.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/les2t.fr\/sccm-2012-requete-wql-avec-prompt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/les2t.fr\/fr_fr\/"},{"@type":"ListItem","position":2,"name":"SCCM 2012 \u2013 Requ\u00eate WQL avec prompt"}]},{"@type":"WebSite","@id":"https:\/\/les2t.fr\/fr_fr\/#website","url":"https:\/\/les2t.fr\/fr_fr\/","name":"Les2T","description":"| BLOG IT |","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/les2t.fr\/fr_fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/d96bb4f512f9aeb12dc923def245768e","name":"TRARBACH Jean-Yves","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/les2t.fr\/fr_fr\/#\/schema\/person\/image\/","url":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","contentUrl":"https:\/\/les2t.fr\/wp-content\/uploads\/2023\/02\/JeanYvestrarbach-96x96.jpg","caption":"TRARBACH Jean-Yves"},"description":"Head Of Modern Workplace Metsys MVP Windows & devices For IT","sameAs":["https:\/\/les2t.fr\/jean-yves-trarbach\/"],"url":"https:\/\/les2t.fr\/fr_fr\/author\/kounac\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts\/1521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/comments?post=1521"}],"version-history":[{"count":0,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/posts\/1521\/revisions"}],"wp:attachment":[{"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/media?parent=1521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/categories?post=1521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/les2t.fr\/fr_fr\/wp-json\/wp\/v2\/tags?post=1521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}