Sccm Metering Report Software Metering Rule

It doesnt matter if the software metering rule is enabled or not as long as the exe name matches.

In this case it is CMD.exe, and you end up with what I call a false positive result.

That was my first reaction too, but now that I have thought about this a bit more, it is not actually a problem at all.

The system here was built by an other guy who left the company.

Not only it brings value to an SCCM installation, it bring visibility on your hard work toward your management.

Without SCCM reports, this huge management tools is running silently on all your devices but youre not benefiting of all the advantages.

Its like having a sport car and discovering the Autobahn ok maybe not.

If youre showing incorrect information, your report will be useless.

Without any SQL skills, it will be hard to achieve what you want but, everything can be learned.

Two years ago Ive never done a SCCM report and today weve build many and sells them to businesses like yours.

Microsoft proves this with their latest Software Update dashboard and Office 365 dashboard.

Yes, they offer valuable data but they are often not adapted to your environment and are visually basic.

Sccm Metering Report Free Office 365

For this example, we will show the process that we took when designing our free Office 365 report.

A new inventory class is created on the client and this data is stored in the vGSOFFICE365PROPLUSCONFIGURATIONS.

We found this view by browsing the vGS classes in the SCCM database.

These classes are usually related to hardware inventory information.

We need to use a JOIN SQL command to get it from the VRSystem view which is the main discovery view containing your clients.

An SQL JOIN clause is used to combine rows from two tables, based on a common field between them.

In our case (We join VRSystem and vGSOFFICE365PROPLUSCONFIGURATIONS based on the same ResourceID).

You can also use Visual Studio but you need a licence, so well stick to Report Builder.

The Data Source section will be used to configure the database and Dataset will be used for the SQL query.

For example, if you want to scope a report to a specific collection, you will need to use the Parameters section.

If you want to include your company logo in the report, you will need to import it in the Images folder.

If not, set up another account via Credentials on the left panel.subox.

The report is automatically available on your reporting point in the folder you specified.

Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 5 times Enterprise Mobility MVP.

I tried to use the report builder but it is not installed yet.