I needed a full and detailed list recently of all Igel thin client devices and was disapointed with Igels built in views and reporting options. As with my previous Powershell and SQL scripts I set about getting into the Igel database and pulling the information I required.
This script is fairly “Niché” so I’ve not included my usual list of options and explanations, feel free to request more detail if needed.
This script will pull alot of useful information of the device, from mac address to firmware id and return a full table of contents from your Universal Management Server. as below:
This script only supports trusted connections, so the account you run the script as needs access to the database. If you need to configure non trusted connections, have a look at my Edgesight or SQL backup scripts for inspiration.
The only options you need to configure are the SQL servername and database name, these can be found at the start of the script as below:
The script itself can be found after the jump: