Loading
search-img

aurora.sullivan asked a question.

September 30, 2019 at 7:00 AM
Computers Assigned to a License

Hello,

Can anyone point me in the direction of a report in Snow that can display all computers/datacenters that are assigned to a license?

As far as I can see, there is only a report for the licenses assigned to users called: 'Assigned named user licenses per application'.

Kind regards,

Aurora.

  • 14 answers
  • 66 views

  • Portal User

    SLM 9 has two standard reports called License tracking per computer and License tracking per user... Is this what you need?

    • aurora.sullivan

      Hi Adam, Thank you for your comment. Those two reports are also available in SLM8 (we are running this at the moment). However, they don't display which users/computers are assigned to a license, whereas the 'Assigned named user licenses per application' report shows this but there only seems to be a report like this for users.  Kind regards, Aurora.

      • Portal User

        You can get this information by going to the license and clicking on the assignment tab in SLM 9. Not sure 8 offers this info.... Otherwise the other way is to go to the application and check the users or computers. It will tell you there if it's assigned to the user/computer. You can export both these tables by right clicking on the table and choosing which export file type you want. Is that any help?
        Expand Post

        • aurora.sullivan

          Hi Adam, Thank you for that recommendation. I needed a report so I could see all of the licenses that are assigned to a computer/datacenter rather than clicking into each record individually.  Thank you for your help though.  Kind regards, Aurora. 

  • SamuelBaughan

    If you feel like getting this from the database, there are 2 tables that contain your information: tblComputerLicenseTracking tblInvalidLicensesPerConsumer This only applies to Licenses that are manually assigned. For some reasons, I believe you need to filter on UseRight = 8192 and PrimaryUseRight = 8192 but I can't remember why ...

    • aurora.sullivan

      Hi Samuel, Thank you so much for those table recommendations and the additional filter, that got me what I needed . It's a shame you can't just pull that from the front end SLM like you can for you user assignments.  Kind regards, Aurora. 

    • aurora.sullivan

      Hi Samuel, I hope you're well. I need to use this report that you suggested and I'm finding it a little confusing on how I can identify a machine using the consumer ID. I've had a look in the tables within SQL and I can find a report that links consumer ID to a hostname. Do you happen to know this? Kind regards, Aurora.

      • SamuelBaughan

        The ConsumerID is the same as the ComputerID. It is called differently only because in the case of User licenses, the ConsumerID is a UserID Is that the missing piece?

        • aurora.sullivan

          Hi Samuel, You are a star! Thank you so much for that, i did wonder if it was the same but i wasn't sure. Do you happen to know if there is table in SQL with both the machine name and the ConsumerID/ComputerID in? Kind regards, Aurora. 
10 of 14

+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
Computers Assigned to a License