Goal of the website
I need to monitor all the different files on the network. All devices will be Microsoft (Win 10)
• I want a web front end with a graph that will show me a summary of all the different file types within my organisation. (summery of all files .. .pdf 100 | .xls 200 | .doc 300 | .txt 100) bar graph – suggestion ?
Drill down in the data:
• If i click on “for example” .PDF files. It must show me the amount of .pdf’s per computer
o Here the graph will display all computer names and a number of PDF files.
Computer names will change, create a unique identifier of each device by using the C drive serial number and the mac add of computer
Keep history of last 3 computer names
Keep history of last 3 I.P addresses of computer
1. Collector script. (Powershell) i use this because powershell is installed on all devices
a. Identify the local computer with a unique identifier (C Drive serial number + Mac address)
b. This script (powershell) must connect to all computers with a domain username and password
c. Once connected, this script must collect
i. Logged in user
ii. all local files names, and create a MD5 and SHA1 has of each file. These file names + attributes (Date created | date monified + hashof file must be stored in the DB.
iii. Collect the I.P address of the computer
iv. Collect the make and model of each computer if available.
d. All the collected information must be send to a database. “Advise here as to what DB is fast and reliable (maria DB |MySQL |Postgresql ) must be open source
e. Server side – API to store all the relevant data. Script connect to local computer, collect all the data then send the data to the restfull API that will store it inside the DB
Front End website.
1. Website must have a login for each user
2. Main view.
a. Display all files types and the count thereof. This can be in a bar chart
b. Must display the amount of computers inside of the DB that data has been collected for. Next to bar chart (Total computer within the organisation .. 200)
c. When i click on a file type it must show me on what computers this file type is present.
i. Example . i click on .pdf. The user must then see that PDF are present on the following computers and the count thereof.
ii. When i click on the computer, i want to see all the .pdf on that computer (File name | date created | data modified ) logged in user
d. User must be able to search for a file type, and display the computers where this file type is installed on
e. User must be able to upload a hash that has been obtained from external source. This hash must be compared against all hashed within the organisation. If match is found the computer and the file name must be displayed