Metric Name: ConnectWise RMM: List of Installed Software [PowerBI]Category: Inventory ManagementDescription: This metric collects and lists the software installed on endpoints monitored by ConnectWise RMM (Zenith InfoTech RMM → Continuum RMM→ ConnectWise RMM). It provides detailed insights into the applications running on each machine, formatted for use in Power BI to enable streamlined reporting and visualization.Purpose: The purpose of this metric is to track all installed software across endpoints managed by ConnectWise RMM. This helps IT teams and Managed Service Providers (MSPs) monitor software deployment, ensure compliance, and quickly identify any unapproved or outdated applications in client environments.How it works:The metric uses the query SoftwareInstalled.InstalledSoftware[].[['--'],['Name:'MachineName],['Application:'Application],['Version:'Version]][] to extract a list of installed software from endpoints.It gathers information on the machine name, application, and version, which is formatted for easy reporting and analysis in Power BI.Beneficiaries:IT Administrators: Gain a comprehensive inventory of installed software across all endpoints, helping with license management, software auditing, and policy enforcement.Managed Service Providers (MSPs): This information is essential for MSPs managing multiple clients, allowing them to provide detailed reports on software installed across their clients’ environments and ensure compliance with licensing and usage policies.Security Teams: Can monitor for unauthorized or vulnerable software, ensuring that all applications are compliant with security policies and are regularly updated.Additional Notes:Customization: The query can be expanded to include additional fields such as installation dates, software vendors, or installation paths. This can be helpful for organizations needing more detailed software audits or compliance reporting.Why this is valuable: By tracking installed software, organizations can ensure they remain compliant with software usage policies, reduce the risk of security vulnerabilities from outdated or unauthorized applications, and manage software licenses more effectively.

SoftwareInstalled.InstalledSoftware[].[['--'],['Name:'MachineName],['Application:'Application],['Version:'Version]][]