use master
go
create database ServerCPUUsage
go
use ServerCPUUsage
go
use master
go
sp_addlogin 'cpuusageuser','cpuusageuser','ServerCPUUsage'
go
use ServerCPUUsage
go
sp_adduser cpuusageuser
go
sp_addrolemember 'db_datareader','cpuusageuser'
go
sp_addrolemember 'db_datawriter','cpuusageuser'
go
Create table Servers (id int identity(1,1), ServerName varchar(128))
go
insert into Servers (Servername) select 'SQL'
insert into Servers (Servername) select 'Claire'
insert into Servers (Servername) select 'Stargate'
insert into Servers (Servername) select 'Boomer'
go
Create table ServerCPUInventory
(ServerName varchar(128),
Architecture int,
Caption varchar(256),
Manufacturer varchar(256),
Cpu varchar(10),
CpuStatus int,
CurrentClockSpeed int,
MaxClockSpeed int,
LoadPercentage int,
time_stamp datetime constraint def_timestamp1 default getdate()
)
go
create table CPULoad
(ServerName varchar(128), CPU varchar(10), Loadpercentage int, time_stamp datetime constraint def_timestamp default getdate())


--Architechture
/*
0 x86 
1 MIPS 
2 Alpha 
3 PowerPC 
6 Intel Itanium Processor Family (IPF) 
--CPU Status
0 Unknown 
1 CPU Enabled 
2 CPU Disabled by User via BIOS Setup 
3 CPU Disabled By BIOS (POST Error) 
4 CPU is Idle 
5 Reserved 
6 Reserved 
7 Other 

*/