Instead of releasing a user license from form
I need to automate this process and release(delete) them using a script. I am looking for a view or form name that shows me current users with theirs licenses.
Thank you,
Vlad
Sep 13, 2019 1:10 PM
You can't do this via SQL - license management is performed in the server code and the details stored in the database are for reporting and do not determine when a license is released. Also note that Administrators can manually release user's license one time in a 24-hour period - see Releasing floating licenses to a license pool - Documentation for Remedy Action Request System 9.1 - BMC Documentation
What is your use case? If you explain what you're trying to achieve someone may be able to make a suggestion.
Sep 13, 2019 2:09 PM
Yea...so, as Mark says, the ability to release a user is an admin only function, and can only be done rarely. The reason for this is because releasing licenses through scripting could have the ability to bypass licensing models allowing people to essentially run a limited number of pay licenses, but release them almost immediately, thus allowing large quantities of users to use a very small number of licenses, thus bypassing the model....that's why release is limited....so, if we understood your use case, we might be able to help you out.
I'd like to monitor Floating licenses usage. If somebody holds the license more then 1 hour - I'd like to release the Floating license automatically one time in 24 hrs. Thank you, Vlad
Sep 18, 2019 1:15 AM
Hi
Please refer "AR System Administration: License Review" form. You need to pass the licence type and username(if required) to query the form in where clause.
Thanks.
Sep 18, 2019 3:17 AM
As noted in my earlier response you can't release a license via SQL as it is managed by server code. You can set the floating license timeout to 1 hour which would automatically release any licenses once they have been inactive for this time.
If you really want to force the release for a user one hour after they have been assigned a license you will have to do this via workflow. Look at what the active link AR System Administration: ManageUserLic - On Release User Button does to see it is handled. You could use SQL to query the AR System Current License Usage form but you will need to have license tracking enabled to get data recorded - the AR System Administration: License Review form is a vendor form without a database table and so can only be queried via the Remedy API. Once you have identified the user you want to release your script will have to signal the server to do the actual release via an API call or import of data to a form to trigger workflow.
Given the limitations of the feature - once per 24 hours - I don't really understand the use case.