Database field which stores which view user in (Smart view/Classic view)

Subfolder · 2021-10-06T19:29:14+00:00

There was an error rendering this rich post.

I am looking to create report to see how many users are in smart view in the organization, so required to know which field in the database stores which model/view user is in.

If anyone knows please let me know.

Find more posts tagged with

Comments

Appu Nair

You are looking probably for info in KUAF table where Type=0 and Deleted=0

You need to put this in a Live Report
You need to get a WR to execute the LR and beautify it ( this is what the SmartUI user will see)

Then you add this WR in a CI HTML WR Widget

That will do the trick

So reading on livelink , it’s subtypes , it’s tables will get you going

Practice with Classic and Progress to SmartUI

Subfolder

Hi Appu,

Thank you for response.

I am actually looking for users who is using SmartUI and how many are using Classic view in report.

For that want to know which field in the database stores this information.

Appu Nair

H'mm a "usability" report. Not sure if there is one but if I was asked to do this I would probably go by some assumptions which are mostly true

Indicator of a user accessing Smart Vs Classic, I would probably go by everything SmartUI will be prefixed by cs.exe/app the other one will be cs.exe?

Does Livelink have this info perhaps yes? Run SummaryTimings logs get them into a database or pay for a Splunk service or something similar as the logs are csv format. In fact, OT has a Splunk project they have somewhere that customers can use. I have no idea but I have seen Splunk people show that data . Similar information sometimes is used at the webserver/application server as that is the first place a request comes.

You might also ask OT through a support ticket as sometimes OT builds usage tables without telling people clearly how it is used. It is used as "audit" by OT to ascertain if an organization is flouting licenses et al.Most of these kinds of reports are stored in OTDS as its logs.

If no prior information is needed perhaps an Oscript callback can be probably be written based on the loginhookcallback and you could write the request parameters to your database table to get this data more easily.

those are what my thoughts are :)

Appu Nair

I just thought of the false positives as well. As you know SmartUI is a SPA which means the JS structure in your Browser(device) is firing REST API calls which take the form of cs.exe/api/v<nn> (well cs.exe it can be llisapi.dll cs,livelink,livelink.exe and so on) which means that when John Doe is accessing a Workspace and a perspective is applied it will execute whatever the REST API behind the perspective says (say 5-10 calls)so I am not sure if that adds any relevance. I just thought about it see where you can use it.