Learn how to read SQL reports in SCCM. Find out how to read the important parts of any query.
- [Instructor] Another aspect of reporting…is the data query.…You can create and run queries to locate objects…in a Microsoft System Center Configuration Manager site…that match your query criteria.…These objects include items such as specific types…of computers or user groups.…We're in the monitoring section as you can see…in the lower left side…and we're gonna click on Queries.…And we see a list of canned queries that have come up.…Let's go ahead and start by choosing one of these queries…and for instance this particular one…says This Site and its Subsites.…
So if we right click on that and we choose Run…and we should see a report of all…of the different information in our site.…And there it is.…We just have the one site and it's SCCM-1…and it's on our SCCM server.…Let's go ahead and choose another one.…Let's click on Queries and this time we'll choose…Systems by Last Logged on User.…Right click and choose Run and it's going to prompt us…for the user we would like to check.…
Let's go ahead and choose administrator…
Author
Robert McMillen
Released
9/5/2018Note: Existing knowledge of Windows Servers and basic networking is recommended prior to watching this course.
- Creating device and user collections
- Configuring maintenance windows
- Configuring resource discovery
- Distributing content
- Creating queries and reports
- Deploying operating systems
- Maintaining the management infrastructure
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome49s
-
-
1. Configure the Management Infrastructure to Support Clients and Devices
-
SCCM network setup1m 53s
-
Create a device collection5m 11s
-
Create a user collection4m 18s
-
-
2. Configure the Management Infrastructure to Distribute Content
-
Manage content distribution7m 11s
-
3. Configure the Management Infrastructure to Use Queries and Reports
-
Create data queries3m 23s
-
4. Configure the Management Infrastructure to Deploy Operating Systems
-
5. Maintain the Management Infrastructure
-
Conclusion
-
Next steps42s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create data queries