Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
A piechart to show how many users login to the system each day
Tim_Hoang_(ASERA01Admin_(Delete)_2490215)
Hi,Is there anyway to generate a piechart to show how many users login to the system each day for a time frame of 30 days?Appreciate for any help
Find more posts tagged with
Comments
Tim_Hoang_(ASERA01Admin_(Delete)_2490215)
I make a mistake, it should be bar chart for "How many users login to the system each month" and I got the solution report as follow:SELECT substr(to_char(DAUDIT.AUDITDATE, 'yyyy mm'), 0, 8), count(distinct(DAUDIT.USERID)) FROM daudit WHERE DAUDIT.EVENT='LOGIN' group by substr(to_char(DAUDIT.AUDITDATE, 'yyyy mm'), 0, 8)8^)
Jonathan_Thomson_(jonathanthomson_-_(deleted))
This works for Oracle based, but what about SQL server?
