Workflow and ServiceDesk Community

Expand all | Collapse all

Report on Servicedesk concurrent licenses in 8.5 -- it did work in version 7

  • 1.  Report on Servicedesk concurrent licenses in 8.5 -- it did work in version 7

    Posted 08-19-2019 01:52 PM

    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.



  • 2.  RE: Report on Servicedesk concurrent licenses in 8.5 -- it did work in version 7

    Trusted Advisor
    Posted 08-19-2019 02:17 PM
    Workflow Explorer SymQ Explorer - AliasExchangeImpl - LBME.ProcessManagerSessions This reads the files in the following folder: \Workflow\Data\ProcessManagerFileStorage\processmanagerfilestorage-lbme.processmanagersessions


  • 3.  RE: Report on Servicedesk concurrent licenses in 8.5 -- it did work in version 7

    Broadcom Employee
    Posted 08-23-2019 05:27 AM

    Check this stored procedure below

    EXECUTE sp_SetupGetProductLicensing (run this stored procedure against 'Symantec_CMDB' database and not for 'ProcessManager' database)

    Thanks,
    IP.