{"id":25321,"date":"2020-08-17T15:08:21","date_gmt":"2020-08-17T15:08:21","guid":{"rendered":"http:\/\/endusersupports.com\/?page_id=25321"},"modified":"2021-08-10T20:22:28","modified_gmt":"2021-08-10T20:22:28","slug":"sccm-query","status":"publish","type":"page","link":"https:\/\/endusersupports.com\/index.php\/sccm-query\/","title":{"rendered":"SCCM Query"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"25321\" class=\"elementor elementor-25321\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5baec98 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5baec98\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1d6fbec\" data-id=\"1d6fbec\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-78859e7 elementor-widget elementor-widget-text-editor\" data-id=\"78859e7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Follow the Below Steps to run the SQL Query.<\/h3>\n<p>\u00a0<\/p>\n<ol>\n<li>Search \u201cMicrosoft SQL Server Management Studio\u201d from Start button.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-814c49c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"814c49c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-11346fd\" data-id=\"11346fd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f906f4d elementor-widget elementor-widget-image\" data-id=\"f906f4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"509\" height=\"154\" src=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/1.png\" class=\"attachment-medium_large size-medium_large wp-image-26689\" alt=\"\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/1.png 509w, https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/1-300x91.png 300w\" sizes=\"(max-width: 509px) 100vw, 509px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4f948d4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f948d4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-205773f\" data-id=\"205773f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1415b0f elementor-widget elementor-widget-text-editor\" data-id=\"1415b0f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>2. Click On Connect button.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a69d532 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a69d532\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f5b48c8\" data-id=\"f5b48c8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cd4c5b3 elementor-widget elementor-widget-image\" data-id=\"cd4c5b3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"597\" height=\"214\" src=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/2-2.png\" class=\"attachment-medium_large size-medium_large wp-image-26692\" alt=\"\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/2-2.png 597w, https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/2-2-300x108.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3af4380 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3af4380\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-506cfbd\" data-id=\"506cfbd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4076285 elementor-widget elementor-widget-text-editor\" data-id=\"4076285\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>3. Change the Database name from Drop Down button.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-34d1c0f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"34d1c0f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d73bd99\" data-id=\"d73bd99\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-da3d387 elementor-widget elementor-widget-image\" data-id=\"da3d387\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"602\" height=\"279\" src=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/3.png\" class=\"attachment-medium_large size-medium_large wp-image-26694\" alt=\"\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/3.png 602w, https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/3-300x139.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64cb8ce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64cb8ce\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-73d3d19\" data-id=\"73d3d19\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8012a52 elementor-widget elementor-widget-text-editor\" data-id=\"8012a52\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>4. Past here your SQL query like below. And click on Execute button.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cb0c1c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cb0c1c7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-df7e452\" data-id=\"df7e452\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-79f106d elementor-widget elementor-widget-image\" data-id=\"79f106d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"279\" src=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/4-1.png\" class=\"attachment-medium_large size-medium_large wp-image-26695\" alt=\"\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/4-1.png 602w, https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/4-1-300x139.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f60f001 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f60f001\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6e98e52\" data-id=\"6e98e52\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-525a6d9 elementor-widget elementor-widget-text-editor\" data-id=\"525a6d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>5. Below is the output for the query.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-677de8b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"677de8b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3307720\" data-id=\"3307720\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8d096fb elementor-widget elementor-widget-image\" data-id=\"8d096fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"391\" src=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/5.png\" class=\"attachment-medium_large size-medium_large wp-image-26696\" alt=\"\" srcset=\"https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/5.png 602w, https:\/\/endusersupports.com\/wp-content\/uploads\/2021\/06\/5-300x195.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Follow the Below Steps to run the SQL Query. \u00a0 Search \u201cMicrosoft SQL Server Management Studio\u201d from Start button. 2. Click On Connect button. 3. Change the Database name from Drop Down button. 4. Past here your SQL query like below. And click on Execute button. 5. Below is the output for the query.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-25321","page","type-page","status-publish","hentry"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/comments?post=25321"}],"version-history":[{"count":41,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25321\/revisions"}],"predecessor-version":[{"id":27826,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25321\/revisions\/27826"}],"wp:attachment":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/media?parent=25321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}