Skillset by CDN report

[pdulfo]

I have a setup whereby we have 3 CDNs that allow you to get to multiple skillsets. Due to the configuration of the system you can get to some of the skillsets from multiple CDNs.

I am trying to create a report that will show the number of times a skillset is arrived at via a particular CDN.

Can anybody point me in the right direction. Oh BTW i use crystal.




---------------------------------
PDulfo aka pdiddy

 

[ErwinStevanus]

As far as I know, there is no link between cdn table and skillset table. Thus, you can't link the 2 tables together.

However, what I normally do is to point every cdn to different application. This way, each cdn has a unique application associated with it.

The next step is easy, you can get some of the statistics from standard report (the skillset by application report). Or if you need to get some information which is not in the standard report, you can link the skillset table and application table and write your own report.

Hope this help.

Erwin