{"id":25298,"date":"2020-08-17T14:44:34","date_gmt":"2020-08-17T14:44:34","guid":{"rendered":"http:\/\/endusersupports.com\/?page_id=25298"},"modified":"2021-07-30T08:12:48","modified_gmt":"2021-07-30T08:12:48","slug":"wql-query","status":"publish","type":"page","link":"https:\/\/endusersupports.com\/index.php\/wql-query\/","title":{"rendered":"WQL Query"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Here is a list of WQL queries to assist with common tasks<\/strong><\/span><\/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

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tWindows Server Build Version - To get details about all Windows server<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select SMS_R_System.Name,<\/p>

SMS_R_System.Client,<\/p>

SMS_R_System.OperatingSystemNameandVersion,<\/p>

SMS_R_System.Build<\/p>

from SMS_R_System where SMS_R_System.Build like “17763.%”<\/p>

or SMS_R_System.OperatingSystemNameandVersion like “%server%”<\/p>

\u00a0<\/p>

Change the Build version (“17763.%”) value to get details about other version.<\/h6>

\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAll Windows 10 Devices - To get details about all Windows 10 machines<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select<\/p>

SMS_R_System.Name,<\/p>

SMS_R_System.Client,<\/p>

SMS_R_System.OperatingSystemNameandVersion<\/p>

from SMS_R_System<\/p>

where SMS_R_System.OperatingSystemNameandVersion like “%Workstation 10.0%”<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tWindow 10 Build version -To get details for Windows 10 built versions.<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

Here is sample query to collect data for Window 20H2,\u00a0<\/p>

\u00a0<\/p>

select SMS_R_System.Name,<\/p>

SMS_R_System.Client,<\/p>

SMS_R_System.OperatingSystemNameandVersion,<\/p>

SMS_R_System.Build<\/p>

from SMS_R_System where SMS_R_System.Build like “10.0.19042.%”<\/p>

or SMS_R_System.OperatingSystemNameandVersion like “%Workstation%”<\/p>

\u00a0<\/p>

\u00a0<\/p>

Change built version \u00a0“10.0.19042.%” <\/strong>to get details about other windows 10\u00a0 version.\u00a0<\/p>

\u00a0<\/p>

Follow the below link to get Windows 10 Built Version Details.<\/p>

https:\/\/docs.microsoft.com\/en-us\/windows\/release-health\/release-information<\/a><\/p>

\u00a0<\/p>

\u00a0<\/p>

\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAll Systems - It will include all Windows and Server machines<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select Name,<\/p>

SMSAssignedSites,<\/p>

OperatingSystemNameandVersion,<\/p>

ResourceDomainORWorkgroup,<\/p>

NetbiosName,<\/p>

ClientType<\/p>

from sms_r_system<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAll Non-Client Systems - To get the details where SCCM client not Installed<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select Name,<\/p>

SMSAssignedSites,<\/p>

OperatingSystemNameandVersion,<\/p>

ResourceDomainORWorkgroup,<\/p>

LastLogonUserDomain,<\/p>

NetbiosName<\/p>

from sms_r_system<\/p>

where Client = 0 or Client is null<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAll System with Client - To get details where SCCM client Installed<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select Name,<\/p>

SMSAssignedSites,<\/p>

OperatingSystemNameandVersion,<\/p>

ResourceDomainORWorkgroup,<\/p>

NetbiosName,<\/p>

ClientType<\/p>

rom sms_r_system<\/p>

where Client = 1<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tAll Windows Servers - To get details about all Windows Servers<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select<\/p>

SMS_R_System.Name,<\/p>

SMS_R_System.Client,<\/p>

SMS_R_System.OperatingSystemNameandVersion<\/p>

from SMS_R_System<\/p>

where SMS_R_System.OperatingSystemNameandVersion like “%server%”<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tInstalled Software Version - Get the machine list with Installed software name and version<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t

select distinct sys.Name,<\/p>

sys.OperatingSystemNameandVersion,<\/p>

sys.ResourceDomainORWorkgroup,<\/p>

sys.LastLogonUserName<\/p>

from SMS_G_System_SoftwareProduct as prod<\/p>

inner join SMS_R_System as sys on sys.ResourceId = prod.ResourceID<\/p>

where prod.ProductName like “%Google Chrome%” and prod.ProductVersion like “%91.0%”<\/p>

\u00a0<\/p>

Note:- Change the Software name and version if you are looking for some specific software or version.<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\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":"

Here is a list of WQL queries to assist with common tasks Windows Server Build Version – To get details about all Windows server select SMS_R_System.Name, SMS_R_System.Client, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.Build from SMS_R_System where SMS_R_System.Build like “17763.%” or SMS_R_System.OperatingSystemNameandVersion like “%server%” \u00a0 Change the Build version (“17763.%”) value to get details about other version. \u00a0 All Windows […]<\/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-25298","page","type-page","status-publish","hentry"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25298","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=25298"}],"version-history":[{"count":267,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25298\/revisions"}],"predecessor-version":[{"id":27554,"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/pages\/25298\/revisions\/27554"}],"wp:attachment":[{"href":"https:\/\/endusersupports.com\/index.php\/wp-json\/wp\/v2\/media?parent=25298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}