这是一款网管软件,可以对局域网内的电脑硬件信息进行采集,还可以搜集局域网内所有电脑的文件列表和内容,代码不是拿来就能用的,需要经过本地化修改,建议不懂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
局域网内所有电脑硬件信息和文件的采集
5星 · 超过95%的资源 需积分: 46 62 浏览量
2013-01-02
11:06:31
上传
评论 9
收藏 19KB RAR 举报
至尊宝
- 粉丝: 4
- 资源: 20
最新资源
- STM32单片机FPGA毕设电路原理论文报告汽车电动助力转向单片机控制系统设计与试验研究
- STM32单片机FPGA毕设电路原理论文报告气压传感器神经网络算法及单片机实现
- c++语言大作业,校区人员管理系统framework.zip
- 多目标优化算法集合,包含使用手册
- STM32单片机FPGA毕设电路原理论文报告频率的测量在单片机设计中的应用
- 音频转码工具(用于将微信语音 amr 格式转换为 mp3 格式以便在 html5 的 audio 标签中进行播放).zip
- RDK-Web-Performance-Node
- 网站建设与管理课程设计-酒店管理系统
- STM32单片机FPGA毕设电路原理论文报告片式电容器浪涌及老化测试系统的设计与实现
- 一个简易的贪吃蛇小游戏(C语言作业).zip
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
- 1
- 2
前往页