How to determine who is logged onto TM1 server in PA

Post Reply
Emixam
Posts: 139
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

How to determine who is logged onto TM1 server in PA

Post by Emixam »

Hi,

With the good old Architect, we can simply right click -> Server Manager -> Select Client and see who is connected. For some reason I feel like there is a discrepancy between the users I'm seeing in Architect vs Workspace/Administration.. Am I crazy ? Which one is good ?

Most of our users are only using Pax.

Thanks and have a good day !
User avatar
orlando
Community Contributor
Posts: 167
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: How to determine who is logged onto TM1 server in PA

Post by orlando »

Hi Emixam,

you could use the "good old TM1Top" or you use the "Status" column in the }ClientProperties cube.

Best regards
orlando
User avatar
gtonkin
MVP
Posts: 1198
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: How to determine who is logged onto TM1 server in PA

Post by gtonkin »

You could use the REST API to give you what you need e.g.

Code: Select all

{{protocol}}://{{serverName}}/tm1/api/{{dbName}}/api/v1/Users?$top=5&$filter=IsActive
Using a JSON converter in Excel could also allow you to write the results to a sheet.

Passing a the following will give you sessions and associated threads:

Code: Select all

{{protocol}}://{{serverName}}/tm1/api/{{dbName}}/api/v1/Sessions?$expand=Threads
Above assumes PAOC - tweak for local.
Post Reply