Altiris Report to search for specific .exe files

[Migration User]

in my company we got at some exe files on each client pc we need to searcf fore.

Fore example a file called bioinfo.exe and wich version it is, and maybe for a file called bioandet.exe

 

is this even possible?

i prefer a sql report if anyone knows some code

[Migration User]

Have you tried Inv_Installed_File_Details?

SELECT * FROM Inv_Installed_File_Details WHERE Name='bginfo.exe'

If this doesn't provide enough information, try SELECT * FROM Inv_AddRemoveProgram WHERE Name LIKE '%bginfo%'

If neither table provides the data, you will likely need to use a custom inventory.

[Migration User]

I just got problems finding a custom there allready does this

[Migration User]

So does the SQL work for your purposes, or..?

[Migration User]

I can't seem go make it work.

The problem is that some of the programs doesnt display in add remove program and are just some exe files on the clients pc's, and i cant find a allready made custom report there can show exe files.

That is why i think it shall be a sql report to find the specific exe files and their versions

[Migration User]

OK.  The SQL report I provided would have shown you the data on the .exe's if Altiris were gathering it.  So you'll need to create a custom data class, write a custom inventory to gather the data, and then schedule the task to populate it for all computers.

[Migration User]

uhm i have no idea how to do that:D

[Migration User]

Here are a couple articles in custom inventory in NS7:
https://www-secure.symantec.com/connect/articles/introduction-custom-inventory-notification-server-70
https://www-secure.symantec.com/connect/articles/custom-inventory-solution-7-script-examples