SQL Query to Count The Number of Inventory Agent Installs By Date

[mfeinman]

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 AgentInstallCount
from FNMSCompliance.dbo.InstalledApplicationInfo ia, FNMSCompliance.dbo.ComplianceComputer co
where ia.ComplianceComputerId = co.ComplianceComputerID
and 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

[ChrisG · Accepted solution]

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.