Click here to Skip to main content
15,894,265 members
Articles / Programming Languages / Visual Basic

File Server Viewer

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
9 Nov 2011GPL32 min read 17.2K   587   9  
Views records from File Server Audit program
SQL Setup
	*MySQL Database setup:
		CREATE DATABASE FilesServer;
	    Use FilesServer;

		CREATE TABLE FileAudit (
					ID	INT(100) UNSIGNED AUTO_INCREMENT PRIMARY KEY,	
					FolderPath				LONGTEXT,
					AccountSAMAccountName	LONGTEXT,
					GroupSAMAccountName		LONGTEXT,
					ManagedBy				LONGTEXT,
					Inheritance				LONGTEXT,
					IsInherited				LONGTEXT,
					Rights					LONGTEXT,
					Owner					LONGTEXT,
					Computer				LONGTEXT,
					RunDate					bigint
		)
	*MS SQL Database setup:
		CREATE DATABASE FilesServer;
	    Use FilesServer;

		CREATE TABLE FileAudit (
					ID	INT(100) UNSIGNED AUTO_INCREMENT PRIMARY KEY,	
					FolderPath				nvarchar(MAX),
					AccountSAMAccountName	nvarchar(MAX),
					GroupSAMAccountName		nvarchar(MAX),
					ManagedBy				nvarchar(MAX),
					Inheritance				nvarchar(MAX),
					IsInherited				nvarchar(MAX),
					Rights					nvarchar(MAX),
					Owner					nvarchar(MAX),
					Computer				nvarchar(MAX),
					RunDate					bigint
		)

Version 1.1.0
	*Added support for MySql
	*Added Computer selection
	*Added DropDown on Click
	*.Net 4.5	
Version 1.0.0
	*Reads from MSSQL with table layout of:
		Table Name: FileAudit
			Column Name				Data Type
			ID						int
			FolderPath				nvarchar(MAX)
			AccountSAMAccountName	nvarchar(MAX)
			GroupSAMAccountName		nvarchar(MAX)
			ManagedBy				nvarchar(MAX)
			Inheritance				nvarchar(MAX)
			Rights					nvarchar(MAX)
			Owner					nvarchar(MAX)
			RunDate					bigint
			IsInherited		varchar(50)

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The GNU General Public License (GPLv3)


Written By
Systems / Hardware Administrator
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions