Creating Applications Report for Devices on ControlUp

A user needed help creating a report with data about applications on their devices. They used the ‘Installed_apps’ data index and wanted to use the ‘App focus’ or ‘builtin_process_stop’ data indexes for information about usage, but there was no relationship between the data. Another member suggested using dashboards or workflows to gather the data and provided an example.

Read the entire ‘Creating Applications Report for Devices on ControlUp’ thread below:

Good afternoon,

I’m trying to create a report containing some data about applications on our devices. The report needs to show all apps installed in user context, how many times they were installed on all devices, when they were installed (date) and how many times they were used (or maybe even better, when they were used the last time). I’m especially looking for apps that are installed on only one device.

I started by creating a report based on the ‘Installed_apps’ data index. That gives me a lot of information (user context installs can be filtered from this data index). To get information about the usage of an application I wanted to use the ‘App focus’ or ‘builtin_process_stop’ (or process_stops – not sure why there are two similar data indexes?). The problem now is that there isn’t any relationship between the process data in those indexes.

I can give you an example using the application SoapUI:

• Installed_apps shows name = SoapUI 5.7.0, uninstall_string = "C:\Users\XXXXXXXX\AppData\Local\Programs\SmartBear\SoapUI-5.7.0\uninstall.exe" and publisher = SmartBear Software
• app_focus shows processfriendlyname = SoapUI-5.7.0.exe, processname = soapui-5.7.0.exe, processnamewithpath = C:\Users\XXXXXXXX\AppData\Local\Programs\SmartBear\SoapUI-5.7.0\bin\SoapUI-5.7.0.exe
• process_stops show friendlyprocessname = SoapUI-5.7.0.exe, commandline = "C:\Users\XXXXXXXX\AppData\Local\Programs\SmartBear\SoapUI-5.7.0\bin\SoapUI-5.7.0.exe", processname = SoapUI-5.7.0.exe and processnamewithpath = C:\Users\XXXXXXXX\AppData\Local\Programs\SmartBear\SoapUI-5.7.0\bin\SoapUI-5.7.0.exe

There seems to be nothing I can use to connect data from Installed_apps to data from app_focus or process_stops. Are there any fields available that I am missing here or is there another approach to create this report?

Greetings

This might be something done best with dashboards @member what you think

Hi this is sadly correct .. applications dont report what their running name or process will be while installing it.

You can use workflows to gather this data together and put it in a new index or check out our new windows application stability and performance dashboard in the gallery it combines app focus processes stops and highresource procs all together

but yeah combining installed apps and focus needs 2 differnt queries you need to match together and that can be done with workflows. If you want I can send you an example

Hi Chris, an example would be nice. Thanks!

here you go in theory you should just have to change 4 variables on top

Continue reading and comment on the thread ‘Creating Applications Report for Devices on ControlUp’.  Not a member? Join Here!