Is it possible to make a script that pulls info from IIS from a number of servers and neatly / in a formatted fashion populates an excel spreadsheet. I'm no expert on PS and I've created a small script to do a single server, actually live on the server below:

PS C:\> Install-Module -Name 'IISAdministration' PS C:\> Get-IISSite Get-IISSite | Select-Object Name,ID,State,'Physical Path',@{n='Bindings';e={$_.Bindings -Join ', '}} | Export-Csv c:\file1.csv -NoTypeInformation

I can't get the physical path to populate but I don't think there is anything to support this apart from spitting out the sites whole folder directory, or just that top level. But as my knowledge is limited and before I go delving deep into this:

1) Is it possible to pull say 50 servers IIS information, list of applications/bindings, maybe physical path etc.

2) And actually have it drop it into a table where its readable, and formatted, whether that be each server is a new tab or it lists which server its pulled it from with a hostname as an ID?

TIA