Query To return Number of instances currently runing

[jadoger]

what will be the CE9 Query To return Number of instances currently runing?

many thanks

 

[KingfisherINC]

SELECT SI_NAME,SI_OWNER,SI_STARTTIME,SI_ENDTIME
FROM CI_INFOOBJECTS 
WHERE SI_SCHEDULE_STATUS = 0

Kingfisher [CECP]

 

[fkavanagh]

Where do you run this query? Is this the sql server that the CE is based on.

I only have the basic installation of CE 10 but would like to see this information based on another thread I have started but because I have no SQL Server client software I dont know if I can view it. Can I connect through Toad to this? na dif so do i need to set up some connection.

Hope this is possible it would really open up the application to me.

Thanks a million in advance

Fergal

Crystal Reports 9
Crystal Enterprise 10
Oracle 8.1 (ODBC and native Oracle connection depending on database)
Windows 2000 (Both Desktop and Server)