Archived Blackboard Learn discussions

Re: SCRIPTS SQL SERVER 2008

Michael Zimmerman — Mon, 27 Sep 2010 16:32:12 GMT

Jhon,

The emails listed on the Project ASTRO page that I pointed you to on Connections are correct as far as I know. However, I gave you that link on Friday the 24th of September and it's only Monday the 27th, so you have not been waiting for a week, and most of the time you have been waiting is over the weekend when many people are not checking their work emails.

Mike

Re: SCRIPTS SQL SERVER 2008

Jhon Felipe Urrego Mejia — Mon, 27 Sep 2010 15:55:28 GMT

Hello, you confirm me emails where the request is made, because I have more than a week waiting

thanks

Re: SCRIPTS SQL SERVER 2008

Michael Zimmerman — Sat, 25 Sep 2010 14:06:02 GMT

Jhon,

You should get the Project ASTRO .war from the authors. It's not something I can give you.

Mike

Re: SCRIPTS SQL SERVER 2008

Jhon Felipe Urrego Mejia — Sat, 25 Sep 2010 00:08:31 GMT

Thanks, collaborative construction would be interesting, I can start but I have not yet introjected all layout tables and relationships.

Another question, you have the .war file of ASTRO, or should I wait for the response of the request I made today

Re: SCRIPTS SQL SERVER 2008

Michael Zimmerman — Fri, 24 Sep 2010 20:53:55 GMT

Jhon,

I'm afraid I don't have SQL worked out to get the statistics you asked about. However, there are a couple of SQL scripts in the "Snippets" section or Project OSCELOT (http://projects.oscelot.org/gf/snippet/?action=SnippetBrowse&id=1) that retrieve some of the stats you're interested in. I would start with those.

Mike

Re: SCRIPTS SQL SERVER 2008

Jhon Felipe Urrego Mejia — Fri, 24 Sep 2010 18:05:27 GMT

The area of statistics does not offer personalized information, you must have it in sql scripts for customization, and made the request for shipment to the project ASTRO, but you can help me with sql scripts

tnks

Greetings

Re: SCRIPTS SQL SERVER 2008

Michael Zimmerman — Fri, 24 Sep 2010 15:41:56 GMT

Jhon,

You can get most of these statistics from the course statics area of the course in question. Are you looking for something different, or specifically for SQL scripts?

There is a building block called "Project ASTRO" (Advanced Reporting and Tracking) which allows you to gather statics system-wide or for individual courses. You can find out more about it here: http://connections.blackboard.com/posts/3b168675b4

Mike

Re: SCRIPTS SQL SERVER 2008

Jhon Felipe Urrego Mejia — Fri, 24 Sep 2010 15:27:34 GMT

Good morning,

Course Usage
-- User, Course, Application, Usage Counts

User, Course Usage Counts Per Day

User, Course Usage Counts Per Hour

Course Main Content Area
-- Accesses by Content Area per user

Accesses by Content Area per user By Date

Course Group Usage
-- Course Access by Group/User

Course Access by Group by Date

for the moment

tnks

greetings

Re: SCRIPTS SQL SERVER 2008

Michael Zimmerman — Fri, 24 Sep 2010 00:38:11 GMT

Jhon,

What kind of statistics are you trying to extract, specifically?

Mike

SCRIPTS SQL SERVER 2008

Jhon Felipe Urrego Mejia — Thu, 23 Sep 2010 22:15:13 GMT

Good afternoon, from Colombia, I would like to know if anyone has script to sql server 2008, in which statistics can be extracted from several of my courses and users to the version Blackboard Learn 9.1.

Tnks

Greetings