When a software title is installed on a machine, and a version number is not included in ARP, CM reports do not return the computer specific information.

Running a summary report, the title is counted. But when drilling thru to get the detail, the information is not reported. This report inconsistency makes users doubt the validity of all reports base on ARP data.

Please adjust the report queries to reflect installed software without version information

Please consider an option to provide configuration capability to the default 1095 days retention period. This hard-coded value is creating numerous challenges with table sizes and corresponding disk usage. We currently have to re-initialize the database every 9 months in order to avoid a disruption to service and operation.

Please Provide Standard Reports of Missing Patches: summary by collection; detail by collection; detail per computer

The market is full of security tools that do this, but it is a frustration that we need SCCM and some other products to have complete, convenient visibility. SCCM does 90% of the work, but that missing 10% is very important. It would seem that MS and SCCM should be the bast positioned to provide this value. Please do!

some report are not good because some state message are not received/processed by MP/FSP
for example:
statemsg for KB install or not
statemsg for client update

It would be nice to have a "local time" column in the reports instead of just UTC.

Add a search function to the Entities list in CMPivot, just in case I have no idea where to find what I need to query.

This SQL table has to important columns NumbaricValueLow and NumericValueHigh. Using these columns along with the fnGetNumericIPAddress function, you can create reports that will help with troubleshooting of SCCM clients. As such, it would be great to have SQL view create based on this table that can be used for reporting.

This function allow you to determine the Numeric value of an IP address. Using this function will allow administrator to create reports based on boundaries. Please Grant this execute rights to this function for smsschm_users. This will ultimately lead to better reporting and troubleshooting.

After manually adding Win32_DeviceGuard, https://cloudblogs.microsoft.com/enterprisemobility/2015/10/30/managing-windows-10-device-guard-with-configuration-manager/ some of the properties aren't exposed in CMPivot: Specifically, SecurityServicesConfigured and SecurityServicesRunning. This makes it difficult to gather whether or not CredentialGuard is enabled.

In the database [dbo]. [ActiveDirectorySites] the name of the AD site is replicated in the site description and not taken from the AD site

Add functionality to create a custom HINV schedule for Add Remove Program data. This would benefit people that have frequent ARP changes, but not frequent hardware changes. Alternatively ARP Data could be it's own inventory item.

Your report manager would be great if it could include Operating System Build in the export options.

Add a Report as Compliant 7 but not only for one SUG but several. When we deploy to computers we deploy montly updates but a old Baseile Aswell, we need to know the status of all of that deployments at once

Reporting Part should be improve as we are able to fetch only basic reports. need reports likes Installed updates of Machines and SW/HW Reports with accurate details. Software compliance reports should also better. There is lot off option in reports part but not work for customer, please minimize the count of reports as every reports should be good and valuable.

Recommend capturing which SMS Provider is used to connect console sessions. Some environments have more than one provider and it is also useful for customers with Site Server High Availability implemented.

Currently SMSProv runs spCMUpsertConsoleUsageData, which populates ConsoleUsageData, and is ultimately consumable for reporting in v_CMConsoleUsageData.

A teams integration would be great. Like a simple solution to lookup information in SCCM or a self service solution to add your computer to a Collection. Also just alerting to teams would be Nice. Im sure there are more fun things you could do with this.

It would be great to see the date an update was installed. We're asked by auditors to show when updates were installed on a given computer, and I don't have a good way to do that. The Compliance report for a specific computer shows the installation deadline, but not when the update was actually installed.