Powered by Jitbit .Net Forum free trial version. dismiss

HomeGeneral

General issues

About TekRadius report.. Messages in this topic - RSS

MHE
MHE
Posts: 12


7.02.2018
MHE
MHE
Posts: 12
Hi,

I need to get all users last logon date, for cleaning up old users , how can I get that report...

With best regards.
0 link
Admin
Admin
Administrator
Posts: 4876


7.02.2018
Admin
Admin
Administrator
Posts: 4876
Try this;

select username, [timestamp] from accounting as a1 where [timestamp] = (select max([timestamp]) from accounting as a2 where a1.username = a2.username) order by username
0 link
MHE
MHE
Posts: 12


7.02.2018
MHE
MHE
Posts: 12
Hi Mr.
Yasin many thanks for your info, should I use this on SQL server query ? I am using TekRadius Manager LT5.3
or on Manger Reporting Tab ?
With best regards.
0 link
Admin
Admin
Administrator
Posts: 4876


7.02.2018
Admin
Admin
Administrator
Posts: 4876
There is not a built-in template for such a report so you should get it directly querying the accounting table.
0 link
MHE
MHE
Posts: 12


14.03.2018
MHE
MHE
Posts: 12
Hi Mr. Yasin,

When I started to run that query you sended;
select username, [timestamp] from accounting as a1 where [timestamp] = (select max([timestamp]) from accounting as a2 where a1.username = a2.username) order by username


I can' t see any result, I use TekRaDIUS LT, and I started that query on SQLLİteStuid v3.1.1


Please halpe me when avail please.


Best Regards.

0 link
Admin
Admin
Administrator
Posts: 4876


14.03.2018
Admin
Admin
Administrator
Posts: 4876
For SQLite please try

select username, [timestamp] from accounting as a1 where strftime('%s', [TimeStamp]) = (select max(strftime('%s', [TimeStamp])) from accounting as a2 where a1.username = a2.username) order by username
0 link
MHE
MHE
Posts: 12


14.03.2018
MHE
MHE
Posts: 12
Hello Mr. Yasin Many thanks foru your helps, bu t I am not a SQL man upset
I should trying some thing wrong I think?

Result is blank screen;
select username, [timestamp] from accounting as a1 where strftime('%s', [TimeStamp]) = (select max(strftime('%s', [TimeStamp])) from accounting as a2 where a1.username = a2.username) order by username

With this query, I am using MAB authenticaiton so as documentation I swithced Accounting Table, UserName to Call,ng-Station-Id
İs this makes any wrong thing?

Best regards.
0 link
Admin
Admin
Administrator
Posts: 4876


14.03.2018
Admin
Admin
Administrator
Posts: 4876
Please run SQLiteStudio as Administrator, open TekRADIUSLT.db3 and run the query again.
0 link
MHE
MHE
Posts: 12


15.03.2018
MHE
MHE
Posts: 12
Morning Mr. Yasin,
I see nothing.

Best Regards.
0 link
Admin
Admin
Administrator
Posts: 4876


15.03.2018
Admin
Admin
Administrator
Posts: 4876
Can you zip and send TekRADIUSLT.db3 to yasin.kaplan at kaplansoft.com?
0 link
MHE
MHE
Posts: 12


24.04.2018
MHE
MHE
Posts: 12
Hi Mr. Yasin,

On TekRadius Server side, I checked "Accounting Enabled" and on switch side these command executed;

aaa accounting network default start-stop group radius

But on server we can' t get info with this query;
select username, [timestamp] from accounting as a1 where strftime('%s', [TimeStamp]) = (select max(strftime('%s', [TimeStamp])) from accounting as a2 where a1.username = a2.username) order by username
Best regards.
0 link
Admin
Admin
Administrator
Posts: 4876


24.04.2018
Admin
Admin
Administrator
Posts: 4876
Can you upgrade to the latest version of TekRADIUS? Latest version has a new tab called SQL to run these queries.
0 link
MHE
MHE
Posts: 12


18.06.2018
MHE
MHE
Posts: 12
Hi Mr. Yasin,

I upgraded to new version 5.4.3.0 due to new fearture like sql query.
And I runned followed query but query did not reurned any result? could you please help me to get, last logon date.
select username, [timestamp] from accounting as a1 where strftime('%s', [TimeStamp]) = (select max(strftime('%s', [TimeStamp])) from accounting as a2 where a1.username = a2.username) order by username

BR
0 link
Admin
Admin
Administrator
Posts: 4876


19.06.2018
Admin
Admin
Administrator
Posts: 4876
Hi,

What do you get for the following SQL statement?

select Count(*) from accounting

Best regards,

Yasin KAPLAN
0 link
MHE
MHE
Posts: 12


19.06.2018
MHE
MHE
Posts: 12
Morning,

Result is, 0

Best regards.
0 link
Admin
Admin
Administrator
Posts: 4876


19.06.2018
Admin
Admin
Administrator
Posts: 4876
This means you do not have any accounting record in your accounting table. Please make sure that Accounting is enabled both in TekRADIUS and your access servers.
0 link
MHE
MHE
Posts: 12


19.06.2018
MHE
MHE
Posts: 12
Hello again Mr. Yasin,

TekRadius accounting enable meaning, I thik enabled, on TekRadius tools from Setting\"Accounting Enabled | Port" I cliecked check box is that right?

Best Regards.
0 link
Admin
Admin
Administrator
Posts: 4876


19.06.2018
Admin
Admin
Administrator
Posts: 4876
Exactly. Please also check NAS parameters for RADIUS Accounting .
0 link
MHE
MHE
Posts: 12


19.06.2018
MHE
MHE
Posts: 12
Now all done Mr. Yasin many thanks for all helps.
0 link
Admin
Admin
Administrator
Posts: 4876


19.06.2018
Admin
Admin
Administrator
Posts: 4876
You welcome
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software