Software Audit Search Tool
Filed under:
Inventory Solution, Notification Server, Asset Control Solution
Database, Inventory, Reporting, Auditing, Sample
Submitted by snowjgj on 30 July, 2007 - 12:01.
One of the most common questions Altiris Inventory Support handles is how to know which machines have a specific software executable or product.
In order to find all computers with a specific file from the audit scan, in the past it was necessary to create a new report for each software you were looking for.
I have created this report/tool in order to enable the searching of this data based on your criteria.
Below is a screen shot of the report:
It is important to remember that this table is very large and in some environments it may not be beneficial to run this report without any criteria.
In addition, this is based off of a SQL statement and "%" is the wildcard character. Feel free to use wildcards in your criteria.
You can download this Reporting Tool from the attachment below.
To import this report, browse to your reports and right click on the folder where you would like to place this report in your Altiris Console. You can then click import and browse to the file xml or txt file for the audit software search.
| License: | AJSL By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License |
| Support: | User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab. |
(37 votes)
| Attachment | Size |
|---|---|
| Audit Software Search.txt | 9.13 KB |
- Login or register to post comments
- 4325 reads
- Printer-friendly version
Software Audit Search Tool - not installed
You say that one of the most common questions Altiris Inventory Support handles is how to know which machines have a specific software executable or product.
I totally agree, but I also get the opposite question equally times "how to know which machines does NOT have a specific software executable or product".
Do you have a similar report for that???
Endo, Not yet. But you have
Endo,
Not yet. But you have given me a direction to go for that.
A simple way to do this would be to create a collection based on this report for machines containing the executable. Then you can create a new collection that includes all your computers and excludes the dynamic collection you created from this report.
With this collection you would know which machines do not contain the executable.
A not in statement would fail on a large table, and though I could write a report for this using a cursor that would likely be unconvertible to a SQL based collection. I am looking into this now and will try to come up with a report like that.
Hope this helps.
Jay
Software Audit Search Tool - not installed
Any update on this? I too am commonly asked for what machines do not have this software installed.
By the way, I bet the Software Audit Search Tool - IS installed, is one of the top 5 reports my people use. Thank you very much for this report.
mfox
Thank you!
I was trying to build this exact same query and kept getting stuck on the collections join. Simple search and this solution was the first to pop up. Works great!
Audit software search report
Works like a charm. No editing needed. I love it. Just trying to figure out how to add a user field. If you have any ideas that would be great.
option to show machines that do NOT have a software installed
Any headway on an option to show machines that do NOT have a software installed? This would be awesome report to find things like which server do not have our backup software installed.
Report Showing Machines Without Software Installed
SELECT id.[Name] FROM Inv_AeX_AC_Identification id WHERE id.[_ResourceGuid] NOT IN (select [_ResourceGuid] from InvAeX_SW_Audit_Software where [File Name] like ‘%Program%’ + ‘%’ and [ProductVersion] like ‘Version%’ + ‘%’)You would define a parameter called Program and another called Version so you can select what software you are interested in.