cancel
Showing results for 
Search instead for 
Did you mean: 

Query Builder help.

BillW
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

BillW
Participant

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

Answers (2)

Answers (2)

rajdeep_marathe
Advisor
Advisor
0 Kudos
former_member193430
Participant
0 Kudos

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)

rajdeep_marathe
Advisor
Advisor
0 Kudos

The above query is correct:

SELECT SI_ID, SI_NAME, si_lastlogontime, SI_CREATION_TIME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER'