How to generate query based on certain date or range ?

[danielk]

Hi There,

Please advise how to do the following.

a report based on xxx software is installed based on today lspush/active scan date
a report based on xxx software is installed based from Jan 2015 to today lspush/active scan date
a report based on xxx software is installed based on a week lspush/active scan date

Thanks

[Susan_A · Accepted solution]

Not sure what you mean by "based on range of lspush scan and active scan date". There is no easy way to list computers that had a specific software installed between date X and date Y, if this is what you're asking. To list computers that currently (based on your latest scan results) have a specific software package installed, you can open the built-in report "Software: List of software by computer" and filter the Software column within the report results.

A sample report for computers missing a specific software package can be found here.

[danielk]

Hi,

eg.

microsoft outlook not installed in an ad OU workstation based based on today date of lspush and active scan
microsoft outlook installed in an ad OU workstation based based on range of lspush scan and active scan date

[Daniel_B]

Could you specify which information you are looking for exactly? Do you need a count of software installed on computers, or data about only one specific software?