//
archives

SCCM Reporting

This tag is associated with 2 posts

Installing SCCM Reporting Services Point

In this post you’ll find the steps on how to install the SCCM Reporting services point role. Make sure that SQL Reporting Services is installed and configured in your environment. Install the role In the SCCM console go to¬†Administration > Site Configuration > Servers and Site System Roles¬† Right click on the server that will … Continue reading

HP Machines and BIOS version Report

I was asked by my Project Manager to generate a report for HP machines (desktop and laptops) that lists Hosts names, Hardware Model, BIOS version and Operating System version. I Run the Query below SQL Management Studio and saved the result to a CSV file: SELECT Bios.SerialNumber0 as [Serial Number], Bios.SMBIOSBIOSVersion0 as [BIOS Version], Comp.Name0 … Continue reading