I am looking for a powershell script that pulls from a text file that contains server names(targets)c:\server.txt, I would like it to build an Excel file that shows:
a. Count of CPU’s
b. # of cores
3. OS Name
4. OS Version
5. OS Service Pack
7. MAC Address
8. BIOS version (not a must but would be nice)
9. Local Hard Drive(s) – no cd/dvd or mapped drives.
a. Hard Drives capacity
b. Hard Drives Remaining Space
10. Last Reboot Time
11. Check to see if server has SQL Server Installed and Running
a. What version of SQL server
12. Stamp the Excel File with current time of report
I am new to Powershell, I do have Quest's Plugin "Active Roles Management Shell for Active Directory" installed . Don't think that's needed here since no AD calls needed, as far as I know anyway.