Learn how to create a report in SQL using SCCM.
- [Instructor] We are in our system center…configuration manager console.…Although we see the reporting option…there's nothing to report…because we don't yet have the proper role installed.…Let's take a quick look at reporting…in Sequel Server and then we'll add a reporting…services point role to our SCCM server.…Let's go ahead and minimize our console…and we'll go to our start menu in Windows server 2016.…And on this server we've installed Sequel Server 2014…although you might have a newer or older version installed.…
Let's go ahead and scroll down to where we get to…reporting services.…And we'll go ahead and connect…and we see several different options.…Reporting services configuration manager…is where SCCM gets it's information from…when it builds reports.…So we can take a look at our different…categories here on the left,…starting with the service account.…And we're going to use the built in account…report server, although if you decide to…you can choose to use a domain user account.…
Let's go to the web services URL…
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: Configure Microsoft SQL Server Reporting Services and reporting services point