Re: FW: How to know when a table is full ??

[Axton]

I wrote something similar, but it only works on Oracle.  It collects
storage/row count stats on a daily basis, then calcs the rate of
change in row count and bytes for a series of periods (daily, weekly,
monthly, quarterly, and yearly).  I will find out if I can share it if
you are interested.

Axton Grams

On Fri, Apr 18, 2008 at 1:39 PM, Heider, Stephen [EMAIL PROTECTED] wrote:
 **



 Tadeu,



 If you are using a version of SQL Server you could use the attached script
 to create a SQL View, then create an ARS View form for the SQL View.  Here
 is how my screen looks:







 HTH



 Stephen

 Remedy Skilled Professional



 -Original Message-
  From: Action Request System discussion list(ARSList)
 [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
  Sent: Monday, April 07, 2008 10:34 AM
  To: arslist@ARSLIST.ORG
  Subject: RES: How to know when a table is full ??



 Hi John,



 Thanks for your reply...



 But I would like to create this in a AR Sytem Form... (like Alert Events, AR
 System Email Messages)



 Could I create new Fields in these kind of forms without any worry about
 modify AR System Forms???





 Att,



 Tadeu Augusto Dutra Pinto __Platinum Sponsor: www.rmsportal.com ARSlist:
 Where the Answers Are html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
attachment: dbstorage.gif

FW: How to know when a table is full ??

[Heider, Stephen]

Tadeu,

 

If you are using a version of SQL Server you could use the attached
script to create a SQL View, then create an ARS View form for the SQL
View.  Here is how my screen looks:

 

 

 

HTH

 

Stephen

Remedy Skilled Professional

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto
Sent: Monday, April 07, 2008 10:34 AM
To: arslist@ARSLIST.ORG
Subject: RES: How to know when a table is full ??

 

Hi John,

 

Thanks for your reply...

 

But I would like to create this in a AR Sytem Form... (like Alert
Events, AR System Email Messages)

 

Could I create new Fields in these kind of forms without any worry about
modify AR System Forms???

 

 

Att,

 

Tadeu Augusto Dutra Pinto


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
image001.pngCREATE VIEW dbo.udv_ARS_FormRowCounts
AS

SELECT  a.schemaId, b.Name FormName, CONVERT(VARCHAR,a.TableName) TableName, 
a.TotalRows, CHECKSUM(a.TableName) RequestID 
FROM(SELECT so.Name TableName, MAX(si.rows) TotalRows,
CASE ISNUMERIC(SUBSTRING(so.Name, 2, 99)) 
WHEN 1 THEN SUBSTRING(so.Name, 2, 99) 
ELSE 
CASE ISNUMERIC(SUBSTRING(so.Name, 3, 
1)) 
WHEN 0 THEN SUBSTRING(so.Name, 2, 1) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 4, 1)) 
WHEN 0 THEN SUBSTRING(so.Name, 
2, 2) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 5, 1)) 
WHEN 0 THEN 
SUBSTRING(so.Name, 2, 3) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 6, 1)) 
WHEN 0 THEN 
SUBSTRING(so.Name, 2, 4) 
ELSE 
CASE 
ISNUMERIC(SUBSTRING(so.Name, 7, 1)) 
WHEN 0 
THEN SUBSTRING(so.Name, 2, 5) 
ELSE 

CASE ISNUMERIC(SUBSTRING(so.Name, 8, 1)) 

WHEN 0 THEN SUBSTRING(so.Name, 2, 6) 

END
END
END
END
END
END
END schemaId
FROMsysobjects so
JOINsysindexes si
ON  si.id = OBJECT_ID(so.name)
WHERE   so.xtype = 'U'
AND LEFT(so.Name,1) IN ('T','B','H')
AND ISNUMERIC(SUBSTRING(so.Name,2,1)) = 1
GROUP BY so.Name) a
JOINarSchema b
ON  a.schemaId = b.schemaId