Logon History - Table

[yelyah.nodrog]

Afternoon,

Where can I find the logon history table in Database direct? 

The Logon History in the admin console under security does have enough filters/features so would like to filter it further in Database Direct

H

[Steve Giller]

What additional filtering are you looking for?

It's probably more sensible to ask to have them added to the UI than to resort to digging around in Database Direct.

[Jim]

This is a very raw report we run that may get you started

analyst-sign-in-logs.report.txt

[yelyah.nodrog]

I would like to filter by date, So to see who has logged on for example in the last month, 2 months, 3 months to get a feel of how many full users we have logged on concurrently.
I would also like to export this information.

[Jim]

You'll definitely need to adjust the filters on that mind

[yelyah.nodrog]

@Jim Thanks this is just what I needed to get started

H

[Gerry]

@Jim @yelyah.nodrog

I just wanted to make a comment here.  Any database table with the h_sys_* prefix is subject to change at any time.  That means you cannot rely on any report you run against those tables to work moving forwards.  I appreciate as of today the Hornbill platform through system reporting capabilities allows you to peer into pretty much any part of the database, so you are of course free to do this, its your instance and your data.  However, should these tables change as things evolve, and should the platform change in the future to better secure the system for multi-tenant use, you may will find this sort of report will no longer work. 

With that in mind then, the better question for use to ask is, what are you trying to get/filter by, perhaps if we understand the requirement, we would stand a chance of providing you that facility instead, which would be more convenient for you, and far more supportable by us?

Gerry