mfeinman asked a question.
SQL Query to Count The Number of Inventory Agent Installs By Date
Hi all ...
I want to track new deployments of the Inventory Agent using a SQL query. I'd be specifically looking for the count of 2022 R1 agents deployed on non-Windows devices grouped by date. This is the query I've written:
- select CAST (ia.DiscoveryDate as Date) as InstallationDate, count(*) as AgentInstallCountfrom FNMSCompliance.dbo.InstalledApplicationInfo ia, FNMSCompliance.dbo.ComplianceComputer cowhere ia.ComplianceComputerId = co.ComplianceComputerIDand ia.ProductName = 'FlexNet Inventory Agent'and ia.SoftwareTitleVersion = '2022 R1'and co.OperatingSystem not like '%Windows%'group by CAST (ia.DiscoveryDate as Date)order by CAST (ia.DiscoveryDate as Date) DESC
Does this seem reasonable to you? --Mark
That looks reasonable. I wouldn't be surprised if you found some nuances and complexities in the particular data you're working with here, but I'd expect the results of that query to generally be directionally accurate as an indication of how many installs of the agent are happening each day.