SELECT * FROM [ProcessManager].[dbo].[sd_licensing_info]
This Table in ServiceDesk 7 would give the processes and the start_date and who was using Servicedesk. So we could sorta know how many concurrent licenses were needed to run ServiceDesk in our enviroment.
But since we upgraded to 8 then 8.5 we have not been able to use this table.
I do need a report and not just the licenses we have but how many people are getting in and working tickets at the same time. Our group is growing larger and other company entities are starting to utilize it for their area.
Thanks for your help and suggestions.
Check this stored procedure below
EXECUTE sp_SetupGetProductLicensing (run this stored procedure against 'Symantec_CMDB' database and not for 'ProcessManager' database)