Can I please have a query compatible with build 8123 and MSSQL as follows:

Specified software (eg Mozilla Firefox) of my choice installed on Assets with a SD scanning agent and last scanned time.

Columns required:

Hostname, User, Department, Site, Software (eg Firefox), Software Version (eg 20.0.1), Last Date Scanned

As an example, this is so I can identify which assets are not running the latest version of Firefox, and produce a list relevant to each site/region to request they update their PCs.

I can get the software info from queries posted on here previous, but can't find one with the last scanned date that I can also filter to only show assets with the SD Agent installed.

Many thanks,

Dean