I'm trying to export report data relating to Software scanned in the last
30 days(from the report date).

I'm trying Crystal to have export options(cause AMWC doesn't allow such a
large export) , and my results do not match Asset Management Web Console

Meaning, in AMWC shows say, 150,000 records for workstation scans.
Using Crystal , and trying to utilize a formula to restrict the returns to
the previous 30 days yields far fewer records. say, 60,000 vs 150,000

I did my best in trying to choose the correct tables/fields and am using
the ZenWorks v7.0 Database Schema drawing as a reference.

See this URL for where I'm pulling table data from:


Help/advice is greatly encouraged...