| Author |
Message |
Andrew
Guest
|
 Posted:
Fri Jan 14, 2005 9:37 pm Post subject:
Flush Reporting Server |
|
|
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB. |
|
| Back to top |
|
 |
Idan
Guest
|
| Posted:
Fri Jan 14, 2005 10:03 pm Post subject:
Flush Reporting Server |
|
|
You can change the Reporting Database grooming by:
From SQL Query Analyzer, run the following
exec p_updategroomdays '<table name to set grooming
on', '<# of days to set grooming to>' - Potential Table
Names for Grooming:
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_EventParameterFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For example:
p_updategroomdays 'SC_AlertFact_Table', '1' (set for 1 date
you can try to put 0 but I didn't checked.
After a day all data will be delete
| Quote: | -----Original Message-----
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB.
.
|
|
|
| Back to top |
|
|
Thomas Olsen
Guest
|
| Posted:
Tue Jan 18, 2005 8:46 am Post subject:
Re: Flush Reporting Server |
|
|
Hi
What are the default groome time for those tables?
Thanks.
Thomas O
"Idan" <idanl@eyron.com> wrote in message
news:175301c4fa52$86edcc10$a601280a@phx.gbl...
| Quote: | You can change the Reporting Database grooming by:
From SQL Query Analyzer, run the following
exec p_updategroomdays '<table name to set grooming
on', '<# of days to set grooming to>' - Potential Table
Names for Grooming:
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_EventParameterFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For example:
p_updategroomdays 'SC_AlertFact_Table', '1' (set for 1 date
you can try to put 0 but I didn't checked.
After a day all data will be delete
-----Original Message-----
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB.
.
|
|
|
| Back to top |
|
|
Bill Hodghead [MSFT]
Guest
|
| Posted:
Tue Jan 18, 2005 11:07 pm Post subject:
Re: Flush Reporting Server |
|
|
All fact tables groom in 395 days (13 months) by default.
"Thomas Olsen" <thomas_olsen44@hotmail.com> wrote in message
news:e4FPqjT$EHA.3120@TK2MSFTNGP12.phx.gbl...
| Quote: | Hi
What are the default groome time for those tables?
Thanks.
Thomas O
"Idan" <idanl@eyron.com> wrote in message
news:175301c4fa52$86edcc10$a601280a@phx.gbl...
You can change the Reporting Database grooming by:
From SQL Query Analyzer, run the following
exec p_updategroomdays '<table name to set grooming
on', '<# of days to set grooming to>' - Potential Table
Names for Grooming:
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_EventParameterFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For example:
p_updategroomdays 'SC_AlertFact_Table', '1' (set for 1 date
you can try to put 0 but I didn't checked.
After a day all data will be delete
-----Original Message-----
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB.
.
|
|
|
| Back to top |
|
|
Thomas Olsen
Guest
|
| Posted:
Fri Jan 21, 2005 5:05 pm Post subject:
Re: Flush Reporting Server |
|
|
OK
So that means if I want to clean out most of the data in the
SystenCenterReporting dB, I can change the recommended table groome time to
lets say 1 day. Then after one day, change it back to 395 days again to
start building a fresh dB from that day.
Is this the correct or possible way of deleting everything in the Reports
dB?
Thanks.
/Thomas O
"Bill Hodghead [MSFT]" <billho@online.microsoft.com> wrote in message
news:Vo-dnRUMiLfd33DcRVn-ug@comcast.com...
| Quote: | All fact tables groom in 395 days (13 months) by default.
"Thomas Olsen" <thomas_olsen44@hotmail.com> wrote in message
news:e4FPqjT$EHA.3120@TK2MSFTNGP12.phx.gbl...
Hi
What are the default groome time for those tables?
Thanks.
Thomas O
"Idan" <idanl@eyron.com> wrote in message
news:175301c4fa52$86edcc10$a601280a@phx.gbl...
You can change the Reporting Database grooming by:
From SQL Query Analyzer, run the following
exec p_updategroomdays '<table name to set grooming
on', '<# of days to set grooming to>' - Potential Table
Names for Grooming:
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_EventParameterFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For example:
p_updategroomdays 'SC_AlertFact_Table', '1' (set for 1 date
you can try to put 0 but I didn't checked.
After a day all data will be delete
-----Original Message-----
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB.
.
|
|
|
| Back to top |
|
|
Bill Hodghead [MSFT]
Guest
|
| Posted:
Sun Jan 23, 2005 12:47 am Post subject:
Re: Flush Reporting Server |
|
|
That works (as does 0 days and running the groom job).
"Thomas Olsen" <thomas_olsen44@hotmail.com> wrote in message
news:uxAGWk6$EHA.2104@TK2MSFTNGP14.phx.gbl...
| Quote: | OK
So that means if I want to clean out most of the data in the
SystenCenterReporting dB, I can change the recommended table groome time
to
lets say 1 day. Then after one day, change it back to 395 days again to
start building a fresh dB from that day.
Is this the correct or possible way of deleting everything in the Reports
dB?
Thanks.
/Thomas O
"Bill Hodghead [MSFT]" <billho@online.microsoft.com> wrote in message
news:Vo-dnRUMiLfd33DcRVn-ug@comcast.com...
All fact tables groom in 395 days (13 months) by default.
"Thomas Olsen" <thomas_olsen44@hotmail.com> wrote in message
news:e4FPqjT$EHA.3120@TK2MSFTNGP12.phx.gbl...
Hi
What are the default groome time for those tables?
Thanks.
Thomas O
"Idan" <idanl@eyron.com> wrote in message
news:175301c4fa52$86edcc10$a601280a@phx.gbl...
You can change the Reporting Database grooming by:
From SQL Query Analyzer, run the following
exec p_updategroomdays '<table name to set grooming
on', '<# of days to set grooming to>' - Potential Table
Names for Grooming:
SC_AlertFact_Table
SC_SampledNumericDataFact_Table
SC_EventParameterFact_Table
SC_AlertToEventFact_Table
SC_EventFact_Table
SC_AlertHistoryFact_Table
For example:
p_updategroomdays 'SC_AlertFact_Table', '1' (set for 1 date
you can try to put 0 but I didn't checked.
After a day all data will be delete
-----Original Message-----
How do i flush out all the data in the MOM reporting DB
(SystemCenterReporting). Not talking about Onepoint DB.
.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in