Hi everyone, I'm pretty new to Kaseya still and was wondering if anyone could help me out. I was tasked with creating in inventory control list based on software applications for one of our clients that shows the application name, product version and last modified date. When I was looking over this list I noticed that i had some applications showing up multiple times listing 2 different dates under last modified yet showing the same product version and some showing the 2 same dates and versions, does anyone know the cause of this and is there a way just to show 1 variant of the application?
I'm attaching an image file of a portion of the list that shows what I am looking at.
There are a couple of likely possibilities:
1. You're running this report against multiple machines (for example, an entire Machine Group or Organization) but not including a the Machine ID in the report. Multiple machines have the same software installed, so each instance is being discovered and reported on (one record for each machine where the software was discovered). To see if this is the cause, add Machine ID or AgentGUID to your report part and re-run. If this is the cause, you'll find that the Machine ID (or AgentGUID) is different for each duplicated entry. If this is the case, your resolution will depend on what you're actually trying to report on. Do you want all apps installed on a single (or specific) machine(s), all apps installed on any machine but only reporting the distinct app records without regard to which machine is running the app, which machines have a specific app installed, or something else? You may need to use some group/sort/limit filters, depending on the results you actually want.
2. Audit is returning multiple records of the software for an individual machine. Check Audit > Installed Applications and check whether there are duplicate entries of the app(s) that are appearing duplicated in the report for the individual machine. If there is, check the machine locally to see if the app has multiple .exe files (perhaps copies of the .exe in additional folders on the machine).
There may be some other less likely causes, but I'd recommend starting with the above.
Try using the Advanced Filter (the last step of the wizard) with the row Application Name (or Version) and the operator "Not Empty" or "Not Null" to remove these from the report. Experiment with other advanced filters/operators for further refinement (version greater than, app name like, etc.).
If you want to figure out what's reporting as empty, add the machines name to determine which endpoints are reporting the nameless/versionless application, then check Audit for those machines to see if Installed Applications reports apps without a name. If that's the case, dig into the endpoint to determine why there are .exe files with no name.
Could you provide a screenshot showing the configuration of the report/report part you are using?
I'm using the Application Report Part under Audit. In the Column Selections I have Application Name, Product Version and Last Modified Date.
I haven't worked with the filters too much, is there a way that I can group similar applications unless their version differs? I am running this against a machine workgroup.
As Brande mentioned those are possible situations.
Just trying to recreate your report and review what you are seeing -- there is no identifier as to what machine these applications associate with.
Here is what happens when I execute a report similar to what you have:
Using the computer name column within the report part allows applications to display next to their associated machine:
If you implement a group by application name, you can see what machines have a specific app type.
In this case here is an example of proquota.exe which is a Windows executable.
While this may look like its the same application listed over and over, it is due to the fact that the .exe is actually located in several different places on the endpoint.
If I check the Audit module it lists the same amount of proquota.exe's:
If we check the audit raw scan files, it detects several instances of proquota.exe within the created file:
If we manually search the machine for the same file, we see several instances of this file falling in different locations:
The Audit > Installed Applications data set will show you all available .exe's detected on an endpoint.
More often than not, this has several of the same .exes that are often in several different locations.
It might be cleaner if you create report parts for unique applications that you want to review, then compile the report parts into one report and execute the report.
Another alternative is using advanced filters to display or not display certain applications that are / are not relevant.
Here is an example:
There are several different operators that can be implemented to filter for unique data.
You can use several filters or groups to get an end result tailored to what you want, but you may need to play around with the options a bit to find what best suits your needs. I created a report to include only the App Version but group by the App Name. For simplicity of the report, I used an advanced filter to include only apps beginning with "bit".
The result is a report that groups applications based on the name but only displays one record for each unique version of the app:
This would provide you a list of all applications and unique versions. You could add additional fields if necessary. Alternatively, you can use the original report you built and export to Excel to do additional manipulation. A more advanced option would be to consider using Database Views: http://help.kaseya.com/WebHelp/EN/VSA/9000000/index.asp#532.htm
Regardless of which way you decide to go, a lot of building report parts and reports is trial-and-error to return the results you expect to see in a format that works for your needs. As a general framework, there is almost always a way to get exactly what you want, but the more customized your need, the more you must to customize your approach to getting there. Sometimes it's faster/simpler to get the data out of Kaseya and manipulate elsewhere (such as Excel), but if you need to regularly repeat processes, you can build an automated solution using Kaseya by leveraging the various tools available. That customization will often come with an up-front investment in your time to build out, but for a process needed for the long-haul, building out the automation can often save you time in the long run.
Thanks for all the help so far, I've pretty much narrowed it down to what I need, the only problem that I am currently running into is getting a list of items that don't have a Manufacturer name or Product name listed, but have a Product version only. I can't seem to find a way to filter that out, or know if there is a way to filter it out.
Thanks for the help Brande, I got everything to look the way we needed. I appreciate all the help you have given me.