
Build a desktop PowerShell tool to gather server information, configure settings, and export results via email, with a downloadable executable for portability.
This video helps you familiarize yourself with building a Virtual Machine using VMWare player and Windows binaries.
This Lecture explains on the installation of servers named VM2 and CENTRAL SERVER using VMWare Workstation Player. CENTRAL SERVER is going to be the domain controller server too for spinning up the domain for the servers VM1 and VM2.
This lecture explains how to convert a server to a domain controller and set up a domain with it. Once the domain controller is set up, we will discuss on joining the other servers to the domain just built.
This is the last lecture of the first section to set up a lab for your automation purpose.
In this lecture, it explains
- how to set up the static IP for the servers and join the servers to the domain.
- how to create a domain user having access to all the servers in domain.
Build a base PowerShell form by creating a System.Windows.Forms form, adding labels, textboxes, dropdowns, and buttons, and configuring size, start position, and keydown actions before showing the form.
Create a basic desktop form in PowerShell by instantiating a form object, setting size, start position, icon, and background image, then display it with show dialog.
Explore how textboxes capture inputs like names and locations in a Windows desktop PowerShell app, with a live demo on adding textboxes to a form.
Configure text boxes on the main form by creating new objects, setting location and size, and adding labels and controls for the form and log folder.
Add and position five buttons on a form—browse, submit, cancel, exit, and configure—alongside labels and text boxes, and prepare the actions for server list selection and email settings.
Learn to create and configure a combo box in a Windows PowerShell desktop application, including object creation, setting location and size, populating the dropdown, and adding it to the form.
Explain button actions in a PowerShell app: close forms with cancel or exit, browse to load a file, parse server names, and populate a text box with comma separated values.
Learn how a PowerShell tool checks C drive free space across multiple servers by selecting the option, running a function, and displaying results in a grid.
Save and edit mail configuration details in an Excel file and an XML file using a mail form, including SMTP port, username, and password, with update flows.
Create a menu strip and add tool strip menu items, including dropdown items like configure email, assign shortcuts, and wire click actions on the main form.
Add multiple menu items to the menu strip and base menu, including an exit item. Wire email configuration to the C drive free space check outputs and related tools.
Create a function named Send Me that captures the assembly details and sends email with the drive free space output as an attachment, using an XML file for mail config.
Execute a PowerShell ping test on servers with Win32_PingStatus, interpret a zero status as health, log results to check_ping.txt, and display in a grid view.
Use a PowerShell function to retrieve the last reboot time from servers, log results to a text file, and format readable uptime using Win32 operating system data.
Identify local admins on multiple servers using a PowerShell tool that queries directory services, filters by computer, and lists members of the administrators group for troubleshooting.
Illustrates using if, else, and elseif in PowerShell to perform conditional logic, compare values (including greater than), and act on service counts.
Check SQL server running status across multiple servers with a single click using PowerShell, by querying Win32_Service and formatting results into a labeled table.
PowerShell function checks SQL Server Agent job status and retrieves job details via SQL Server Management Objects, builds connection strings, and outputs the results in HTML.
Explore how to identify SQL Server sysadmins across multiple servers with PowerShell, list server instances and port numbers, and query sysadmin data for export to CSV or email.
Learn to connect to a SQL Server with PowerShell, run queries using Invoke-Sqlcmd, and export results to HTML with credentials, timeouts, and formatting options.
I don't know JAVA,
I don't know VB scripting ,
I don't know any development languages
I cannot buy any third party application for development
I am not a programmer
I ONLY KNOW POWERSHELL
YET I need to create a desktop application.
Can I? Answer is a Yes .You just need to have Powershell basics in mind.
C'mon , let us start.from SCRATCH.
What we cover :-
1. Create forms using powershell.
2. Create textboxes , dropdownboxes, buttons, datagridviews using powershell.
3. A mail configuration Tool
4. Create Menustrip
5. Explain the below functionalities used in the Server Checker Tool like
1. SQL Server Running Status
2. D drive Free space
3. C drive Free space
4. Check ping status of servers
5. Check jobs in this server
6. Last Reboot Time of the server(s)
7. SysAdmins of SQL server in server(s)
8. Portnumber of instances in this server
9. Local Admins of server(s)
6. Converting the script to an executable standalone desktop application.
7. How the Server Status Checker application is made using the above features of powershell.
Doubt clearance support over email.
Optional videos from my other Udemy Course that are relevant for understanding this video like the below videos.
- How to set up a personnel Lab
- Basic powershell videos describing if-else, foreach etc loops that are required for this course.
- sendmail functionality
Multiple Quizzes and Assignments along side.