Hi guys - I was looking for some help with creating a report to find a particular .exe file running on our company systems. We deployed out a new chat software as a scripted install and this software shows up on users desktops as an icon with a .exe extension.

My manager wants a report that would show the number of systems where this particular .exe has been installed. Machine details would be good - system name, IP, etc. I've already searched through the generic KACE reports, but haven't found anything that I can change to my needs. I'd appreciate any assistance with this.

Thanks,

Kevin

 

Answer Summary:
FileExists(%ALLUSERSPROFILE%\Desktop\click to chat.exe)
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

5

Assuming it shows up there, Software inventory will show how many systems the particular software is installed on.  If not, you would need to create a software inventory item that has a custom inventory rule that gives the KBOX the ability to inventory it.  Something like:

FileExists(C:\Users\Public\Desktop\chat.exe)

Here's a way to report on that software inventory item:

Reports>Choose Action>Add New Report>

1. Name, categorize and describe as needed. Report topic is Computer. Click Next.

2. Under Computer Identity Information, select at least System Name and IP Address.

3. Under Other, select Software Titles. Click Next.

4. Order the fields how you need to. Click Next.

5. Sort and break as required. Click Next.

6. On filters, create a rule to filter based on your software title. (alternatively, you could also manually filter in Excel) It would be something like this:

Software Titles = {name of chat program}

7. Click Next and Save.

You can now run the report in HTML, CSV or TXT.

Answered 08/13/2012 by: jknox
Red Belt

  • Hi Jknox and thanks for your reply. I needed to create the custom inventory report and machines are checking in now. It looks like only Win7 systems are checking in with this custom rule. Do you know how I can get XP systems to check in? I added the custom inventory rule: FileExists(C:\Documents and Settings\All Users\Desktop\click to chat.exe) - the path used to deploy to our XP systems. None are checking in so far.

    Thanks for the help so far,
    Kevin
    • I would try FileExists(%ALLUSERSPROFILE%\Desktop\click to chat.exe).

      Either that or you can use

      FileExists(C:\Users\Public\Desktop\click to chat.exe) OR FileExists(C:\Documents and Settings\All Users\Desktop\click to chat.exe)
  • Hi Dugullett and thanks for the reply. Your suggestion to use the FileExists(%ALLUSERSPROFILE%\Desktop\click to chat.exe) custom inventory rule worked and my XP systems are checking in now.
  • I know this is really old, but this is not working for me. I want to do the exact same thing, only with the following file:

    C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf

    where MSSQL10_50.MSSQLSERVER might be different so would need to be a wildcard.

    Can you help me?
Please log in to comment
Answer this question or Comment on this question for clarity