on 12-11-2015 7:14 PM
Hi All,
I'm trying to figure out what users aren't using the system. So I can remove users that aren't. So I thought I'd use Query Builder to get this information.
Here is the query I'm trying to use.
select si_name, SI_CREATION_TIME,
si_lastlogontime from ci_systemobjects where si_kind = ‘user’ and
(si_lastlogontime > ’2014.11.01.04.59.59′ or SI_CREATION_TIME >
’2015.04.01.04.59.59′ )
It comes back with this.There was an error retrieving data from the server: Not a valid query. (FWB 00025)
I've tried it many ways and it still fails.
Any suggestions arte much appreciated.
Thanks,
BW
I got it figured out. If nyone else needs this type of information.
SELECT
SI_ID, SI_NAME, si_lastlogontime, SI_CREATION_TIME
FROM
CI_SYSTEMOBJECTS
WHERE
SI_KIND = 'USER'
Thanks,
BW
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bill, i tried to use your query and end up getting this errror.
There was an error retrieving data from the server: Not a valid query (FWB 00025)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.