Assignment
Create a database in SQLite using the following create statements
a. Create table system_information (Machine_Name text, Kernel_version text, Product_type text, product_version text, Registered_organization text, registered_owner text, system_root text, processors text, physical_memory text);
b. Create table software_installed (Machine_Name text, software_Installed text);
c. Create table process_list (Machine_Name text, process_name text, pid text);
2. Execute the program psinfo.exe with the following arguments and store the output from each execution in the databases created above.
a. Psinfo.exe -S
b. Pslist
3. Store the information from the psinfo run in the system_information and software_installed table.
4. Store the information from pslist in the process_list table
5. After all 3 database tables have been created and populated then read each table and output the information to a CSV file in the same directory, the files can be named what ever you want them to be but must have the extension of CSV on them.
6. Pass in a variable for the database name to create.
Attachment:- Aassignment-Files.zip