Hi There,
I've tried and tried but I just can't seam to get this report right, what I'm trying to do is create a report which shows all computers with software X installed.
I'd like to be able to target this report at collections as well, but its not necessary so long as I can specify to be all windows XP computers
I can create a collection which returns the results I want, but not a report, the report is always over reporting as in showing me information which is not correct.. it picks up the application exe even if it is not installed and just located in c:\temp.
Or there will be one computer with multiple entries, but when I look at the resource data for the table AeX_OS_Add_Remove_Programs I can only see one entry, also too.. the collection which is built using the AeX_OS_Add_Remove_Programs table is also correct only showing one entry.
I think the report should use the following tables, but open to suggestions.
Inv_AeX_AC_Identification (to get the computer name)
Inv_Global_User_General_Details (to get the complete user name information from AD import)
AeX_OS_Add_Remove_Programs (to get the information about if the application is installed)
The report would look like this:
Computer Name, User Name, Installed location of Application
Computer 1, John Smith, C:\Program Files\Microsoft Office\Visio10\visio.exe
I'd be very grateful for any assistance on this, I'm surprised there isn't a built in report to give me this information.
Thanks Heaps.
Mick.