Where are my Tables???

[moonmonster]

I cant see all of the tables listed in the data dictionary. I am specifically after the iCDNstat table, I only seem to have a CDN table. Is there something wrong with my DSN?? Can you people see the iCDNstat table??

Cheers

 

[PascalHL]

Hi,

yes for sure, there's a ICDNStat view (or table), that you can access (SCCS v4.2 at least).
I would say that the user you do log in with to connect to your Dsn has not the correct rights.
Good way to check that would be for you to connect first with the sysadmin user.
Are you using a specif tool to connect to Odbc/Dsn or using MS Access (for example)?

Regards,
PG

 

[moonmonster]

Sorry for the delay, i had messed my connection to DSN SCCS altogether, have sorted now though.

I am using Crystal reports to use the DSN, i do however get the same list of tables using Excel. I have used the sysadmin account and my own, the tables dont seem to change. I do have a CDN table but it does not contain the timestamp field and other useful info like the iCDNStat table does. Any ideas??

 

[PascalHL]

Hi,

i've difficulties to have Cdn without ICdn table on the display.
What you should try is :
create (or modify, if your user has his own) a new Access Class, enabling it to create and execute any report for :
Reports,Agent Perf, Call by Call, Other (down on the list).

Having been testing it, on my CCS 4.2, those are the only things that may prevent you to see your stat tables (I, H, W, D tables)

Hope it will help

Regards,

PG