I need to create a SQL query using the report builder to yield software name, software version, software publisher, and the number of each of those softwares in use on my network. I am unsure how to begin structuring said query beyond selecting tblsoftware.softwareName, tblsoftware.softwareVersion, and tblsoftware.softwarePublisher, mainly as I am unsure where to find the column name for the number in use within Lansweeper. Any help would be much appreciated!
🙂