[sims] SIMS - get a list of all reports

[Max_Power]

I'm wondering if there is a way in which you can extract a full list of all the reports that people have generated within SIMS over the years that all users can see?

 

If you go to reports - run report - focus you have a full list of all the reports made under the various topics e.g. Students, or contacts etc.

 

Secondly is there a way to extract a list of all the reports individuals have generated for themselves only that only they can see?

 

Cheers

[matt40k]

Contact Capita, they have a DBDiag script you can run to get this info out.

[Banjo]

This is a good starting point. You can drop the results into a text file on the sql server.

 

SELECT Left(report_name, 40), Left(report_description, 40), Left(last_updated, 12) FROM sims.sims.rpt_report_summary order by last_updated DESC

 

It looks like this, but you can add other fields from the table to it.

 

Result Sets: Imported Mar 14 2017

Templates: by Supplier Mar 14 2017

Result Sets: All Mar 14 2017

Registration Groups (Dated Gender Sort) Mar 14 2017

Aspects: by Category Mar 14 2017

Aspects: No Results Mar 14 2017

Set to Receive Pupil Report (Labels) Mar 14 2017

Grade Sets: No Aspects Mar 14 2017

Grade Sets: User Defined Mar 14 2017

SEN - Assessment Mar 14 2017

Population Analysis (Dated) Mar 14 2017

Templates: by Category Mar 14 2017

Home Language Not English Mar 14 2017

Data Collection Sheet (font 12) Mar 14 2017

Population Analysis (All Year Groups) Mar 14 2017

Data Collection Sheet Mar 14 2017

OMR Templates: by Module Mar 14 2017

Grade Sets: by Supplier Mar 14 2017

Categories: by Type Mar 14 2017

Marksheets: Complete Flag Mar 14 2017

Aspects: by Module Mar 14 2017

Detention Non Attendance Report Mar 14 2017

ST Definition Mar 14 2017

SEN - Reviews Due Mar 14 2017

Avery labels J8160 - Address Mar 14 2017

SEF B4.1 - Exclusions Mar 14 2017

SEF B2.14 - Leavers Mobility Mar 14 2017

Ethnic / Cultural Analysis Mar 14 2017

Edited September 28, 2017 by Banjo

[Max_Power]

Asked SIMS for the DBDiag script and they said it doesnt exist, and what i want isnt possible but I should put it forward for a change request as other schools may find it useful.

 

Do you have a copy of the script @matt40k ?

 

Is that output you have @Banjo via the script mentioned?

[rpwillis]

Previous thread Edited October 10, 2017 by rpwillis
Better link text

[Banjo]

Asked SIMS for the DBDiag script and they said it doesnt exist, and what i want isnt possible but I should put it forward for a change request as other schools may find it useful.

 

Do you have a copy of the script @matt40k ?

 

Is that output you have @Banjo via the script mentioned?

 

Yes, you can pull other fields from the table, but those are the most useful.

[matt40k]

I think using the SalamanderSoft tool would be better - it means you don't have to ask Capita to go digging out a old dbdiag script and you're not bypassing the SIMS permissions by running SQL directly...