Microsoft Query Mac
The following list details which versions of Excel include the Get & Transform (Power Query) experience. Excel 2019 and Excel 2016 for Windows. The Get & Transform (Power Query) experience is available in all Excel 2019 and 2016 for Windows plans on the Data tab under the Get & Transform section. The following table shows basic and advanced. Using Microsoft Query, you can join these tables so that all the customer records are retrieved, along with sales data for those customers who have made purchases. To start Microsoft Query, perform the following steps. On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query.
-->Applies to: Configuration Manager (current branch)
This article describes how to create and import queries in Configuration Manager.
Create a query
Use this procedure to create a query in Configuration Manager.
In the Configuration Manager console, select Monitoring.
In the Monitoring workspace, select Queries. On the Home tab, in the Create group, select Create Query.
On the General tab of the Create Query Wizard, specify a unique name and, optionally, a comment for the query.
If you want to import an existing query to use as a basis for the new query, select Import Query Statement. In the Browse Query dialog box, select a query that you want to import, and then select OK.
In the Object Type list, select the type of object that you want the query to return. This table describes some examples of the types of objects you can search for:
Object type Description System Resource Use to search for typical system attributes, like the NetBIOS name of a device, the client version, the client IP address, and Active Directory Domain Services information. User Resource Use to search for typical user information, like user names, user group names, and security group names. Deployment Use to search for typical attributes of a deployment, like the deployment name, the schedule, and the collection that it was deployed to. Select Edit Query Statement to open the <Query Name> Statement Properties dialog box.
On the General tab of the <Query Name> Statement Properties dialog box, specify the attributes that the query returns and how they should be displayed. Select the New icon to add a new attribute. You can also select Show Query Language to enter or edit the query directly in WMI Query Language (WQL). For examples of WMI queries, see the Example WQL queries section in this article.
Tip
You can use the following reference documentation to help you construct your own WQL queries:
On the Criteria tab of the <Query Name> Statement Properties dialog box, specify criteria that are used to refine the results of the query. For example, you could return only resources that have a site code of XYZ. You can configure multiple criteria for a query.
Important
If you create a query that contains no criteria, the query will return all devices in the All Systems collection.
On the Joins tab of the <Query Name> Statement Properties dialog box, you can combine data from two different attributes into your query results. Although Configuration Manager automatically creates query joins when you choose different attributes for your query result, the Joins tab provides more advanced options. Configuration Manager supports these attribute classes:
Join type Description Inner Displays only matching results. Always used by joins that are created automatically. Left Displays all results for the base attribute and only the matching results for the join attribute. Right Displays all results for the join attribute and only the matching results for the base attribute. Full Displays all results for both the base attribute and the join attribute. For more information about how to use join operations, see the SQL Server documentation.
Select OK to close the <Query Name> Statement Properties dialog box.
On the General tab of the Create Query Wizard, specify that the results of the query aren't limited to the members of a collection, that they are limited to the members of a specified collection, or that a prompt for a collection appears each time the query is run.
Complete the wizard to create the query. The new query appears in the Queries node in the Monitoring workspace.
Import a query
Use this procedure to import a query into Configuration Manager. For information about how to export queries, see How to manage queries.
In the Configuration Manager console, select Monitoring.
In the Monitoring workspace, select Queries. On the Home tab, in the Create group, select Import Objects.
On the MOF File Name page of the Import Objects Wizard, select Browse to select the Managed Object Format (MOF) file that contains the query that you want to import.
Review the information about the query to be imported and then complete the wizard. The new query appears on the Queries node in the Monitoring workspace.
Example WQL queries
This section contains example WQL queries that you can use in your hierarchy or modify for other purposes. To use these queries, select Show Query Language in the Query Statement Properties dialog box. Then copy and paste the query into the Query Statement field.
Tip
Use the wildcard character %
to signify any string of characters. For example, %Visio%
returns Microsoft Office Visio 2010.
Computers that run Windows 10
Use the following query to return the NetBIOS name and operating system version of all computers that run Windows 7.
Computers with a specific software package installed
Use the following query to return the NetBIOS name and software package name of all computers that have a specific software package installed. This example returns all computers with a version of Microsoft Visio installed. Replace Microsoft%Visio%
with the software package that you want to query for.
Microsoft Query Mac Address
Tip
This query searches for the software package by using the names that are displayed in the programs list in Windows Control Panel.
Computers in a specific Active Directory Domain Services organizational unit
Use the following query to return the NetBIOS name and organizational unit (OU) name of all computers in a specified OU. Replace the text OU Name
with the name of the OU that you want to query for.
Computers with a specific NetBIOS name
Use the following query to return the NetBIOS name of all computers that begin with a specific string of characters. In this example, the query returns all computers with a NetBIOS name that begins with ABC
.
Devices of a specific type
Device types are stored in the Configuration Manager database under the resource class sms_r_system and the attribute name AgentEdition. Use this query to retrieve only the devices that match the agent edition of the device type that you specify:
Use one of these values for <Device ID>:
Device type | Value of AgentEdition |
---|---|
Windows desktop or laptop computer | 0 |
Windows ARM-based device (running Windows RT) | 1 |
Windows Mobile 6.5 | 2 |
Nokia Symbian | 3 |
Windows Phone | 4 |
Mac computer | 5 |
Windows CE | 6 |
Windows Embedded | 7 |
Intel system on a chip | 12 |
Unix and Linux servers | 13 |
Microsoft HoloLens (MDM) | 15 |
Microsoft Surface Hub (MDM) | 16 |
Note
Values that aren't listed in this table are associated with devices that are no longer supported.
For example, if you want to return only Mac computers, use this query:
Next steps
-->This quickstart shows how to use Azure Data Studio to connect to SQL Server, and then use Transact-SQL (T-SQL) statements to create the TutorialDB used in Azure Data Studio tutorials.
Dec 29, 2015 It's weird that I cannot use the services 'convert Text from Simplified to Traditional Chinese' in word for Mac 2011 on Mac OS 10.8.2, but this service can be used in all Mac applications such as textedit and pages. This service works fine in OS 10.7.5. Type traditional chinese. Dec 29, 2015 Convert Text from Simplified to Traditional Chinese I have three Macs, one with Lion and 2 with Mountain Lion (10.8.2) It's weird that I cannot use the services 'convert Text from Simplified to Traditional Chinese' in word for Mac 2011 on Mac OS 10.8.2, but this service can be used in all Mac applications such as textedit and pages.
Prerequisites
To complete this quickstart, you need Azure Data Studio, and access to SQL Server.
- Install Azure Data Studio.
If you don't have access to a SQL Server, select your platform from the following links (make sure you remember your SQL Login and Password!):
- Linux - Download SQL Server 2017 Developer Edition - You only need to follow the steps up to Create and Query Data.
Connect to a SQL Server
Start Azure Data Studio.
The first time you run Azure Data Studio the Welcome page should open. If you don't see the Welcome page, select Help > Welcome. Select New Connection to open the Connection pane:
This article uses SQL Login, but Windows Authentication is supported. Fill in the fields as follows:
Server Name: Enter server name here. For example, localhost.
Authentication Type: SQL Login
User name: User name for the SQL Server
Password: Password for the SQL Server
Database Name: <Default>
Server Group: <Default>
Create a database
The following steps create a database named TutorialDB:
Right-click on your server, localhost, and select New Query.
Paste the following snippet into the query window: and then select Run.
After the query completes, the new TutorialDB appears in the list of databases. If you don't see it, right-click the Databases node and select Refresh.
Create a table
The query editor is still connected to the master database, but we want to create a table in the TutorialDB database.
Change the connection context to TutorialDB:
Paste the following snippet into the query window and click Run:
Note
You can append this too, or overwrite the previous query in the editor. Note that clicking Run executes only the query that is selected. If nothing is selected, clicking Run executes all queries in the editor.
After the query completes, the new Customers table appears in the list of tables. You might need to right-click the TutorialDB > Tables node and select Refresh.
Insert rows
- Paste the following snippet into the query window and click Run:
View the data returned by a query
- Paste the following snippet into the query window and click Run:
Next steps
Microsoft Query Commands
Now that you've successfully connected to SQL Server and run a query try out the Code editor tutorial.