What are Queries and What are they based on? A query is a way of getting information from a program (Landesk), usually a database (where Landesk information is stored). A query is a question that filters the information you tell it and displays the results of this filtered information. Most queries in Landesk use “logical” or “mathematical” connectors (“like”, “not like”, =, >) to get the data you want. In most cases, the information you want will be related to your computers. However, you can get information about a) the software on a machine, b) the software used at your school, c) your users, and d) Active Directory. You set up the question using the “fields” Landesk has set up when it first inventories your machine. To see the fields you can “query”, pick a machine in Landesk & double click on it. You will see lots of information about the machine. If you click on the word System 1. Open up your Landesk console. 2. Make sure you are in Network View 3. Locate the Queries section. Notice the “My queries” folder just below the Queries section. 4. Right mouse click on My Queries 5. Select New Query. 6. The NewQuery window opens up. Landesk presents you with a lot of fields and sub-fields (on the left) that you can use in a query. 7. Type in a descriptive name for the query. Start it with your school number. Example: 5011 Lenovo Computers Notice the word “Computer” There are lots of “things” (fields) listed under Computer. Each of these fields contain data about your computer. You can create queries to group computers that have the same data (or lack of data). 8. Scroll down to “System” and click on the + (plus) to expand the options under System We choose System under Computer because we want the field that contains the Manufacturer of the “computer” “system” 9. Click on the word “Manufacturer” Notice that Landesk has started to build a “question” (query) in a language it understands. Notice that it uses the fields we selected. 10. Click on the word “Like” in the middle column Notice that the word “Like” is added to the query below 11. If you have a check in the “Display scanned values” box, a list of choices gathered from all of your school’s machines will appear in the far right column. 12. Double-click on “LENOVO” to select it and add it down below. You could also type in the word Lenovo in the “Edit Values” box in the right column 13. Click on the INSERT button to insert your query into the query box below. Notice the equation is now complete and makes sense. 14. Click the SAVE button to save your query. 15. The saved query appears under the My queries section. 16. Double-click on it to run the query. The results of the query appear. In the lower left corner of your console, you will see how many items met your query.
Pages to are hidden for
"Landesk Creating Queries"Please download to view full document