ContributionsMost RecentMost LikesSolutionsRe: Display Current Login User This should do it: SELECT ula.[UserName] ,u.[email] ,ula.[AppName] ,ula.[LogonTime] ,ula.[LastActivityTime] FROM [UserLogonActivity] ula join SecUser su on su.name=ula.UserName where ula.Lo...Re: Display Current Login User Hi NSHAIK2 You can create a dashboard data adapter that runs the query below against the Framework database: SELECT [UserName] ,[AppName] ,[LogonTime] ,[LastActivityTime] FROM [UserLogonAct...Re: Can we copy OS internal table data to external DB using SIC? Hi jkim, I just did that today. I'm not using the Remote BR, which probably explains the poor performances! But it's a first step: ' my own function that creates an insert statement string from a...Re: SIC gateway connection to export OS table to SQL server I tried with SaveCustomDataTable and received a message saying it is not compatible with SIC. So for now, my best answer is with the insert statement which will only work with a small number of recor...Re: SIC gateway connection to export OS table to SQL server Hi zwc Here is the code I use and it works: Using dbConn As DbConnInfo = BRApi.Database.CreateDbConnInfo(si, DbLocation.External,"[[your SIC Connection name]]") '.CreateCustomExternalDbConnInfo(...List of unused security user groups Hello all, Asking for a client: they've been live for several years and they would like to perform a clean up of their security user groups. They need to obtain a list of the groups that exist in O...Re: List of unused security user groups Thanks Jack and sorry for the late answer. I didn't know we had the schema fully documented in there so I'll take a look. I took a quick look at the DB from the SQL Server client and I know for sure ...
