Red Gate forums :: View topic - Custom report againt the RedGate database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Custom report againt the RedGate database

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cjvjr75



Joined: 08 Nov 2011
Posts: 2

PostPosted: Tue Nov 08, 2011 2:41 pm    Post subject: Custom report againt the RedGate database Reply with quote

Hi,
I like to SSRS pack that is available on the Red Gate site.
However, we would like to create some custom reports.
The data is in the Red Gate database, but to find out what tables, views etc to use is quite a job. Is there perhaps some documentation about the database model?

In short, we would like to create a report for our application administrators to let them see the database settings (autogrowth etc) how large their database is, how fast it grew in a given period.

greetings,

Kick Vieleers
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Tue Nov 08, 2011 6:27 pm    Post subject: Reply with quote

Hi Kick,

Unfortunately, we haven't published database model yet. But this is something we do plan to do in near future. For now, feel free to ask us question and we will try our best to help if we can.

Whenever you write reports, it is best to access via views. The data you are looking can be found in this view data.Cluster_SqlServer_Database_File_StableSamples_View.

If you look at the database closely, it might be self explanatory. E.g. if you are after machine specific data then it can be found under:
data.Cluster_Machine_*

Similarly, SQL Server specific data can be found under:
data.Cluster_SqlServer_*

Database specific data under:
data.Cluster_SqlServer_Database_* and so on.

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group