Posts

Showing posts with the label SQL

How to get llama 2 up and running , in a VM, with no GPU, and limited memory on Ubuntu

Image
OK I decided to write this up after unsuccessfully being able to find all the required info I needed in one place. In this setup we will be using Ubuntu Server 22.04.2 LTS as the OS. I have this running on a home lab ESXi server 8, on a HP Compaq Pro 6300 SFF CPU = Intel Core i7-3770 Installed Memory 16 GB I have some 10K SAS drives installed for the VM's If you have not already, navigate to  Get Ubuntu Server | Download | Ubuntu and download the 22.04.2 LTS ISO Next Lets create our VM that we are going to run this in. *Note Im using ESXi however you can probably do this in Workstation, Fusion, VirtualBox etc The main things to note on the VM creation. Set Ubuntu 64 bit as the guest OS Set your CPU relevant to the physicals CPU, I will be starting with 4 VCPU Set your Memory to as much as you can tolerate, I will be using 12 Disk Space - we are creating a 100G swap file, and the rest of the file can take up some room , so more is better if you can afford it Dont forget to add the U

VMware View local \ remote user information

Image
In some instances you may want to get some information on the users that are logging in to the VM's. This is not easily accessible through View its self. So I have come up with a way get the information from the VM's themselves. First of all your going to need the MOF file i created in an earlier post here for the WMI queries. Install this into your parent image. You will also need the logon script , that runs at logon located here . And lastly a remote SQL database that will hold the data, I have taken the liberty of creating a script to create the database for you here. After running trough this, you will be able to query for users that logged in to a specific VM and find any additional information provided by the agent. So lets get started. Create a database with the script Open up Microsoft Management studio and connect to your database server, create a new database, and use the script to create a new table. Paste the contents of the script into a new q

Historical Disk usage with Powershell and SQL

Checking hard drive space gets old, and if you want historical data it was a manual processes, so i created this script i run once a day to update a SQL database, and connect to it from excel to give me a historical data usage on our shared drives. Enjoy.