Discover How Often Software is Used
The Windows event log contains all sorts of information about your Windows devices from login data to errors generated on the computer. By default, Lansweeper will scan all the error events generated by the Windows computer. Additionally, you can enable scanning other event log information. The report provides a chart of all of the events with ID 4688 for the process "zoom.exe" in the last 14 days. This report does require you to enable the scanning of success events. Once enabled you can use this report to track specifically how many times Zoom was used in the last two weeks allowing you to do software metering with Lansweeper. You can find more information about this use case in the Pro Tips 46 blog post.
Software Usage Chart Lansweeper On-Prem Query
Select Distinct Top 1000000 tblAssets.AssetName, Count(tblNtlog.TimeGenerated) As Instances From tblAssets Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID Inner Join tblNtlogSource On tblNtlogSource.SourcenameID = tblNtlog.SourcenameID Inner Join tblNtlogMessage On tblNtlogMessage.MessageID = tblNtlog.MessageID Where tblNtlog.TimeGenerated > GetDate() - 14 And tblNtlog.Eventcode = 4688 and Message like '%zoom.exe%' Group By tblAssets.AssetName order by AssetName