Altiris console reporting showing inaccurate data
We are running Altiris 6.9 SP3. I'm trying to use the console (not the deployment console, just the web based console) to show us a report of software installed.
Our company is being audited for software and we need to use Altiris to provide results. The auditing company has given us a SQL query to run against our database to report what we have installed. It comes up with nothing, but I know the sql database is out of date. We changed the script to look for winword.exe and it only shows 50 results, we have at least 250.
I need to update the database with accurate information. How do I do this?
I was looking around in the console at reports, assets and inventory, inventory, windows, software/applications, software and found a report called "count of computers by product, version, and manufacturer. I click on run this report and get a new window, allowing me to type in what computers I want to run it on. By default % is in that field meaning it will run on all machines. There is a collection field that says "all 32 bit windows computers" If I click on the edit button next to this I just get a blank screen, no options can be changed...
I run this report and get results, but it's not up to date. How do I make this accurate?
Also is there a way to run a report for a specific .exe or file? Whese is this located?
I have 1 week to get this working.