Let’s dive into the process of building SCCM Custom Report with a Report Builder. The article walks you through the process of building custom reports based on customer needs.
What are the essential Requirements?
SQL Server Reporting Service
Before using the Reporting Feature in Configuration Manager, you should think about installing SQL Server Reporting Services. For comprehensive information, walk on the steps in Install SQL Reporting Services.
Reporting Services Point
Consider installing and configuring the Reporting Services Point role on a new or current site system server.
Collecting Info and Planning
Gather all the required information and organize accordingly before creating any SCCM Hardware Inventory Report. You must collect information, like Hardware requirements, Supported SQL version, accounts, permissions, security roles, with Report Builder Registry settings and more.
Getting Your Report Builder Installed
A report builder helps you install the report on your local desktop. Either you can install it via a web or the Microsoft endooint configuration manager.
While starting Report Builder from the Reporting Services Web portal, you will be notified to download it.
Using a Report Builder
Let’s look into how to customize the SCCM Hardware inventory report.
Firstly, you have to develop a Dataset for SQL query, then right-click the Data set and click ‘Add dataset.’
The wizard namely Dataset Properties will appear and you can enter the information as per the. Copy and paste the SQL query mentioned in the section. Get the Dataset inside the Report and choose your data source.
If you want to look at the report whether it is operational or not, insert your credentials or provide your existing Windows credentials.
Click OK given at the bottom, and then choose to continue.
If you’re experts handling SQL queries, create a query in the report builder and confirm it with the Query Designer.
Make the best use of query design to RUN and verify results.
Ensure the name incorporated into the query doesn’t have spaces, or you will find the error below.
After clicking OK, you will find the database gets included into the Dataset. Now, click on Table and Matrix Wizard.
After clicking Table or Matrix wizard, select Dataset and choose Next.
The following step will illustrate how to configure fields that you can select accordingly. Now, you must be looking to retrieve the value to choose both views and then drag/drop all the views into the Values field.
If you’re considering creating a Pivot, ensure to use row and column fields along with values.
Choose the Next and then the next windows and keep the chosen values as default. Now, check the screen below:
Now, drag and drop to modify the matrix page’s size with cursor to expand and collapse it. Ensure to make the best use of the above tools to alter the colors, font size, and text accordingly.
Choose the box that you’re willing to edit and include the changes.
Follow the above steps to create SCCM Hardware Inventory Report and make the best use of it.
SV Trainings is one of the leading Microsoft SCCM certification training providers online till date.
We are proud to say that we have delivered SCCM training to 1000+ professionals.
Our SCCM trainers have min 8+ years of experience in the industry.
Our SCCM training course covers the most relevant and up to date syllabus required for and Microsoft Support Specialist.About SV Trainings:SV Trainings is the globally professional in IT courses training which emphasizes on hands-on experience with examples from real-time scenarios by experts.
It is the largest provider of high-quality online training courses.Key Features:-Instructor-led Sessions-Certified & Industry Expert Trainers-Multiple Training Delivery Models-Customize Course-24/7 Live Expert Support-Hands-On Experience-Real-Time Case Studies-Q and Assignments with TrainersFor Free Demo Please Contact:USA: +1-8459158712 INDIA: +91-9642373173Email: info@svtrainings.comWebsite: https://svtrainings.com/sccm-training.html
To help publicise a self-started tech conference in 2006, two dudes named boris and patrick created a website called the next web .
The event came and went, but the site continued to evolve, soon becoming one of the best technology blogs on the internet.Nowadays, tnw is a full blown media company and formidable resource for all things tech and beyond, proving just how far an idea can travel with the right minds behind it.
Worth noting is that, like most tech blogs, gizmodo touts a progressive edge.Galido’s Private I.T Technology blog provides tech enthusiasts with valuable information and links to computer tips, tricks and solutions.
Solving problems and building solutions are what the team at fujitsu aim to offer with their face2fujitsu blog.In other words, those hoping to avoid politics might best take their reading elsewhere.
In addition to its coverage–which reaches more than 12 million unique visitors a month–the site hosts major global events like the disrupt series and the crunchies awards.
As if that wasn’t enough, techcrunch also established crunchbase, an open database and statistical resource for investors and speculators alike.From devops to security, infrastructure, cloud, and more, informationweek covers all the pertinent subject matter for today’s it pros.
