Stored Procedure - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Stored Procedure

Author

Topic

kopzen
Starting Member

34 Posts

Posted - 2008-03-14 : 07:20:13

Hi guys

I'm new to both SQL and this forum. I ran an audit on 50 servers using AIDA 32, now I have to create a report but cant create a stored procedure. The report also has to check for any changes on software and hardware. HELP!!, dont know what to do or where to begin.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-14 : 08:01:14

Neither do we, based on the limited information you have given us.

E 12°55'05.25"
N 56°04'39.16"

EugeneLim11
Posting Yak Master

167 Posts

Posted - 2008-03-14 : 09:01:21

Create Procedure [Procedure Name]
AS
BEGIN
.. your store procedure code here ..
END;

kopzen
Starting Member

34 Posts

Posted - 2008-03-17 : 06:28:08

OK here is the cenario:

I ran AIDA32 script with created 3 tables;

dbo.item

28 Report NULL NULL Version AIDA32 v3.93 112 257 4
29 Report NULL NULL Author tamas.miklos@aida32.hu 112 258 4
30 Report NULL NULL Homepage http://www.aida32.hu 116 259 4
31 Report NULL NULL Report Type Report Wizard 91 260 4
32 Report NULL NULL Computer L000007147 46 261 4
33 Report NULL NULL Generator moagikop 47 262 4
34 Report NULL NULL Operating System Microsoft Windows XP Professional 5.1.2600 (WinXP Retail) 38 263 4
35 Report NULL NULL Date 2008-03-17 64 264 4
36 Report NULL NULL Time 11:22 131 265 4
NULL NULL NULL NULL NULL NULL NULL NULL NULL

[size=2]dbo.NextID (which is empty)

and

dbo.report[/size=2]4 AIDA32 v3.93 L000007147 moagikop NOT IMPLEMENTED YET 2008-03-17 11:22 True
NULL NULL NULL NULL NULL NULL NULL

Now I have to create a report that monitors Hard Drive, Memory, dll and ODBC connectuion. The report should notify me if anything changes. AIDA32 is runing weekly.

All I did was get Aida to output the data to a SQL 2005 database and now Im stuck

Please help

kopzen
Starting Member

34 Posts

Posted - 2008-04-22 : 05:43:28

Hi

As I said in my previous post I am using a program called AIDA32 that collects server configurations and populates the data into a database.

Below is a script that I used to create the tables:

[b]--USE aida32;

IF exists(select * from sysobjects where id = object_id('Item') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE Item;

IF exists(select * from sysobjects where id = object_id('Report') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE Report;

IF exists(select * from sysobjects where id = object_id('NextID') and OBJECTPROPERTY(id, 'IsTable') = 1)
DROP TABLE NextID;

CREATE TABLE Report (
ID INT IDENTITY (1,1),
RVersion VARCHAR(255),
RHost VARCHAR(255),
RUser VARCHAR(255),
RLocation VARCHAR(255),
RDateTime VARCHAR(16),
RComplete BIT NOT NULL,

CONSTRAINT cnstR1 PRIMARY KEY(ID)
);

CREATE TABLE Item (
ID INT IDENTITY (1,1),
IPage VARCHAR(100),
IDevice VARCHAR(255),
IGroup VARCHAR(255),
IField VARCHAR(255),
IValue VARCHAR(255),
IIcon INT,
IID INT,
ReportID INT NOT NULL,

CONSTRAINT cnstI1 PRIMARY KEY(ID),
CONSTRAINT cnstI2 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);

CREATE TABLE NextID (
TableName VARCHAR(6) PRIMARY KEY,
NextID INT NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Item', 1);
INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);

I wold like to use Visual Studio to create Reports for my manager. Reports Should check for any hardware or software changes and send an email. All data is stored on a SQL Server2005. For this to happen I need a stored procedure that I can import into Visual stuio.

I have a feeling that the structure of my table is totally wrong if I want this to work.

I am unable to post the output so If you want to see it you can email me on kopano.moagi@vodacom.co.za and I will email it to you.

kopzen
Starting Member

34 Posts

Posted - 2008-04-23 : 12:46:55

Hi Guys

As the forum I posted States, "New to SQL"
Please help me learn so that I can also help others.
Is my post not specific, errelevent or confusing. Please shed some light.

kopzen
Starting Member

34 Posts

Posted - 2008-04-29 : 06:08:45

Besides Visual Studio,

What can I use to generate an automated report that will tell me if anything changed on the tables?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources