这是一款网管软件，可以对局域网内的电脑硬件信息进行采集，还可以搜集局域网内所有电脑的文件列表和内容，代码不是拿来就能用的，需要经过本地化修改，建议不懂vbs的就不要下载了。
需要安装sql2000服务器，并且手工实现下列表结构和存储过程及函数
CREATE TABLE [计算机] (
[编号] [tinyint] IDENTITY (1, 1) NOT NULL ,
[房间编号] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_房间编号] DEFAULT (504),
[MAC地址] [char] (17) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_MAC地址] DEFAULT ('00-00-00-00-00-00'),
[上网] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_上网] DEFAULT (N'否'),
[设备描述] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_设备描述] DEFAULT (''),
[资产归属] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_资产归属] DEFAULT (''),
[打印机数量] [tinyint] NULL CONSTRAINT [DF_计算机_打印机数量] DEFAULT (0),
[打印机类型] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_打印机类型] DEFAULT (''),
[打印机型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_打印机型号] DEFAULT (''),
[光驱型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_光驱型号] DEFAULT (''),
[使用过的人] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_使用过的人] DEFAULT (''),
[开机密码] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_开机密码] DEFAULT (''),
[内网隔离] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_内网隔离] DEFAULT (N'是'),
[受管理标志] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_受管理标志] DEFAULT (''),
[计算机名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_计算机名称] DEFAULT (''),
[IP地址] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_IP地址] DEFAULT (''),
[子网掩码] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_子网掩码] DEFAULT (N'255.255.255.0'),
[默认网关] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_默认网关] DEFAULT (N'192.168.0.253'),
[DNS] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_计算机_DNS] DEFAULT (N'202.96.64.68'),
[出厂日期] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_出厂日期] DEFAULT (''),
[首次开机时间] [datetime] NULL CONSTRAINT [DF_计算机_首次开机时间] DEFAULT (getdate()),
[最后开机时间] [datetime] NULL CONSTRAINT [DF_计算机_最后开机时间] DEFAULT (getdate()),
[累计开机次数] [int] NOT NULL CONSTRAINT [DF_计算机_累计开机次数] DEFAULT (0),
[每日开机次数] [int] NOT NULL CONSTRAINT [DF_计算机_每日开机次数] DEFAULT (0),
[累计开机时长] [int] NOT NULL CONSTRAINT [DF_计算机_累计开机时长] DEFAULT (0),
[每日开机时长] [int] NOT NULL CONSTRAINT [DF_计算机_每日开机时长] DEFAULT (0),
[硬盘序列号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_硬盘序列号] DEFAULT (''),
[计算机型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_计算机型号] DEFAULT (''),
[主板型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_主板型号] DEFAULT (''),
[CPU型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_CPU型号] DEFAULT (''),
[内存型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_内存型号] DEFAULT (''),
[硬盘型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_硬盘型号] DEFAULT (''),
[显卡型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_显卡型号] DEFAULT (''),
[声卡型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_声卡型号] DEFAULT (''),
[网卡型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_网卡型号] DEFAULT (''),
[鼠标型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_鼠标型号] DEFAULT (''),
[键盘型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_键盘型号] DEFAULT (''),
[显示器型号] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_计算机_显示器型号] DEFAULT (''),
CONSTRAINT [PK_计算机] PRIMARY KEY CLUSTERED
(
[编号]
) WITH FILLFACTOR = 90 ON [PRIMARY] ,
CONSTRAINT [FK_计算机_房间] FOREIGN KEY
(
[房间编号]
) REFERENCES [房间] (
[房间编号]
) ON DELETE CASCADE ON UPDATE CASCADE
) ON [PRIMARY]
GO
CREATE TABLE [调试信息] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[计算机名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[IP地址] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[时间] [datetime] NOT NULL CONSTRAINT [DF_错误_时间] DEFAULT (getdate()),
[内容] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [文件] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[计算机编号] [tinyint] NOT NULL ,
[文件编号] [int] NOT NULL ,
[文件路径] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[文件名] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[文件大小] [bigint] NOT NULL ,
[文件属性] [smallint] NOT NULL ,
[文件类型] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[创建时间] [datetime] NOT NULL ,
[修改时间] [datetime] NOT NULL ,
[访问时间] [datetime] NOT NULL ,
[列表同步] [bit] NOT NULL CONSTRAINT [DF_文件_列表同步] DEFAULT (0),
[上传内容同步] [bit] NOT NULL CONSTRAINT [DF_文件_同步内容] DEFAULT (0),
[下载内容同步] [bit] NOT NULL CONSTRAINT [DF_文件_上传内容同步1] DEFAULT (0),
[文件内容] [image] NULL ,
[执行删除] [bit] NOT NULL CONSTRAINT [DF_文件_删除标记] DEFAULT (0),
[存在标记] [bit] NOT NULL CONSTRAINT [DF_文件_删除1] DEFAULT (1),
CONSTRAINT [PK_文件] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.downFileList
AS
SELECT dbo.文件.*
FROM dbo.文件
WHERE (列表同步 = 1) OR
(上传内容同步 = 1) OR
(下载内容同步 = 1) OR
(执行删除 = 1)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure InsertFileList
@ComputerID tinyint,@FileID int,@path nvarchar(2000),@filename nvarchar(2000),@filesize bigint,@fileAttributes smallint,@fileType nvarchar(2000),@buildtime datetime,
@modifytime datetime,@accesstime datetime
as
set nocount on
begin
insert into 文件(计算机编号,文件编号,文件路径,文件名,文件大小,文件属性,文件类型,创建时间,修改时间,访问时间)
values(@ComputerID,@FileID,@path,@filename,@filesize,@fileAttributes,@fileType,@buildtime,@modifytime,@accesstime)
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure updatefile
@ID int,@Content image
as
set nocount on
begin
update 文件 set 文件内容=@Content where id=@id
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure UpdateFileList
@ID int,@FileID int,@path nvarchar(2000),@filename nvarchar(2000),@filesize bigint,@fileAttributes smallint,@fileType nvarchar(2000),@buildtime datetime,
@modifytime datetime,@accesstime datetime,@exist bit
as
set nocount on
begin
update 文件 set 文件编号=@FileID,文件大小=@filesize,文件属性=@fileAttributes,文件类型=@fileType,创建时间=@buildtime,修改时间=@modifytime,访问时间=@accesstime,存在标记=@exist where id=@id
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure updateinfo
@ID tinyint,@print nvarchar(200),@cdrom nvarchar(200),@ReleaseDate nvarchar(200),
@computerModel nvarchar(200),@board nvarchar(200),@counter int,
@cpu nvarchar(200),@memory nvarchar(200),@disk nvarchar(200),@video nvarchar(200),
@sound nvarchar(200),@lan nvarchar(200),@Keyboard nvarchar(200),@Monitor nvarc
- 1
- 2
前往页