Export from Powershell to Html

dferreira2 · 2021-03-02T16:06:38.000Z

Hello, I have the following script to be able to see the disk space. I am completely new to programming in powershell.
Right now the script exports two html files with the information I want, but I wanted it to export everything in one file. can someone help?

#Lista de Computadores a monitorar
$listaServidores = @("srvcl02","l-it3")

foreach($servidor in $listaServidores) {
  Get-WMIObject -ComputerName $servidor Win32_LogicalDisk |
 
  where{($_.DriveType -eq 3)}|
  #seleciona os atributos a mostrar e faz a devida formatação
  select @{n='Servidor' ;e={"{0:n0}" -f ($servidor)}},
  @{n='Drive' ;e={"{0:n0}" -f ($_.name)}},
  @{n='Capacidade' ;e={"{0:n2} Gb" -f ($_.size/1gb)}},
  @{n='Livre';e={"{0:n2} Gb" -f ($_.freespace/1gb)}},
  @{n='Percentagem';e={"{0:n2}%" -f ($_.freespace/$_.size*100)}}   |`
      ConvertTo-Html | `
      #Formata o nome do ficheiro
      Out-File ("C:\Temp\AnaliseDisco_{0}_{1}.html" -f $servidor`
      ,(Get-Date -Format "ddMMyyyy"))
}

Neally · 2021-03-02T16:08:03.000Z

Welcome.

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

dferreira2 · 2021-03-02T16:13:39.000Z

I already put it like you said, thanks

Neally · 2021-03-02T16:42:47.000Z

dferreira2:

I wanted it to export everything in one file

Your code specifically tells it to create a new file for each server.

try like so:

#Lista de Computadores a monitorar
$listaServidores = @("srvcl02", "l-it3")

foreach ($servidor in $listaServidores) {
    Get-WMIObject -ComputerName $servidor Win32_LogicalDisk |
     Where-Object { ($_.DriveType -eq 3) } |
    #seleciona os atributos a mostrar e faz a devida formatação
    Select-Object @{n = 'Servidor' ; e = { "{0:n0}" -f ($servidor) } },
    @{n = 'Drive' ; e = { "{0:n0}" -f ($_.name) } },
    @{n = 'Capacidade' ; e = { "{0:n2} Gb" -f ($_.size / 1gb) } },
    @{n = 'Livre'; e = { "{0:n2} Gb" -f ($_.freespace / 1gb) } },
    @{n = 'Percentagem'; e = { "{0:n2}%" -f ($_.freespace / $_.size * 100) } } |
    ConvertTo-Html | 
    Out-File ("C:\Temp\AnaliseDisco_Servers_{1}.html" -f $servidor, (Get-Date -Format "ddMMyyyy")) -Append
}

dferreira2 · 2021-03-02T16:49:44.000Z

Thank you very much for wasting some time trying to help me, but the titles were repeated and I wanted him to do the listing by server. In fact this is all to add to an inventory script that I am creating, but I am having an extremely difficult time creating and then exporting everything.
Not even that simple of the discs can I export.

jitensh · 2021-03-02T16:51:14.000Z

since you are outputting with server names you will get multiples files based on the name of the servers, change it to

Out-File "C:\temp\AnaliseDisco $(Get-Date -Format "ddMMyyyy").html" -Append

Neally · 2021-03-02T16:51:35.000Z

dferreira2:

Thank you very much for wasting some time

Neally · 2021-03-02T16:54:12.000Z

dferreira2:

Thank you very much for wasting some time trying to help me, but the titles were repeated and I wanted him to do the listing by server. In fact this is all to add to an inventory script that I am creating, but I am having an extremely difficult time creating and then exporting everything.
Not even that simple of the discs can I export.

I’m not following?

it creates this for me:

How do you want it?

dferreira2:

but the titles were repeated

oh so you just want the data, not the titles again?

dferreira2 · 2021-03-02T16:54:21.000Z

Use google translator to speak english. I’m sorry that’s not what I meant. Just, thank you so much for your help

dferreira2 · 2021-03-02T16:56:23.000Z

That’s right, thank you.

dferreira2 · 2021-03-02T16:58:03.000Z

I think in mine he had written over it. So it had been duplicated.

Thank you for your help.

Neally:

dferreira2:

Thank you very much for wasting some time trying to help me, but the titles were repeated and I wanted him to do the listing by server. In fact this is all to add to an inventory script that I am creating, but I am having an extremely difficult time creating and then exporting everything.
Not even that simple of the discs can I export.

I’m not following?

it creates this for me:

How do you want it?

dferreira2:

but the titles were repeated

oh so you just want the data, not the titles again?

Neally · 2021-03-02T17:05:23.000Z

try like so:

#Lista de Computadores a monitorar
$listaServidores = "srvcl02","l-it3"

$report =
foreach ($servidor in $listaServidores) {
    $data = Get-WMIObject -ComputerName $servidor Win32_LogicalDisk | Where-Object { ($_.DriveType -eq 3) }
    foreach ($drive in $data) {
        [pscustomobject]@{
            Servidor    = $servidor
            Drive       = $drive.name
            Capacidade  = [math]::Round($drive.size / 1gb, 2)
            Livre       = [math]::Round($drive.freespace / 1gb,2)
            Percentagem = "$([math]::Round(($drive.freespace / $drive.size * 100),2))%"
        }
    }
}

$report | 
ConvertTo-HTML |
out-file ".\AnaliseDisco_$(Get-Date -Format "ddMMyyyy").html"

Neally · 2021-03-02T17:06:33.000Z

dferreira2:

Use google translator to speak english. I’m sorry that’s not what I meant. Just, thank you so much for your help

No worries, English is not my first or second language either :¬)

dferreira2 · 2021-03-02T17:11:53.000Z

It was perfect, that’s what I wanted. Thank you very much.

Neally:

try like so:

#Lista de Computadores a monitorar
$listaServidores = "srvcl02","l-it3"

$report =
foreach ($servidor in $listaServidores) {
    $data = Get-WMIObject -ComputerName $servidor Win32_LogicalDisk | Where-Object { ($_.DriveType -eq 3) }
    foreach ($drive in $data) {
        [pscustomobject]@{
            Servidor    = $servidor
            Drive       = $drive.name
            Capacidade  = [math]::Round($drive.size / 1gb, 2)
            Livre       = [math]::Round($drive.freespace / 1gb,2)
            Percentagem = "$([math]::Round(($drive.freespace / $drive.size * 100),2))%"
        }
    }
}

$report | 
ConvertTo-HTML |
out-file ".\AnaliseDisco_$(Get-Date -Format "ddMMyyyy").html"