GarthMJ

Each Month Enhansoft gives away a free SCCM dashboard / report. November's Free Report is... Total Usage Trend Analysis for Collections! This software metering dashboard gives you results for all applications and will display these details for up to four collections. The results are grouped by month and will go back as far as what is stored in your SCCM environment (usually 9-months to a year). Get your free report today! The Total Usage Trend Analysis for Collections report is only available in November.

If you are looking for the SCCM Application install date, then you will to look at third party tools for this. Below is an example of what you will see.

Here is a list of all of the log file and what they do. https://docs.microsoft.com/en-us/sccm/core/plan-design/hierarchy/log-files

You need to review the log files to determine why, it is not installing.

It will depend on how you are deploying reader. Here is the list of log files. https://docs.microsoft.com/en-us/sccm/core/plan-design/hierarchy/log-files

What exactly doesn't work? What do the log file say is happening?

On you r site server, unselect the Win32_PhysicalMemory under hardware inventory. Does this fix your issue?

You will need to use a sub-select query to do the not in stuff. Here is an example. https://www.enhansoft.com/blog/subselect-wql-query-to-find-pcs-that-do-not-have-either-x86-or-x64-versions-of-software-installed

You need to export it from the console (client settings) . However I would try Sherry's stuff first, as it is harder to "kill" the sms_def.mof in CMCB.

That take care of the one file what about the client setting (sms_def.mof)?

Have you reviewed your Client setting (sms_def.mof) and Configuration.mof files

There is no directly link between those two SQL views. You will need to dig deeper to find a indirect link between them.

What do you have for you query already? What is not working with it? Here are a few reporting tips. Seven Tips for Writing SCCM dashboards

Did you create a SWM rule for spotify? When did you create this rule? Is the Software listed in Installed Programs in resource explorer? Is the SW installed under the user content? if it is installed under the user context then you will need a 3rd party tool to collected this information with SCCM.

Have you looked at the built-in reports for this info?

I would start by looking at the builtin report to see if ARP reports give you what you want? until that is confirmed there is no point trying to join a user name to a computer.

The screenshots show that you AI update point is running on Windows 2008. So what server is that on?

There is going to be no wrong answer to this, each person will do it differently. I would do it so that ti makes sense to you.

Did you know that Enhansoft is giving away a free report set on Software Update Health? Check out the blog about it. https://www.enhansoft.com/blog/software-update-health-dashboard-set-special-microsoft-ignite-giveaway They give away something every month too! https://giveaway.enhansoft.com/ Keep in mind that I do work for them too.

You you have reviewed the logs files on the client and MP right?

great. so everything is good now then. right?

Review the inventory.log to see if it has run.

Review he inventory.log on the client, is it preforming a heartbeat discovery?

Since this tool only comes with PFE Consulting services and this tool is updated regularly, only PFE consulting services can answer this question for you.

I would check to see if your client are running the most current version of the client.