Loading
search-img

Sherril.Howlett asked a question.

October 23, 2018 at 7:00 AM
Installations per Computer

Does anyone have a way to generate an Apps per Computer report which brings back installs of an app, but only those which are actually installed, and not those which have been removed, subject to metering?

I'm trying to run reports internally and am coming across discrepancies where the installation numbers are skewed due to the 'removed'/highlighted items appearing in the count as well.

I know that I can get the actual installation number when Listing All Applications, however, it means looking at each version individually; additionally, column choice is limited in the output.

Thanks in advance!

Sherril

  • 11 answers
  • 59 views

  • carolai

    Hi Sherril, I also often struggled with that report and I created a feature request for this in the idea's board. ‌. This then would make it easier to separate installed applications from metered applications. In the meantime I'm using the following workaround. You need to add the column Installed to your report Applications per computer. This column is empty for operating systems and metered applications, but it shows a date for installed applications. You can can insert the condition " Greater "  01/01/1980 Then only the installed applications will be listed in that report. With this way I can get the required result, but nevertheless this is not easy to explain to all our users and therefore would prefer to have idea implemented.  
    Expand Post

    • Sherril.Howlett

      Thanks for the workaround, Carola - I'll give it a go, but will also add to the Ideas Board so we can all benefit if/when implemented Kind regards, Sherril

  • Portal User

    Sherril,   I think this is one of the subjects covered in the Ideas page and I have also asked for similar for Blacklisted software (which is a separate idea in itself and another bone of contention).  I have added this to the list of things to cover when I meet Snow shortly.  I also have need of this capability and it’s two sides: knowing what has has been used over the inventory period versus removing actual installs and being able to efficiently identify them Mark
    Expand Post

    • Sherril.Howlett

      Hi Mark, Happy it's not just me! Would be great to hear how you get/got on with your meeting, but in the meantime, I have found 's workaround quite useful. Sherril

  • JonasGrundell

    Applications per computer   The “Applications per computer” report is showing applications that are actually uninstalled. The main reason for this is that Snow Software has referred to the licensing mobility terms and conditions and the 90 day rule. If any Metering data is available on the application then it is reported.   Now let’s take the big fish as an example, Microsoft! Under an Enterprise Agreement you are considered to be compliant from the day that you submit your True-Up until the next one. What is done before a True-Up is to inform the organization of the current status and the financial implications. Naturally with data supporting what they can do to take action and avoid unnecessary additional cost for unused applications. This is typically something that you would use the “Applications per computer” report for. Now a couple of things will happen:   My tech people will uninstall a number applications that have low usage and I will later on pull another report to confirm the status. The result is that I would go back to my tech people and say that they only finished a portion of the job. Naturally they will be annoyed since I would be accusing them of not doing their job. Also their trust for SLM as an accurate tool would drop and rather be considered as unreliable source of information. The other thing that would happen is that I would use the “Applications per computer” to calculate the True-Up. That based on my trust on the inventory tool providing accurate reporting. Since my report contains applications that are not installed, I will be buying licenses for something that does not exist! I did a check on my organization and ended up with close to $100.000 in purchases that I do not need. What the consequences on a Global scale, across all SLM users are… I don’t even want to think about it.   This is something that I have highlighted to Snow Software and to the highest level over the past 2 years. Pointing out that every applications report must have a field stating if the application is installed or not. So far absolutely nothing has happened. The information if an application is installed or not is in the database and finally Snow Software managed to provide me with a report containing this field. However this is only for my installation and I cannot share the report in the organization. /Jonas
    Expand Post

  • Bineeth

    Hi Carola, I believe there is a misunderstanding..... Please correct me if am wrong.. The installed attributes doesn't means application installed date... this implies SNOW Agent installed date. whereas there is an option called first discovered date... this might help you to figure it out application installed date. Regards Bineeth

    • RicardoPereira

      You used the following query to return specific software-installed software information: select a.Name, InstallDate, FirstUsed, LastUsed, IsInstalled from tblApplication AS A left join tabCID_cf_a_1 AS B on a.ApplicationID = b.ElementID LEFT JOIN tblComputerApplications AS C ON C.ApplicationID = A.ApplicationID LEFT JOIN (select top 1 HostName, ComputerID,OperatingSystem from tblComputer where HostName = ("""HostName""") order by ReportingDate desc) as D ON D.ComputerID = C.ComputerID left join tblApplicationStoreData as E on e.ApplicationID = a.ApplicationID LEFT JOIN [SnowAutomationPlatformDomain].[DBO].[services] as portal on portal.name = a.name where OperatingSystem in ('Microsoft Windows 7 Enterprise','Microsoft Windows 10 Enterprise') and IsInstalled = 1
      Expand Post

    • carolai

      Hi Bineeth, Perhaps you mean another report, but here we discussed about the Report "Applications per computer". This report shows installed and metered applications per computer. But often we want to see only installed applications, to decide if perhaps something needs an uninstallation. In this report the column Installed was intended to show the applications install date. In other blogs here you will find, that this does not always show the application install date, instead the file date of the exe or folder date. The Snow Agent install date you mentioned normally is shown as column "Client install date", but this is not available in this special report. The First discovered date you mentioned is also not available in this report. This is available for example in the "Application installation history" report or also when you open in the computer details. Do you perhaps mean another report? Best regards Carola
      Expand Post

  • SamuelBaughan

    Hi Sherril, This is a good point. There is no report yet that brings up this information as far as I know. There is a similar idea posted on the Ideas Board , feel free to add your voice to it Regards
10 of 11

+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
Installations per Computer